Jeff Moden (8/18/2011)

---

Just in case you don't know... even though you're doing constant backups on the T-Log file during maintenance, IIRC, the TLog file will still grow to about 1.5...

Eugene Elutin (8/19/2011)

---

Jeff Moden (8/18/2011)

---

Just for grins, drop the view, recreate it as it is, and try again. It frequently doesn't do a bloody thing but it can save...

I would focus on the query, the code, not the ANSI settings. That is, unless you have an identical query with a different set of ANSI settings and you're getting...

EjSQLme (8/18/2011)

---

Grant Fritchey (8/17/2011)

---

The size of the transaction log is usually reflective of the size of the transactions. Have you tried monitoring the freespace in the tran log during the...

GilaMonster (8/18/2011)

---

Jim Murphy (8/18/2011)

---

I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the...

If you recreate it with a smaller size, I think that's what you're looking for.

DISTINCT is an aggregation. Will it always increase execution time? No, but it frequently does. It's usually put in as a crutch because someone doesn't know how to properly write...

Just can't tell you a thing beyond what Jeff has suggested without seeing the execution plan.

Numeric 19,0? Not an integer or a bigint? Is that data type the same as...

It sounds like you've hit a regression. These are edge cases where a query that, honestly, should have run slow in 2000, didn't. But now, it does. Every edge case...

The conversation bounced around a bit, but it sounds like you could use three things. First, and most importantly, a well documented development & deployment method that you can enforce...

More than likely it filters the tables and then combines the results. But, you should look at the execution plan. That will tell you precisely what happens.

This is how Microsoft suggests you get that job done.

There are several different tools from various vendors that advertise this feature, but frankly, they're either weak or dangerous. I wouldn't recommend using any of them at this point in...

Those are ANSI standard settings. I'd say it's a good practice to have them on, but I don't think you'll see performance and indexing changes from having them enabled.

What performance...

Perry Whittle (8/17/2011)

---

not available in SQL Server 2005, you will need...