If you really want to do it all manually, I'd look up one of the blocking scripts that are posted online here. Get a newer version for 2008 , not...

ScottPletcher (3/25/2014)

---

Grant Fritchey (3/25/2014)

---

I can't see the query since it exceeds the size of what's stored in the plan, so suggestions from the plan alone are going to be a...

Rows will be limited by storage and that's storage in tempdb. Here's a listing of all the limits on SQL Server. Books Online is always one of the single best...

I can't see the query since it exceeds the size of what's stored in the plan, so suggestions from the plan alone are going to be a bit vague.

First off,...

Do you need the aggregation of DISTINCT? Are there data problems you could fix instead of using DISTINCT? You might want to try attacking that. But, I'm with Gail, without...

That's what a reporting tool is for. SQL Server and T-SQL are a horrible place to do that kind of formatting.

Caruncles (3/25/2014)

---

I'm also interested in this setup. We have agent jobs performing a full backup every 24 hours and transaction logs every hour (both to local folders). The last...

Default values are extremely low cost. I'm not even sure if you can measure that. You pass a NULL value and something else is used instead. When you said constraints...

Yep. That's it.

I'd suggest double checking the data in the column. It sounds like you may have text data mixed in with the numbers.

A literal is a string or number used within the query, not a variable or a parameter, but a literal value.

Then, the plan isn't cached. Period. It's not inside or...

Try running the query without the WHERE clause. You'll note that there are tons of plans right there in the cache that are larger. If there is a literal within...

It completely depends on how the constraints are defined. The primary pain points, if any, will be on inserts and updates. It won't affect selects at all. The best answer...

We're going to need you to come in this weekend to work on those TPS reports, mmmkay?

GilaMonster (3/24/2014)

---

Ed Wagner (3/24/2014)

---

WOW! Now that's enough to scare anyone. Just think...he has access to the...