How often should you back up master? It holds logins and server settings, so here are my master database best practices for backup timing.
Modulo: Negative Values Keep the Dividend Sign
Modulo can return a negative remainder for a negative dividend. A second expression normalizes a positive-divisor bucket while keeping the original input and remainder visible.
SQL Server – Multiple CTE in One SELECT Statement Query
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.