Roy Ernest (5/26/2011)

---

I have an idea for one of persons who want to go to SQL Pass summit for free (Except air travel). Make list here who wants to go...

Jack Corbett (5/26/2011)

---

Grant,

Isn't the compile time for large procedures why they changed to statement level compile with 2005? In theory the whole procedure should not need to be recompiled...

Stefan Krzywicki (5/26/2011)

---

Gianluca Sartori (5/26/2011)

---

Jeff Moden (5/25/2011)

---

You have the right...

You're still guaranteed a recompile each time a temp table is created and first referenced.

GilaMonster (5/26/2011)

---

Fraggle-805517 (5/26/2011)

---

When my company writes procedures, it often passes in a QueryType to a stored procedure. This is so that they can keep code in one place for...

I'm sorry, normally I let this stuff go, but, seriously, Waiting? I'm in here helping out because I want to be, not because you're paying me....

Yeah, it's just logical processing. You can see that none of the salaries fall within the >500 < 1000 range, so how did the first two queries return data? Because...

Wow! Well done. I usually run about 1/5 of that.

Not so much a how to, but I recently posted this article on how to prepare[/url] for being the on call person.

For what it's worth, there is no average on-call...

GilaMonster (5/26/2011)

---

Grant Fritchey (5/25/2011)

---

Steve Jones - SSC Editor (5/25/2011)

---

Is...

I'm not a fan of intellisense, when it works, it doesn't do enough.

That said, instead of sp_who2, take a look at sys.dm_exec_requests and see if you see an active connection...

I don't know that I'd say there is a "best" strategy. However, there is one fundamental truth. Your backups are only good if you can restore them. So you run...

That's a good idea to know exactly how long it was there. To just get an idea of how long it's been there at a moment in time, take a...

When you create temporary tables, you get a recompile. When you add a row to temporary tables, you get a recompile because of the stats updates. Then, statistics can get...

Another person just recently had an issue where someone posted millions of rows and was doing sorts on unindexed columns while they did so, smacked tempdb good and hard. It's...