I'm closing this thread. It's gotten a little silly overall.

Lennie, I would disagree that others have accused you of anything or been rude. They have tried to show you the...

bcsims 90437 (9/13/2010)

I like...

If this is going to be the bad joke section of the thread, let me know when it's over. Not sure I can take more than another joke or 10...

I don't often take the dogs, but they like the 2-3 mile runs I do.

16 miles, haven't done that in a long time.

I would agree with Jason. Typically this occurs when you have in implicit conversion taking place and there is data in the table or code that is cannot be an...

The Rockies are doing something. They were down 1-0 for a lot of the game Sat night (I went with my son) and then they scored 2 to win,...

Is there perhaps a task in the package using this connection?

I don't have a 2005 instance to check this on right now, but can you save/store this in the file...

Under Management, there should be a "Maintenance plans" folder. Click it, then double click your plan. It should open in an editor.

This one is good: http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_3?ie=UTF8&s=books&qid=1284393802&sr=8-3

Note that with physical access, a Windows admin could find a way in. If this is just to prevent issues from Windows admins making changes, go the administrative route, and...

You can't get this from T-SQL. You would have to call some Windows functions to get this, and you can shell out somehow to get those from T-SQL, but it's...

SanjayAttray (9/13/2010)

Steve, it's a pure form of plagiarism. But, why take the rating out for article. It's a well written...

Mike,

good points, although often we have the plans cached, so I'd expect that if I run a query regularly, I'm getting the same plan every time.

Perhaps this isn't a great...

Ultimately you need to test and get an idea of when it's quicker which way. It often does depend on how much data, and your disk I/O.

Please start a new thread and explain your issue better.