I'm not sure it's stealing, but it is illegal. Right or wrong, there are license terms to use software. You should stick with them to avoid fines. And possibly the...

Errands

This is how I roll: beautiful girl, beautiful ride.

Congrats to Gail and the other MVPs awarded today.

I like sturner's code. The one thing I might change is adding in a delay between loops, especially if this might take enough time to cross a log backup. Can...

Added an order by to the question.

Sorry to hear that, Kevin. Keep your fingers crossed and hopefully disaster doesn't strike.

Index order is driven by sargability. You wouldn't move a column up in an index because of the data type. You place them based on what is most likely to...

Sorry, yes, in developer as well. I was thinking about production level stuff. I think it ought to be in Standard, web, Express.

I'm with Grant. Lots of testing has shown that above 1MB files, the file system is much faster. It does complicated backup/restore/sync with the db, but you can write a...

Have you checked the System/Security logs for messages?

Agent typically won't start if the db engine doesn't, so worry about SQL Server relational engine.

As mentioned, not a lot of difference. I'd train on 2008 and most things will apply to 2005. Plus you'll learn what not to do, or change, in 2005 to...

Eugene's code should help you. You basically write a query that you want to insert (can be columns or scalars) and then add that to an insert clause.

I don't see it in BOL, but it should be in Inside SQL Server (Delaney) and show that all fixed length data comes first, then offsets to var columns on...

This has been my experience. Delete the plan, the job goes away. It does in 2008 , SP1, just tried it.

This is huge, and I'd recommend you format it so it can be better read. Put the joins on separate lines, the FROM, the WHERE, etc.

In terms of your execution...