"Basically I want to get around nested select statements by using temp tables"

Make sure you really want to do this. MAny times a subquery approach can dominate any...

I had many problems with this exact scenario. I was able to waggle enough downtime to repopulate everything fresh on the 2005 instance.

AIKE!! The application tier stealing a top secret execution plan. All power to shields!!!!

That sounds kind of cheesey. Have you research the exchanged API or development kits. You could proably get faster help on an exchange message board. Sorry cant point you...

I dont think Parallelism and Tempdb disk contention are related.

I have first hand experience. We were given 4 dedicated RAID 10 spindles and created a tempdb file on each...

There is a group in the msdb database that will allow non-admin users to view jobs. I am in a tight game of yahoo chess or i would look it...

Is y a OLTP or OLAP table? I would start going down and analyzing which proc had the smallest transaction scope, especially if y is a heavily used oltp table.

I have never done this. This would lead to a huge security hole and a million other problems. Consider having an application layer do this for you. It will be...

Great article, thank you.

I would be very surprised if Full text would help out with performance issues. Would need a little more info on what your actually trying to fix. The only...

Fellow Data warrior,

Please listen to the wise posts warning of with(NOLOCK). These are very senior individuals in our field who would not warn if this was not a major issue....

I dont see where you updated the value for TEXT\Image filegroup to point to the new filegroup.

I am assuming you are trying to get your blobs pages away from your...

Wow, I would never feel comfortable posting my internal schema object names to a public forum. Hoping you made the object names forum safe.

Might be of intrest to see what...

🙂 Rants cary over, so you get two tommorrow.

Do not have you stored proc/data tier wast time doing this. Have the middle tier do this for you. Its not a super efficient process for that tier, but it...