Viewing 15 posts - 36,181 through 36,195 (of 49,562 total)
endeavour (10/23/2009)
any tips for getting started as a db scalability consultant?
Know your stuff backwards, forwards, inside out. Make a name for yourself in the community, blogging, writing or presenting....
October 23, 2009 at 4:06 am
Put some regular monitoring in place so that you can see what leads up to the error. Use sys.databases and DBCC SQLPERF(LOGSPACE)
October 23, 2009 at 4:00 am
http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/ or look at the Execution Plan category. Looks like that was the only one missing a link.
October 23, 2009 at 3:58 am
Dave Ballantyne (10/23/2009)
Obviously there may be a bug in SSMS caused by a particular...
October 23, 2009 at 3:48 am
If you're doing an equality match on all three columns, then any one of those three indexes is fine. If you're doing matches on some of those columns, then not...
October 23, 2009 at 3:44 am
Silverfox (10/23/2009)
When's the next article on aggregates, coming out... dont keep us waiting too long 😉
27th January last year.
http://sqlinthewild.co.za/index.php/2008/01/27/execution-plan-aggregate-operators/
October 23, 2009 at 3:42 am
Did you query it at the time that the error occurred or sometime later? If it was a long running transaction, it could easily have resolved itself.
October 23, 2009 at 3:41 am
repent_kog_is_near (10/22/2009)
The rebuild takes care of the index statistics, but is it recommended I do a regular update of the non-index statistics using 'sp_createstats', using a job once a week?
Well,...
October 23, 2009 at 3:36 am
Chandhini (10/23/2009)
Is it mandatory to have all of these ( '_WA_Sys_ ). or can we remove them?if it is removed, is there any performance issue will come?
You can remove them,...
October 23, 2009 at 3:31 am
The error says to query sys.databases to see why the log cannot be reused.Have you done so? If so, what is the value of log_reuse_wait_desc for the DB in question?
October 23, 2009 at 3:26 am
Jeff Moden (10/22/2009)
The only thing that remains if for you guys to tell us a fool proof way to find a good local tuner. 😉
Ask for references, contact those references...
October 23, 2009 at 3:12 am
It's for a batch of statements. It's the graphical plan (a .sqlplan file) and I can't get the text plan.
So open in xml editor and 'edit' into several plan files?
October 23, 2009 at 3:06 am
Krasavita (10/22/2009)
What do you mean and take a full backup to restart the log chain?
If you were going to switch it back to full recovery, you would need to take...
October 22, 2009 at 9:49 am
Viewing 15 posts - 36,181 through 36,195 (of 49,562 total)