Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

November 2006 - Posts

Wednesday, 29 November 2006 11:56 PM

Why defragment tables & indexes at the same time?

Virtually every DBA I talk to about index maintenance seems to defrag tables & indexes together. Here are a few thoughts about why this isn't a good idea.. (a) If overall database performance improves radically after rebuilding your tables, you've
posted by Greg_Linwood | 0 Comments
Filed Under:
Thursday, 23 November 2006 11:40 PM

You won't solve SQL performance problems by reading Execution Plans alone

One of the first things that DBAs tend to do when investigating a query performance tuning problem is to check out the query's execution plan, preferably via the graphical showplan in QA or SSMS. Sure, this tells you how the query is currently
posted by Greg_Linwood | 2 Comments
Filed Under: