DEGREES converts radians into degrees. An integer radian argument can narrow the output, while a float argument retains an approximate fractional degree value.
SQL SERVER – Generate Script with Data from Database – Database Publishing Wizard
The Database Publishing Wizard scripted schema and data for SQL Server 2005-era transfers. I keep that workflow separate from current SSMS instructions.
TOP WITH TIES: Keep Every Row at the Cutoff
TOP WITH TIES helps me keep equally qualified rows at a shortlist boundary. A unique ordering key changes that selection. Separate the cutoff rule from the final display order.
SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
DBCC CHECKDB checks database consistency. If it reports corruption, I preserve the output and establish the recovery options.
SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB
Msg 5174 says each file size must be greater than or equal to 512 KB, followed by error 1802. The fix is to create a database larger than 512KB.
SQL SERVER – 2005 2000 – Search String in Stored Procedure
Two scripts to search a string in stored procedure code, one for SQL Server 2000 using syscomments and one for SQL Server 2005, clearly labeled by version.
SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers
How to disable all triggers on a database and on the server, which kind of trigger each command touches, and how to turn them back on safely.