You need to examine what is happening when the application is slow. SQL Trace is the best way to do this, along with something like WhoIsActive to find what is...

Cadavre (2/6/2012)

---

Tried polite and unpolite impolite comments directed at him, neither received a reply so...

GilaMonster (2/6/2012)

---

If it was the only time he'd done that, I'd agree with you, but at least half of his posts are of links that are completely unrelated to the...

OK, #5 seems to be fixed. Posting from IE8, and copy/paste to SSMS 2008R2 preserves line breaks for me.

In terms of #s 1 and 2, we have some ideas,...

Are the 5mm records all the records in the table or are there more than 5mm? If that's the whole table, use truncate. If not, you can batch the deletes...

David has some good advice. I would personally determine the database size, allow for 3-4 months data growth, and then make sure you can reindex your largest table. Then shrink...

Koen Verbeeck (2/6/2012)

---

It seems we have a personification of Google on these forums:

http://www.sqlservercentral.com/Forums/Topic1246473-391-1.aspx?Update=1

Now he is just copy pasting MSDN articles into the topics. :rolleyes:

At least it had something to do...

HowardW (2/6/2012)

---

This one's particularly amusing in that not only does it have nothing at all to do with the topic, but it's not even T-SQL, it seems to be for...

Noted, and passed to the publishing team.

1. I'm not sure how easy the first item is to fix, but we'll see. Definitely an issue.

2. Again, not sure, and not sure...

Over a foot, I think. Hard to tell since the wind is blowing...

Just so you know, Colorado is great.

This was my conference call on Wed morning, in a long sleeve shirt.

This was today:

Brandie Tarvin (2/3/2012)

---

Do the Google thing to all your computers then tell the family that the blizzard is so bad, it's snowing in...

snow, snow, snow.

snow. coming down, not too hard, but steady.

Grr, I hate CS databases.

Note added to the question