Ben Forta, author of Sams Teach Yourself SQL Server T-SQL in 10 Minutes, wrote about SQLAuthority.com on his blog. Here is what he said and why it means a lot to me.
SQL SERVER – Count Duplicate Records – Rows
A simple query to count duplicate records in a table using GROUP BY, HAVING COUNT(*) and ORDER BY, with the most repeated values first. A video is included.
SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days
A query on sys.objects to list every stored procedure modified in last N days, or ones created lately. I use 7 days; change it to what you need.
SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained
Quick examples of PI(), POWER() and EXP() in SQL Server, and the answer to the title: EXP to the POWER of PI returns 23.1406926327793.
SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1
Msg 244 and Msg 245 come from converting a value to an incompatible data type, often with CAST or ISNULL. Examples of both, and why ISNULL casts to the first type.
SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT
How to convert text to integer with CAST and CONVERT, whether they fail on alpha-numeric values (yes), and how to pull only the numbers from a string.
SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9
Microsoft Document Explorer cannot be shown when you open a new SQL Server Books Online? Uninstall every Books Online version, then install it again.