Viewing 13 posts - 46 through 58 (of 58 total)
Ahh ok didn't know it was a table variable.
Is it the format of #xxxxxx that implies that is a table variable vs. temp table?
It still might be good...
June 17, 2009 at 10:04 am
As Cade alluded to earlier, and perhaps others I didn't have time to read all the replies, non-clustering indexes can perform better.
On a large table with many columns, a...
May 8, 2009 at 9:55 am
Thanks so much, I've been looking into this on and off for quite a while and never seen this solution.
--
Scott
February 19, 2009 at 12:06 pm
I've finally figured this out for the most part.
When Litespeed's logshipping initially fires up at its interval, it proceeds in an orderly fashion creating log files and cleaning up....
February 18, 2009 at 1:41 pm
Greg Charles (2/17/2009)
February 17, 2009 at 9:45 pm
GilaMonster (2/16/2009)
digitalox (2/14/2009)
GilaMonster (2/14/2009)
Simple recovery has no effect on what's written to a DB's log. Just how long it's retained after it's written.
Good point, not sure why but I've always...
February 16, 2009 at 1:29 pm
Kinda unrelated but you may want to check out the boot.ini parameter /USEPMTIMER (http://support.microsoft.com/kb/895980) if your on AMD x64.
February 14, 2009 at 2:03 pm
This is part of my particular checklist for that...
enable /3GB switch if x32 and RAM >= 4GB and <= 8GB
enable /PAE if x32 with > 4GB RAM
enable sql svr...
February 14, 2009 at 1:58 pm
Thanks so much for all the feedback.
--
Scott
February 14, 2009 at 1:52 pm
Krishna (2/14/2009)
since your have log shipping on 6 databases. You can set up a job in your maintenance plan to clean up the log_shipping_history_job tables as your maintenance.
Thanks, I'm planning...
February 14, 2009 at 10:27 am
GilaMonster (2/14/2009)
Simple recovery has no effect on what's written to a DB's log. Just how long it's retained after it's written.
Good point, not sure why but I've always been under...
February 14, 2009 at 10:20 am
Yes all the system (and user) databases are backed up nightly. My concern is that the msdb hitting the log LUN that heavily could be stealing some resources the...
February 14, 2009 at 10:14 am
Have you tried 1 for the MAXDOP? 0,4 and 8 won't buy you much if you have queries running concurrently that SQL server wants to run parallel.
Anything else on the...
February 13, 2009 at 5:09 pm
Viewing 13 posts - 46 through 58 (of 58 total)