lmu92 (5/11/2010)

---

If that's the only purpose...

What is the query you use to determine the IO of these queries. Some DMVs are cumulative in nature and thus could be skewing the numbers.

As for the select...

If you want multiple databases on a single server, you create a new database on that server or restore a backup for that database to the server.

Doing it from a trigger standpoint is a bit tricky. You would need to be able to capture instantaneously what the person ran. You could include code to...

I would recreate the clustered index first.

Second part of your question. What is the code that you are running to rebuild indexes? The answer to your question may...

Nice article.

Cruciate

K. Brian Kelley (5/11/2010)

---

box4garbage (5/11/2010)

---

It looks like any meeting is just a waste of time. I can hardly imagine a problem or theme for meeting which is impossible to solve...

Great question. I learned something good today.

Posterity

You can add mine as well.

Yeah - still trying to find a topic since I have blogged on the topic several times since the last...

Grant Fritchey (5/11/2010)

---

Several of those queries are loading data into temporary tables and then loading the same data into permanent tables. Why? Can't they just run the query to move...

Running Behind

I don't much like review period either. Too much anxiety and other things to do.

Two things to make the annual review that much worse:

1. Quarterly Reviews

2. Self-Review...