Other SQL Server Blogs around the Web

Browse by Tags

• 2005
• Backup/Restore
• CHECKDB From Every Angle
• compression
• Conferences
• Corruption
• database mirroring
• dbcc
• disaster recovery
• DMF
• encryption
• Indexes From Every Angle
• Interviews
• Page Checksums
• performance
• replication
• sql server
• SQL Server 2008
• tools

• SQL Server Statistics

  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... Posted May 16 2008, 03:00 AM by SSQA.net Filed under: sql server, 2005, Database Maintenance

• DBCC CHECKDB

  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... Posted May 14 2008, 05:15 AM by SSQA.net Filed under: sql server, dbcc, Database Maintenance

• CHECKDB From Every Angle: Example DBCC CHECKDB run-times

  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... Posted Feb 12 2008, 02:35 PM by SSQA.net 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?

  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... Posted Dec 12 2007, 12:07 PM by SSQA.net Filed under: performance, database mirroring, replication, tools, disaster recovery, encryption, SQL Server 2008, compression, Indexes From Every Angle, Database Maintenance, Interviews, Backup/Restore, Conferences, DMF, Page Checksums

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

  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... Posted Nov 14 2007, 10:22 PM by SSQA.net Filed under: dbcc, disaster recovery, Database Maintenance, Corruption, CHECKDB From Every Angle, performance

• Auto-shrink – turn it OFF!

  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... Posted Nov 12 2007, 10:28 PM by SSQA.net Filed under: performance, Indexes From Every Angle, Database Maintenance