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.

If you are doing a bare metal restore with some software, where are the MDF/LDF files? The bare metal restores I've seen (and they rarely work, in my experience), include...

My apologies for the plagiarism. I have removed the article, and reported the author to OSI Consulting[/url], the employer whose email server was used to send the article in.

Restore syntax: http://msdn.microsoft.com/en-us/library/ms186858%28v=SQL.100%29.aspx

There isn't a good example there, but basically

restore database xxxx from disk = 'yyyyy' with norecovery

restore log xxxxx from disk = 'zzzzz' with norecovery

restore log xxxxx from disk...