Viewing 15 posts - 36,166 through 36,180 (of 49,552 total)
fred2002 (10/23/2009)
we have restricted the log file autogrowth to control it.Therefore we have resized the max log size
So to prevent an error that's cause when the log file is too...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 7:09 am
There's an article on the basics of indexing that will be published on Monday. It has a section on seeks and scans and is written for a novice/beginner. Might be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 7:05 am
Turns out there are around 1500 batches in that plan. 🙁 No wonder SSMS isn't happy. I think I'm just going to end up reading the plan in raw XML...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 6:47 am
alex_ortega (10/23/2009)
But I'd like to know if using INNER JOIN has less IO cost on DB than using a regular T1.PK1 = T2.FK2 ??
Nope. Optimiser will generate identical execution plans....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 6:43 am
Forget the loop, that update's wrong.
Unless there's only one for in Table2, there is no way that SQL can tell which row in table2 it should use to update which...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 6:15 am
Reported. Please do not view attachment
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 6:13 am
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 3:58 am
Dave Ballantyne (10/23/2009)
Obviously there may be a bug in SSMS caused by a particular...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 3:31 am
Viewing 15 posts - 36,166 through 36,180 (of 49,552 total)