That depends. It could be that it's returned to an application as a result set and then run as a script by the app. It could be that it gets...

We pretty much rely on the application side checks after a successful restore. As you point out, restoring successfully doesn't mean you restored the right thing successfully. DBCC and other...

No, no, no. Jeff's smarter and better looking. I'm.... uh, I'm.... Hey!

I've been staying out of this one, but I have to agree with Jeff. The more you practice writing set based queries the easier they get. Add to that the...

Don't substitute table variables for temp tables unless your data sets are very small. Table variables don't have statistics generated against them (except when they have a primary key and...

I'll have you know I'm down to 203 and at 6'1" that's not big, just a tad plump. It's sitting on my brain all day long that causes the problems....

Everything already stated is very true. Code, tables and indexes are going to be your worst problems. However, you can be sure that you've identified the really simple stuff if...

I should be too embarassed to reply, but what the heck...

Scans are usually bad, but not always. Depending on the scan itself, it means it's reading all, or a substantial...

You said above that you ran the code against CustomerId and it worked. I'll bet CustomerId is an integer column.

And what level of access does that user have? Is the server set up with 'sa' and no password?

Yes, setting up procs is work, but your core issue is...

It's not an alias you're looking for but some formatting. Try changing to this:

CAST(SizeInGigs=floor( backup_size/1024000000) AS VARCHAR) + ' GB'

An alias is a way of masking or changing a...

The only thing I can think of would be to lower the cost threshold for parallelism. But then you're likely to see multiple threads in queries that will not benefit...

I nornally wouldn't pile on to something like this with a...

What about trying it like this:

select * from customertable where customercode = '01042'

If customercode is a string, you need to wrap the number being passed so that it's a string...

I didn't read through everything, but you are issuing DDL commands within your procedure which will cause recompiles of the procedure while it executes. That may not be the cause,...