Editorials

Rebuild or Reorganize or Do Nothing to Indexes SP

New SQL Server Show Available
We’ve just posted the latest SelectViews show to the site. Learn about best practices from the field in this interview show with both the Avepoint and SQL Sentry folks.
[Watch Here]

Featured Article(s)
Rebuild or Reorganize or do nothing to indexes SP
The following stored procedure makes use of the index fragmentation information that resides in the dynamic management view sys.dm_db_index_physical_stats.it decides according to the percentage of fragmentation if an index is to be rebuild, reorganized or left as is.

Fault Tolerance Options – Overview of features and techniques
This webcast is a presentation by expert Ted Malone at the SSWUG SQL Server Virtual Conference earlier this year. Learn about your options, different features available and how they impact your ability to recover and keep your options open for getting systems back online and updated in case of issues.

> Register Now
> Date: 10/29/2008 12:00pm Noon Pacific

This is Cool!
(if I do say so my self!) We’ve just begun working with VendorRate – it’s a service that lets you rate those vendors you work with – and see ratings from others . So you can do research, see how others have worked with the vendors and a lot more. It’s a great feedback mechanism. Of course it relies on you – and this is the cool thing. We’ve added some key vendors, but you can also add others, rate those listed, etc. It’s very cool. Take a look here – and be sure to rate those you’ve worked with – it only takes a minute (it’s not a long bunch of survey questions or anything like that). Let me know what you think of the new service.

Featured White Paper(s)
Transforming Enterprise Backups: How Using a Third-Party Tool Can Improve Backup Strategies
The backup and restore facilities in native SQL Server are robust, and once a backup routine is established, the DBA needs to… (read more)

Improving Data Protection and Storage Reliability for Critical Databases
Discover how a healthcare management company met the challenge of improving data protection and storage reliability for criti… (read more)