Viewing 15 posts - 3,706 through 3,720 (of 5,843 total)
farax_x (1/12/2011)
I had the same problem and I changed some queries with [with (nolock)] and fastfirstrow ,... to reduce locking and rebuild with ALLOW_PAGE_LOCKS = OFF, ONLINE = on...
January 12, 2011 at 2:52 pm
farax_x (1/12/2011)
Check queries that have high cpu usage using activity moitor, then by thinking on execution plan u can solve problem. sql profiler + advisor may also help u.
I am...
January 12, 2011 at 2:48 pm
Grant Fritchey (1/12/2011)
TheSQLGuru (1/12/2011)
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.
Proof positive that...
January 12, 2011 at 11:44 am
churlbut (1/11/2011)
So what you are saying is his coding stinks and he should buy your books?
No, Joe is simply pointing out that he is a small-minded person that has no...
January 12, 2011 at 9:04 am
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.
January 12, 2011 at 8:57 am
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...
January 12, 2011 at 8:54 am
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...
January 12, 2011 at 8:51 am
srik780 (1/10/2011)
waht is cpu bottleneck and what will do when it occurs?any one plz
A CPU bottleneck is when your CPU(s) are running so much that your performance suffers due to...
January 12, 2011 at 8:49 am
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...
January 12, 2011 at 8:48 am
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...
January 11, 2011 at 8:08 am
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...
January 11, 2011 at 8:04 am
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....
January 11, 2011 at 8:01 am
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....
January 11, 2011 at 7:59 am
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...
January 11, 2011 at 7:52 am
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...
January 10, 2011 at 10:54 pm
Viewing 15 posts - 3,706 through 3,720 (of 5,843 total)