The Dixie Flatline (7/28/2014)

---

; -- This is a totally irrelevant semicolon. If it is truly a terminator, what does it terminate?

select something from something

; -- Everyone should be happy...

The Dixie Flatline (7/28/2014)

---

I personally would do it like this

;Statement1

;Statement2

;Statement3

; -- yes, one left over

Why? Because even with indentation, semicolons can get lost over on the...

Sean Lange (7/28/2014)

---

Lynn Pettis (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

---

Sean Lange (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

I'm looking at the replies in this very post. Diarrhea? Yes, probably "good natured fun" as probably seen by the...

Sean Lange (7/28/2014)

---

patrickmcginnis59 10839 (7/28/2014)

I think in your case if you'd have answered the cursor question first, and then said "then watch for performance issues as cursors on SQL Server...

patrickmcginnis59 10839 (7/28/2014)

---

Ed Wagner (7/28/2014)

---

SQLRNNR (7/27/2014)

---

So they named it stack overflow because...

So they named it stack overflow because it is really just Diarrhea?:Whistling:

matt6749 (7/26/2014)

---

Looks like limiting the transaction log size to 30mb is not the answer:

Message = "The transaction log for database 'Customers' is full. To find out why space in the...

Koen Verbeeck (7/26/2014)

---

Eirikur Eiriksson (7/26/2014)

---

Koen Verbeeck (7/26/2014)

---

Sean Lange (7/25/2014)

---

Eirikur Eiriksson (7/25/2014)

---

Sean Lange (7/25/2014)

---

Eirikur Eiriksson (7/25/2014)

---

Jeff Moden (7/25/2014)

---

Sean Lange (7/25/2014)

---

WOW!!! If you have ever wondered about the quality of responses at...

Control (think sql prompt shortcut keys)

Sean Lange (7/25/2014)

---

SQLRNNR (7/25/2014)

---

Sean Lange (7/25/2014)

---

WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate...

Sean Lange (7/25/2014)

---

WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.

Most...

abrasive

We should certainly look to data to guide us and perhaps even justify our decisions, but we can't forget that the human brain is still an important part of any...

matt6749 (7/23/2014)

---

Thank you all for your valuable help.

The hosting company has done this (hope it's ok):

They said they do nightly backups. They set my recovery mode to Simple and restricted...

Raghavendra Mudugal (7/24/2014)

---

Thank you dave, for the post, very good one.

I just went with eliminating the odds method and then I was stuck with 2 and 4, I read the...