STR can reduce decimal places when its requested width cannot hold the complete fractional display. I inspect the complete text, including spaces and signs. A populated result does not guarantee that the number remains visible.
SQL SERVER – 2008 – Find If Index is Being Used in Database
How do you find if an index is being used in your database? My quick script checks sys.dm_db_index_usage_stats, so you can drop unused indexes safely.
SQL SERVER – Renaming SP is Not Good Idea – Renaming Stored Procedure Does Not Update sys.procedures
Renaming Stored Procedure objects with sp_rename looks fine, but the stored definition keeps the old name, as sp_helptext shows. A quick demo on AdventureWorks.
SQL SERVER – Puzzle – Computed Columns Datatype Explanation
Jacob Sebastian explains that SQL Server casts to the data type with the highest precedence. That leads to my puzzle on computed columns datatype.
SQL SERVER – Get Answer in Float When Dividing of Two Integer
Dividing one integer by another in SQL Server returns an integer. Use CAST or CONVERT to get the answer in float, with decimals, as this example shows.
SQL SERVER – Guidelines and Coding Standards Complete List Download
My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.
SQL SERVER – Guidelines and Coding Standards Part – 2
Part 2 of my Guidelines and Coding Standards: nest single quotes, add parentheses for readability, use IF EXISTS with SELECT 1, and avoid the SP_ prefix.