russ960 (9/10/2010)

---

Does anyone know of a good method to instrument tsql code. Google searches don't provide any good primers. I know of methods to instrument pl/sql and Hotsos...

YES, absolutely, in one of our Web-based 3-tier systems, we have a table that records the start and end time of EACH stored procedure that's called, the timestamp of the...

This concept was discussed extensively in Erland Sommarskog's "Dynamic Search Conditions" http://www.sommarskog.se/dyn-search-2005.html which is a pretty famous article. You should at least link to it in your main article....

sknox (4/22/2010)

---

David Walker-278941 (4/22/2010)

---

This is confusing: "As you can see from the disk bytes/sec counter, there is a considerable savings caused by both row and page level compression, with the...

This is confusing: "As you can see from the disk bytes/sec counter, there is a considerable savings caused by both row and page level compression, with the page level compression...

Jason Shadonix (4/22/2010)

---

dma333 (4/22/2010)

---

Great article. I'd like to see more about how query performance was affected. Also, when backing up a compressed table to a compressed backup, is...

Small issue: "peaked my interest" should be "piqued my interest". It's a little distracting to see "peaked"! Good article, though.

OK, I get your point (both of you!)... I jsut get a little frustrated when so many examples fixate on one kind of thing. (For example, try to find...

This article, like many discussions of Cross Apply and Outer Apply, says "APPLY is named after the process of applying a set of input rows to a table-valued function."

It then...

That's good, if compression makes it into the standard edition. It will speed up backups for small businesses too. 🙂

Too bad that backup compression is not in the Standard edition. But, if you're using the Standard edition, hopefully your databases are small enough that disk space for backups...

"Don't use salary * 115 / 100. This violates the operator precedence rule and gives the wrong result."

That statement is absolutely wrong. The Microsoft page that the article links...

I thought that GUIDs didn't have an order. I am never able to ORDER by a GUID, so why are you able to ORDER BY NEWID() here?

As Piotr said, *try it and see*. Not to sound too harsh, but there is no way that anyone else is going to know whether, with YOUR disk configuration,...

Personally, I would have not created a SQL script at all. I would have created a VBA module (formerly known as an Excel macro) that reads the spreadsheet columns...