Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files?  Until a couple months...  Read more...

As databases grow, it often becomes necessary to add new I/O paths to accommodate the growing space. Even without growth that requires this scale, it can still be useful to utilize multiple I/O devices to spread out the load. One way that you can make optimal use of new drives is to add a filegroup to the database and move certain objects (say, all of your indexed views) to the new filegroup.  Read more...

Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Our 19th webinar will feature Brad McGehee talking about storage challenges, costs, and potential solutions for better managing your data. Tuesday, June 12, at 4:00pm GMT.  Read more...

Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.  Read more...

This script validates the sufficient disk space per drive. When you'll reach a minimum on a diskdrive, the script will mail all recipients.  Read more...

If SSDs are about to make obsolete one of the major driving forces behind the development of SANs (disk latency) then how is the storage array going to change in the near future?  Read more...

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...

Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.  Read more...

By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage  Read more...

Learn how to configure SQL Server database storage with higher disk writes than disk reads. Set up a RAID 10 array, cache configuration and file disk layout.  Read more...

How to Move Large Table to Different File Group  Read more...

Tuning SQL Server performance means tuning hardware configurations and setup. Learn about configuring disk arrays and SQL disk partitioning alignment.  Read more...

Virtual database storage in SQL Server comes with flexibility of tiered storage and block storage. Get the pros and cons of virtual storage area networks.  Read more...

Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.  Read more...