Service packs we would routinely install on Dev and QA systems as they came out. We'd then be able to get a decent evaluation if they were problematic without having...

How many Pay_Type_ID are left? Because it might make more sense to put in the remaining values as = with a few OR clauses rather than that really long long...

That's absolutely a new one to me. I wouldn't think that defragmenting the indexes would change the size of the backup.

Did you maybe update SQL Backup to a new version?...

It's only going to use 8 at a time. The OS may point it to different ones at different times, but SQL Server won't hit all 16.

Koen Verbeeck (3/19/2012)

---

Grant Fritchey (3/19/2012)

---

Or just perform the MAX statement as a derived table (same thing as a CTE) and join to that. In this situation a CTE just changes...

Or just perform the MAX statement as a derived table (same thing as a CTE) and join to that. In this situation a CTE just changes the location of defining...

Frankly, if I want to see code formatted my way, I just hit the CTL-K followed by CTL-Y.

It's magic.[/url]

Except for the formatting, that code looks decent. If you want bad examples of TSQL from Microsoft you need to dig through the Books Online a little. There are several...

Evil Kraig F (3/15/2012)

---

Grant Fritchey (3/15/2012)

---

GSquared (3/15/2012)

---

Just tell the person you were actually talking about E. Codd's younger evil twin, who had the same ideas and theories, but is using...

GilaMonster (3/15/2012)

---

Grant Fritchey (3/15/2012)

---

Writing the first chapter for this new book, I named Codd. For some reason I thought his name was John Codd. I had a reviewer go absolutely...

GSquared (3/15/2012)

---

Just tell the person you were actually talking about E. Codd's younger evil twin, who had the same ideas and theories, but is using them for world conquest through...

Jack Corbett (3/15/2012)

---

herladygeekedness (3/15/2012)

---

I have also lost jobs on terminology as I am also self-taught. I'm more a data analyst/programmer than DBA but around SQL since 6.5...

jcrawf02 (3/14/2012)

---

IT'S A BOY!!!

I won't get to meet him for a few months still, but very excited!

So now the important question is, do we let him watch Star...

WOW! Well, that's not my house. Last time I asked...

sys.dm_exec_query_stats will show you an aggregate of all the calls against the database for the queries still in cache. I suspect that's what you need.

Otherwise, you can use sys.dm_exec_requests to...