I would probably go with option 2. If one fails, exchange the drive - reboot.

I see this practice more often than I would like. Code that is untested and released to prod. Or different code released to prod than what was released...

LutzM (1/23/2012)

---

Referring to your first link: He asked for...

Make sure you do that entirely in TSQL

facet

Good question Steve.

GilaMonster (1/22/2012)

---

You didn't mention you'd restarted the server...

Any evidence of what caused the growth would have been erased by...

Here is an article outlining a method to help find what causes the growth.

http://www.sqlservercentral.com/articles/Log+growth/69476/

Yay - SOPA has been shelved.

Try this article for some assistance

http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

Do them separate. ...

Hugo Kornelis (1/20/2012)

---

Hugo Kornelis (1/20/2012)

---

Richard Warr (1/20/2012)

---

Or from http://msdn.microsoft.com/en-us/library/ms175997.aspx we see that COUNT() returns an Integer. What happens to SELECT COUNT(1) FROM myTable when myTable contains more rows than an...

Best toy ever - until your child swallows them.

NP - I am looking at your query but...

@padhis - Thank you.