Browse by Tags

SQL Server Statistics

Published 16 May 8 3:0 AM | SSQA.net

SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Good statistics allow...

Filed under: sql server, 2005, Database Maintenance

DBCC CHECKDB

Published 14 May 8 5:15 AM | SSQA.net

DBCC CHECKDB checks the logical and physical integrity of all objects in the specified database by performing the following: Runs DBCC CHECKALLOC on the database Runs DBCC CHECKTABLE on every table and view in the database Runs DBCC CHECKCATALOG on the...

Filed under: sql server, dbcc, Database Maintenance

CHECKDB From Every Angle: Example DBCC CHECKDB run-times

Published 12 February 8 2:35 PM | SSQA.net

Almost a year ago to the day I asked a question on my old blog - how long does *your* CHECKDB take to run? Well, I had a bunch of replies but I never got around to posting the results. I was reminded of this recently so threw together some graphs of the...

Filed under: performance, disaster recovery, Database Maintenance, CHECKDB From Every Angle

Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?

Published 12 December 7 12:7 PM | SSQA.net

While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and...

Filed under: performance, tools, replication, disaster recovery, dmf, database mirroring, encryption, compression, SQL Server 2008, Indexes From Every Angle, Database Maintenance, Interviews, Page Checksums, Backup/Restore, Conferences

CHECKDB From Every Angle: How long will CHECKDB take to run?

Published 14 November 7 10:22 PM | SSQA.net

This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out...

Filed under: performance, dbcc, disaster recovery, Database Maintenance, CHECKDB From Every Angle, Corruption

Auto-shrink – turn it OFF!

Published 12 November 7 10:28 PM | SSQA.net

I’m in the middle of a flight from Washington D.C. to Zurich on the way to Barcelona for TechEd IT Forum and I can’t sleep – Kimberly’s out like a light so what else is there to do except write another blog post? :-) OK - actually posting this from Barcelona...

Filed under: performance, Indexes From Every Angle, Database Maintenance