Fal (10/24/2012)

---

bugg (10/18/2012)

---

SQLRNNR (10/18/2012)

---

I've done the 24x7 oncall on my own. Even if they promise you the vacation and that so and so can cover that week - don't...

Thanks for the question.

Interesting question

Thanks Ron.

LAB

sqldba_newbie (10/23/2012)

---

SQLRNNR (10/22/2012)

---

sqldba_newbie (10/22/2012)

---

Vegard Hagen (10/22/2012)

---

Most likely you've come across a piece of bad application code that doesn't clean up after itself.

All temporary objects created in tempdb must be dropped...

Here is a tool that others have had work

http://www.officerecovery.com/mssql/

vk-kirov (10/23/2012)

---

call.copse (10/23/2012)

---

I liked this question, as I wondered whether anyone would try running the sample code, and what would happen if they did (and I got it right comfortably!)....

Perry Whittle (10/22/2012)

---

You just need to ensure that you have backups of all certificates (public and private keys) and backups of all the databases too. It might also pay to...

sqldba_newbie (10/22/2012)

---

Vegard Hagen (10/22/2012)

---

Most likely you've come across a piece of bad application code that doesn't clean up after itself.

All temporary objects created in tempdb must be dropped when you're...

Jeff Moden (10/22/2012)

---

bugg (10/18/2012)

---

Okay, you guys are starting to scare the sh*te out of me . Why are you DBA's willing to sacrifice so much of your "free" time,...

Koen Verbeeck (10/22/2012)

---

Lokesh Vij (10/22/2012)

---

kapil_kk (10/22/2012)

---

in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert...

Suds. one stinking mis-click though I intended to click permit identity I slipped and hit the wrong check box.

Grrrrr...:-)

Nice Job Ben.

Sean Lange (10/19/2012)

---

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No other...