Viewing 15 posts - 17,701 through 17,715 (of 19,564 total)
That would also be a good cause.
Thanks for posting back.
January 31, 2010 at 12:05 pm
Mani-584606 (1/31/2010)
thanks Jefferey,Here I considered the page_count>1000. Is that right criteria to consider for finding Index fragmentation that are only having page count>1000?
thanks again
1000 pages is a common recommendation. ...
January 31, 2010 at 12:04 pm
vstitte (1/31/2010)
In SMSS when you...
January 31, 2010 at 11:08 am
Same process you used for the Instance currently installed on the cluster - just a new instance. You need to have resources that can be dedicated to the new...
January 31, 2010 at 12:26 am
It looks like a majority of your fragmentation is in heaps. Heaps cannot be defragged. You must determine which tables are heaps. Those are the tables that...
January 30, 2010 at 10:46 pm
What server roles and database roles does that user belong to?
January 30, 2010 at 10:43 pm
Exam 70-431
Exam 70-443
Exam 70-444
Are for DBA
The others are for Database Developer.
January 30, 2010 at 10:41 pm
Yes you can.
January 30, 2010 at 10:38 pm
I would read those links suggested by Gail. Also, there is a script for download called sp_activity. That also helps to give some insight into blocking chains. ...
January 30, 2010 at 3:11 pm
GilaMonster (1/30/2010)
george sibbald (1/30/2010)
they were? People do that?
Sure. The exceptional DBA allowed both people to nominate others and for people to nominate themselves. Lots of people will nominate themselves for...
January 30, 2010 at 10:02 am
Jeff Moden (1/30/2010)
Sounds like your design philosophy and mine are pretty much the same. When I get to a new SQL Server site, one of the things I do...
January 30, 2010 at 9:50 am
Paul White (1/30/2010)
GilaMonster (1/30/2010)
It's Hermes (Mercury) one of the greek gods. I believe he was the messenger of the godsThanks
Hermes - Greek
Mercury - Roman
Kind of a catch-all god. Messenger,...
January 30, 2010 at 9:47 am
Viewing 15 posts - 17,701 through 17,715 (of 19,564 total)