Viewing 15 posts - 14,926 through 14,940 (of 19,564 total)
As for the covering index vs. include topic, I would recommend reading an article by Josef Richburg and the ensuing discussion on the topic. You can find the article...
April 13, 2010 at 5:50 pm
Start Here:
http://msdn.microsoft.com/en-us/library/dd758814.aspx
Then check this one out
http://technet.microsoft.com/en-us/library/cc966534.aspx
Here is a recommendation by Buck Woody (MS Employee knows his stuff)
Another one by Denny Cherry (higher level disk config)
http://searchsqlserver.techtarget.com/tip/Optimize-disk-configuration-in-SQL-Server
April 13, 2010 at 5:44 pm
For the tempdb questions, I recommend you check out Kimberly Tripps blog. You can find a link to her blog in my signature. Browse her articles on tempdb.
As...
April 13, 2010 at 5:38 pm
Are you simply referring to the IO performance related to constant log growth or the log file filling up?
If you switch to full recovery, you must enable transaction log backups...
April 13, 2010 at 5:30 pm
Hey Steve, I just saw a post from SiteOwners and see that they have 10,000+ pts. We don't see them in the points shakedown. Why is that? ...
April 13, 2010 at 5:23 pm
I use RSS for the blogs that I try to follow but not any of the forums. I rely on emails and then flip through the forums periodically.
I will...
April 13, 2010 at 5:20 pm
Now that you know which report it is, I would check the SQL in the report and optimize the TSQL as well as tables and indexes for the report.
One possible...
April 13, 2010 at 5:08 pm
Thanks for updating us on the situation.
April 13, 2010 at 5:01 pm
Dave Heiler (4/13/2010)
Thank you for the scripts. This gave me the exact information I needed.
You're welcome.
I have updated that last script again. I posted information about it on...
April 13, 2010 at 4:53 pm
Is there anybody else at the playground now that I can come out to play?
April 13, 2010 at 4:42 pm
PaulB-TheOneAndOnly (4/13/2010)
In the Oracle world a explicit cursor is a cursor you define in the "declare" section - this is pl/sql...
April 13, 2010 at 2:51 pm
Suresh Kumar-284278 (4/13/2010)
It was one of the questions I got when I got assessment call in my company (our company does assessment for employees every year).
One more...
April 13, 2010 at 2:45 pm
Trey Staker (4/13/2010)
April 13, 2010 at 1:10 pm
jcrawf02 (4/13/2010)
April 13, 2010 at 12:55 pm
Viewing 15 posts - 14,926 through 14,940 (of 19,564 total)