Dave Ballantyne (1/6/2010)

---

GilaMonster (1/6/2010)

---

Why are there so many 'if you don't help me I'll lose my job' posts all over the place? I just got one by PM. Frankly, seeing...

Lankford

Mattingly

Dale Murphy

McGwire (don't care about the alleged steroid use - too many baseball players use them for that to be a fair argument)

Dawson

Maybe Larkin

As John said, using the NOLOCK will not guarantee that a deadlock does not occur. It is a strong suggestion to the query optimizer - but may not be...

It is the same process. The reason you may run into problems is due to Policies that may or may not be place at the OU level. Another...

I would go for the query rewrites at this point.

With the recovery model set to full, you should consider performing Log backups (15min, 30 min or some other interval).

Or, if there is no need to be able to perform...

Good Advice

John Rowan (1/5/2010)

---

This should be treated just like any other server move within your network. This is a network access issue, not a SQL Server one. As long...

c00ler01 (1/5/2010)

---

Hi,

I would turn off 6 gb limit since 1 day it might crash horribly.work on a new process to assess the growth.10% in my opinion should be changed to...

Quinn-793124 (1/5/2010)

---

We have a GIS system based in SQL Server 2005. The log file from one of the DB's keeps filling up and we cannot figure out what is causing...

GilaMonster (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

Actually, nothing earlier indicated that it was urgent, so more...

GSquared (1/5/2010)

---

CirquedeSQLeil (1/5/2010)

---

Hey Gus, I have an urgent need for a stored proc. It needs to join an Oracle, DB2, and SQL table and be heterogeneous.

I need it done...

Thanks for the update.

Hey Gus, I have an urgent need for a stored proc. It needs to join an Oracle, DB2, and SQL table and be heterogeneous.

I need it done 3 weeks...

Gus is still riding that emotional high from the new employment opp. He can...