Once you switch from an iTVF to a multi-statement TVF you are dead meat and the Fat Lady is belting a tune. You basically get a cursor under the...

julian.fletcher (1/9/2013)

---

Thanks, that makes perfect sense, but I forgot to mention that neither condition A or B were met when the code was run, which means that both A and...

julian.fletcher (1/9/2013)

---

The client's database has a nightly maintenance job to reindex.

Really, I was just wondering if there was a well known reason why

If A Or B

{Something}

might be massively slow while

If...

1) BE VERY VERY VERY careful about slapping indexes on your system using the missing indexes subsystem (or Database Tuning Advisor). They LOVE LOVE LOVE included columns, and they...

Rebuilding index gets you a 100% refresh of statistics. I would be willing to bet (without additional information) that this is a stale statistics issue whereby the optimizer doesn't...

1) database mirroring can be a WONDERFUL HA tool to put in place. But before ANY entity embarks on an HA implementation they need to REALLY spend some grey...

Beware basing SQL Server beliefs on 3 and 5 year old information on the internet...

I believe most modern RAID controllers can do reads down both sides of a RAID10 set, which eliminates much if not all of the benefits of RAID 5 for reads....

opc.three (12/24/2012)

---

It should say "physical cores" instead of "physical processors." I would set it to 6 for the number of physical cores per NUMA node. If you're still seeing too...

Unless your LUN has LOTS of spindles underlying it, I would avoid carving it up into too many different separate sections just to "isolate" activity. The more "disks" you...

GilaMonster (12/19/2012)

---

abitguru (12/19/2012)

---

We dont use auto update. And is hard to find a "slow/off time" .. you know. We are thinking the best way to schedule to run in spare...

It is my belief that this query gets a seek (i.e. is SARGable) as a function-around-a-column because Microsoft KNEW it would...

I used statistics updates as frequently as every hour but for most systems that have some "slow/off time" over night then daily is plenty good enough. What usually ISN'T...

1) 5 is universally a bad number for cost threshold for parallelism. You get WAY too many parallel queries, especially in OLTP scenarios.

2) MAXDOP on the server should almost...

HAH!! Yep - that is about all I use for "logical"...