CEILING and FLOOR follow numeric order even below zero. This example compares both boundaries with truncation and explicitly defines its displayed decimal types.
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 – T-SQL Script to Find Details About TempDB Information
TempDB Information starts with the files and their actual locations. I inspect every data and log file before proposing changes.
SQL SERVER – TempDB Restrictions – Temp Database Restrictions
TempDB Restrictions follow from how SQL Server recreates and uses this system database. I check them before applying user-database maintenance habits.
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.
NCHAR: Build Unicode Characters From Integer Codes
NCHAR builds a character rather than formatting a number. Preserve source codes and distinguish unsupported values from missing input.
A Throwaway Virtual Machine for SQL Server Testing
Use a Throwaway Virtual Machine to test SQL Server setup, patches, and failures with snapshots and safe rollback away from shared servers.