How do you use multiple CTE in one SELECT statement? Two simple examples: independent CTEs joined together, and a second CTE built on the first.
Calculating Age From a Date of Birth Correctly in T-SQL
Use an explicit anniversary rule for calculating age in T-SQL, including February 29, years-months-days output and birthday lookups.
SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime
Get the time in Hour:Minute Format, or just the date, from a DATETIME with CONVERT styles 108 and 101, or with the TIME and DATE types in SQL Server 2008.
SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server
No OS access? Run xp_fixeddrives from Management Studio to list each fixed hard drive with its free space, then plan where TempDB and indexes go.
SQL SERVER – Forgot the Password of Username SA
Forgot the password of username SA? Resetting it is easy when another sysadmin login or a Windows admin account can get in. Here are your options.
SQLAuthority News – Author Visit – Virtual Tech Days August 2009
My notes from Microsoft Virtual Tech Days August 2009, where I presented two sessions, and how presenting online differs from a user group.
SQL SERVER – Introduction to SQL Server 2008 Profiler – Complete
A complete introduction to SQL Server 2008 Profiler: creating, watching, storing and replaying traces, and whether to run it on a production server.