Understand why SQL Server uses Cumulative Updates instead of service packs, what each CU contains, and how to plan a reliable patch cycle.
Index Maintenance on Modern Storage
Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQLAuthority News – Birthday of SQL Authority Author
Today is the birthday of the SQL Authority Author, and my thought of the day is a simple one that I truly believe: family is everything.
SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction
The start of my Data Warehousing Interview Questions and Answers series, beginning with the basics: what is data warehousing and why companies use it.
SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta
Ben Forta, author of Sams Teach Yourself SQL Server T-SQL in 10 Minutes, wrote about SQLAuthority.com on his blog. Here is what he said and why it means a lot to me.
Keeping an Inventory of Every SQL Server You Own
Build an Inventory of Every SQL Server you own, including hidden instances, owners, versions, recovery details, and a process to keep it current.
SQL SERVER – Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild – SQL SERVER 2000 and SQL SERVER 2005
What is Index Fragmentation and how do page splits cause it? How to measure it with DBCC SHOWCONTIG in SQL Server 2000 and sys.dm_db_index_physical_stats in 2005.