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,...

Matt Miller (5/5/2008)

---

Jeff Moden (5/2/2008)

---

Matt Miller (5/2/2008)

---

Grant Fritchey (5/2/2008)

---

How did you know what I had planned for the week-end... 😀

I have to ask though, what's drowning breath exercise? While we...

It depends. All the data is stored in tables. So even when you query a view, except for materialized views, you're querying the tables that make up the view. The...

This is the kind of information you can get out of the Books Online as well as a gazillion third party books and web sites. Do a little basic research...