Hi , I am having a database of 55 GB size and the jobs use a lot of tempdb database in one job cycle it inserts 242 million records . I had tempdb...
Hi all, I am having issue with tempdb . Initially i was having a 120gb drive and a four processor machine. I have splitt the tempdb into 4 files...
Hi Guys, I have a query that is taking along time to complete.... and i am not able to figure out how to rewrite it. Can anybody help in this...
Hi Adriaan , I will try to test the data with both the options . I have one more issue Do you have any idea regarding splitting the database files so...
Hi Adriaan, Thanks for the quick reply. It is good option to do that way but will the table variables or the temp tables degrade the performance ......
Hi Guys, I am working on a performance tuning project but was not able to rewrite the below given procedure with out using cursors could any body...
Separate names with a comma.
