Ninja's_RGR'us (3/21/2011)

---

Grant Fritchey (3/21/2011)

---

If you're getting an index scan, you should try to understand why. Is there something in the code, such as a function on the column, that is...

It's not that kind of site.

Ninja's_RGR'us (3/21/2011)

---

GilaMonster (3/21/2011)

---

Ninja's_RGR'us (3/21/2011)

---

Grant Fritchey (3/21/2011)

---

If you're getting an index scan, you should try to understand why. Is there something in the code, such as a function on the column,...

Let's see, movies, games, surfing the web...

For work?

Not much. I've done some writing on it because I have the ZaggMate keyboard. I take notes on it. I use it to...

Whether the table is large or not, if you have the write indexes on it, you should be able to retrieve your data easily. You might want to consider partitioning...

If you're getting an index scan, you should try to understand why. Is there something in the code, such as a function on the column, that is causing the scan?...

I'm with Steve. I wouldn't advocate putting artificial data, especially financial data, into the database. It's just too likely to cause problems down the road.

Just to state it as clearly as possible, nesting views is generally a bad idea.

Same goes for nesting functions.

The query optimizer is smart and effective, but it will throw up...

If you've validated the data with SQL Data Compare, also validate the structure with SQL Compare. I'll bet other things are missing.

When you're not sure what a query is doing...

All true but, the load placed on the TEMPDB by the consistency operations won't go away and could lead to to contention. If I was going to bother with offloading...

I agree with Pam, first place to look is the actual execution plans. Are they different, if so, what are the differences?

Another option to check, what are the ANSI connection...

[Jim].[dba].[Murphy] (3/18/2011)

---

I have to agree; also helps minimize the...

Honestly, on most systems, on most databases, I just use the defaults. It's pretty rare that suggesting a marginal change in sampling rates will make that big a difference to...

GilaMonster (3/18/2011)

---

"The SAN can't possibly break" -> ROTFL. The worst database disaster I've seen was due to a faulty SAN controller.

Test the backupexec full with the log. I have not...

Depending on the system, you may want to take the consistency checks offline, perform them on a restored copy of the database or something. I'd move that away from any...