Appreciate your feedback, guys. I like the looks of Lowell's script. Actually, I use logic very similar to that myself. I dont update stats blindly, I actually check to see...

The Quest e-book , page #77 was an excellent tip. I have a crappy network that seems to decide on it's own whether DNS works or not. I had to...

Guys - I have the same problem. This is not a simple A-B-C back to basics problem. This also happend to me after moving tempdb to another drive. I think...

Thanks everyone - I appreciate your inputs.

We have been test driving Diagnostics Manager & Spotlight for the past few weeks. We liked both tools, but we found that Idera's...

that would be a correct statement. The size of your secondary files are dictated by the size of the objec ts you are moving to that filegroup.

We did some comparison's between RedGate, Idera and Litespeed a long time ago, and Litespeed won out. We've been using Litespeed at my current job for about two years, and...

do you mean if SQL can handle unicode character's ? If so, yes of course. As long as you choose Unicode data types to represent the data you need to...

Table variables are indeed very slow when processing even moderately sized result sets. I have a proc that produces, in one use case, about 2200 rows. This table variable needs...