Viewing 15 posts - 4,756 through 4,770 (of 5,843 total)
su5y (4/20/2009)
--------------------------------------------------------------------------------
what do you mean regards to statistics? We are looking at the paging file this morning which is currently on the c drive which may not be big...
April 20, 2009 at 12:30 pm
su5y (4/20/2009)
April 20, 2009 at 10:16 am
It is a very common misconception that WHILE ... LOOP over a collection of records is better than a cursor. The costs associated with setting up/managing a cursor or...
April 20, 2009 at 5:53 am
1) Output the query plan as text or XML and post THAT in your document. Those things get HUGEly bloated and make even simple queries look like a nightmare....
April 20, 2009 at 5:49 am
1) Statistics are out of date. Consider updating them nightly.
2) You don't have a max memory setting and sql server is taking too much RAM.
need much more...
April 20, 2009 at 5:47 am
bitbucket (4/19/2009)
Paul White
The answer is..."it depends!"
Sometimes, a cursor *is* the optimal solution. Not often, but it does happen.
Paul care to post some code that shows an example of where a...
April 20, 2009 at 5:46 am
Swirl80 (4/13/2009)
2) Please refer to my original post, whoever set our san up originally (before my time - believe it to be DELL themselves) created 4 RAID groups...
April 13, 2009 at 7:58 am
Swirl80 (4/11/2009)
1) Will putting the tlogs on the raid10 be still as quick even though there are numerous log and data files on there? Can...
April 13, 2009 at 6:30 am
RBarryYoung (4/10/2009)
Steve Jones - Editor (4/10/2009)
Sorry should have noted. I moved this to 2000.
Heh. You and Kevin really had me going there for a minute. I thought...
April 10, 2009 at 8:57 am
RBarryYoung (4/9/2009)
sigh* Please note which forum you are in.Just post the text version then.
He IS in the 2000 forum, isn't he? 🙂
OP: My guess is that any process that...
April 10, 2009 at 8:12 am
1) Putting the tlogs on the raid10 will probably be faster than on the raid5 sets, assuming the raid10 isn't saturated
2) having too many file groups/partitions on disks (raid or...
April 10, 2009 at 8:08 am
Nice article.
I have been doing similar coding for a few years now with great success. My typical situation gets just the primary key fields from many tables necessary to...
March 11, 2009 at 5:31 am
I STRONGLY recommend that you get some professional help, sooner rather than later. From your questions and comments I just don't see you having the necessary skills and training...
February 19, 2009 at 1:18 pm
Barkingdog (2/16/2009)
"GrumpyOLDDBA" wrote>>> I'd suggest you get the sql performance dashboard from connect,
What is connect? Can you provide a URL?
Barkingdog
I think he meant http://www.codeplex.com, although the sql server performance dashboard...
February 16, 2009 at 12:38 pm
Viewing 15 posts - 4,756 through 4,770 (of 5,843 total)