Grant Fritchey (1/12/2011)

Proof positive that...

No, Joe is simply pointing out that he is a small-minded person that has no...

I advise my clients to avoid ALL UDFs of ALL flavors simply because there are WAY too many ways to get in trouble with them.

You can do your reindexing in parallel by explicitly using multiple jobs that operate on portions of your tables exclusively. Michele or Ola's stuff (latter is my preference because...

For a small database I wouldn't worry about it.

But if you want to keep user objects out of the Primary data file, consider the use of DDL triggers to check...

A CPU bottleneck is when your CPU(s) are running so much that your performance suffers due to...

IIRC there was a massive thread here on SSC about how to create comma delimited lists, with lots of code samples and benchmarking. Likewise one to do the reverse...

To make the trigger and email sending more 'bullet proof' and completely asynchronous, I would simply put the requisite PK (and perhaps some payload if you must) into a driver...

before you go adjusting ANYTHING, you need to find out EXACTLY what the symptoms are!! Do a file IO stall and wait stats analysis. Then base decisions on...

whenever I use sp_msforeach... I always SET QUOTED_IDENTIFIER OFF first. Then I can use DOUBLE quotes for the outer (executed) strings and then single quotes for inner string creation....

Sandeep... since you are new here (first post it seems): 1) WELCOME to sqlservercentral.com 2) PLEASE look at the dates of the threads before you post to them....

There are sooooo many ways using inconsistent datatypes can harm performance! I have been preaching this to clients (and cleaning up messes related to it) for over a decade...

I think what is happening is that you are needing data regularly but the IO system (largely via read-aheads I bet) is getting the data into the buffer pool in...

RedGate has recently announced V2 of their Monitor product. It does quite nicely I think.

If you want something more high-end I highly recommend SQL Sentry's Performance Advisor product.

1) the cause is often due to bugs, especially in drivers. windows 2003 had a large file copy bug that did this and HP's ILO stuff likewise. I had a...