I can't speak for anyone else but I've had great success in setting maxdop so than no one process can use more than 25% of the CPUs available and then,...

It's not just parameter sniffing to be concerned with.  You need to check the datatypes of the parameters in the sp_cursorprepexec with those in the table.  For example, if Entity...

This is nuts and it's all because the wrong data type has been used for the column.  Petition management to have it changed to a correct, self-validating temporal datatype and...

To add to what Luis posted, you have to remember that, unless you're in some other Recovery Model other than FULL, index creation is fully logged.  If you have a...

UGH!  This is what happens when people try to be "smart" about how to store dates and times except for maybe in a Calendar table.  This problem would be a...