Just remember that a clustered index is the table, so it may look very large, but that's because it's storing all the data.

You're posting in the 2008 forum.

Not sure what you mean by batch delete. SET ROWCOUNT just limits the rows returned, but the query plan and the access of the data...

The key is to make your queries run as fast as possible and keep the transactions as short as possible. So, if you're running an UPDATE statement, make sure it's...

Instead of using SET ROWCOUNT, actually filter the data using some other criteria. SET ROWCOUNT is deprecated anyway and removed from the product in SQL Server 2014.

You've restarted the server, which rebuilds tempdb, and you're still seeing this? I strongly suspect hardware issues then.

Cody K (3/27/2014)

---

From what I've seen where people actually tested this out, it's no more than 10%. I guess there are environments where...

jcrawf02 (3/27/2014)

---

We have a written test we use to weed out people who don't know the first thing about SQL (report writing position, not DBA stuff), it's pretty basic, but...

Came over here to answer your question and I find that Barry has already covered it better than I can. I'm out!

Sorry, I'm missing something then. I don't see a question...

robin.pryor (3/27/2014)

---

Ah but the question "What landed me on this post in the 1st place?"

I'm a SQL DBA and I've never given a crap about schemas. I know what they...

robin.pryor (3/27/2014)

---

Sean Lange (3/27/2014)

---

robin.pryor (3/27/2014)

---

MarkusB (1/7/2009)

---

You call yourself SQL DBA and ask such...

If you're going to use sys.dm_exec_requests to monitor, you'll have to capture it over and over again then write a query that shows the changes over time. As far as...

I think Igor largely nails it. I'd concentrate the aggregations into the view. That's the stuff that is going to be the most costly in your queries, so doing that...

I don't that Profiler is the best tool. In fact, Profiler, the GUI, is a somewhat dangerous tool to point at a production server. It can actually cause performance problems.

My...

Assuming you're trying to replicate the production environment, I'd have whatever type of fragmentation management you have in production in place on the test machine. Same with statistics maintenance and...