Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

dinesh8804 (2/6/2012)

---

Nothing like that i have used what u said like only..creating temporary table and using joins only..Thanks for ur help...I just want to know whether its possible or not..But...

cengland0 (2/6/2012)

---

GSquared (2/6/2012)

---

Running the SQL code inline, instead of in procs, doesn't actually help with that. Well, unless the people stealing it have never heard of Profiler or traces,...

Probably not a deadlock or maxdop issue. If a shared connection suffers an error that closes the SPID (16 or higher, if I'm not mistaken), then anything else trying...

Artificial status hierarchies are just that, artificial.

A Senior DBA will often be better paid than his manager is, so "promotion" becomes simply a change in role.

The list you gave for...

Beyond what Grant says, MS recommends setting maxdop to 8 on servers with more than 8 CPUs, because the cost of spreading the job out will be more than the...

Jeff Moden (2/6/2012)

---

Heh... you guys must be talking about my recent favorite candidate for the "Flying Porkchop Award". I just dope slapped him where he posted two links that...

GilaMonster (2/6/2012)

---

Grrr...

1 - http://www.sqlservercentral.com/Forums/Topic1247308-391-1.aspx An article on SVVM in reply to a question on SQL versions.

2 - http://www.sqlservercentral.com/Forums/Topic1247195-392-1.aspx A while loop to delete all the rows in a table is...

It is possible to join without using Join.

You can Union the tables and then Pivot them. It's a bad idea, takes a lot of work, and you need to...

cengland0 (2/6/2012)

---

jcb (2/6/2012)

---

SQL Injection and Performance are 2 items from a wide list why I hate dynamic sql.

Some app use, at least, parameterized dynamic sql and it blocks most problems...

Now you're just trying to make me jealous! 🙂

75F here in Orlando. Just about perfect out for a picnic or something comparable....

That (a) won't give the results he outlined, and (b) uses a Join, even if it avoids using that word.

What editors? We just want a sneak preview, and we're willing to point out a missing comma or two in order to get...

GilaMonster (2/2/2012)

---

Anyone interested in proof-reading an article on bulk-logged recovery and minimally logged operations? It's titled as an introductory article, but I read the log and might end up with...

Nadrek (2/1/2012)

---

mtillman-921105 (1/30/2012)

---

Well, if they're not already doing so, I hope that new programming languages start using another delimiter for strings other than quotes. Even brackets "[]" would have...