Cumulative Update Package 5 for SQL Server 2005 Service Pack 2 brings the hotfixes released since SP2, up to build 3215. Download details are here.
Stress Testing a Query Before Release
Stress testing a query before release reveals concurrency and parameter risks; learn to design realistic SQL Server tests and compare useful metrics.
SQL SERVER – Get Information of Index of Tables and Indexed Columns
sp_helpindex is a handy stored procedure that shows every index on a table, its description and the indexed columns. One line of T-SQL does it.
SQL SERVER – T-SQL Script to Find Details About TempDB Information
An old but reliable T-SQL script I use to check TempDB Information: file names, size in MB, autogrowth status and the growth setting of each file.
SQL SERVER – Solution – Log File Very Large – Log Full
Is your log file too big, or is the log full? Fix it in three steps: back up the log file, truncate it, then shrink it. I link my two detailed posts too.
SQL SERVER – TempDB Restrictions – Temp Database Restrictions
What are the TempDB restrictions? A candidate in my interview could not answer. Here is the list, from adding filegroups to backup, restore and more.
Working With an Outsourced Database Team
An outsourced database team needs a clear scope, controlled access, useful reporting, and a plan to keep operational knowledge in house.
SQL SERVER – Do Not Store Images in Database – Store Location of Images (URL)
Should you store images in database tables? My advice: keep the image location (URL) in a VARCHAR column instead, so the database stays small and updates stay simple.
Migrating From Access to SQL Server: Data Types and Gotchas
Plan migrating from Access with explicit type mappings, boolean and date checks, query rewrites, and a primary key inventory.
SQL SERVER – Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Refresh
The CTP1 Refresh of Microsoft Synchronization Services for ADO.NET v2.0 is out. It syncs data between a local store on laptops or devices and a central server.