David Webb (8/31/2009)

---

If you do an explicit

BEGIN TRAN

then select, update or delete something, the locks obtained by the DML statement should be maintained until an explicit commit or rollback is...

Been there, done that. Thank goodness it was a relatively small table, and I had a backup. But the nauseating feeling just...

I just plain got it wrong because of the int @c, after focusing too much on confirming the 21 * 0.5 calculation. Good question in that it highlights rookie mistakes...

I think this is a fascinating and important thread - perhaps it can be made into an article.

I also wonder - can you guys help the user set up something...

Thanks, great question. Usually "great question" means one where I don't know enough to get it right, so I was happy to get this one right, and for the right...

Thanks. What if I started with a...

Alvin Ramard (7/9/2009)

---

webrunner (7/9/2009)

---

Thanks. Do you mean you...

Thanks. Do you mean you can right-click the...

Jack Corbett (7/7/2009)

---

The procedure does not return a result set. The 0 or 1 is the RETURN value of the procedure. So you need to run it like...

Thanks for this information! I tried this command in master:

sp_testlinkedserver [mylinkedserver]

and got this response:

Command(s) completed successfully.

Not a 1 or a 0 as the documentation says are the possible responses.

Does "Command(s)...

Disaster Recovery:

Mannin' the Mirror (Michael Jackson, RIP)

Maintenance:

Upgrade (Beyonce)

Storage:

iSCSI of the Tiger (Survivor)

Drive (The Cars)

This is fun....

Great question. I lucked out by picking the right answer for the wrong reason: I mistakenly thought committing transaction T2 committed T1 as well, not that table variables ignore transaction...

drnetwork (6/23/2009)

---

Before I was a DBA I used to operate nuclear reactors for the US Navy. To be a qualified operator (in my case an EOOW) we had to (1)...

TVR (6/23/2009)

---

I think this is exactly why certifications are important.

For instance, if the person pass the MCTS exam, that person should be "capable" of fulfilling a junior/intermediate DBA role and...

Dan Guzman (6/19/2009)

---

I'm a wizard man myself, as I've learned, I then take apart the wizard'd scripts and modify them, that way I get the best of both worlds, and...