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.
Explaining a Database to Non-Programmers (It Won’t Play Your Flash Movie)
Explaining a database to non-programmers is a real skill. Here’s my old flash movie story and the plain comparisons that work in any meeting.
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 – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type
Msg 8115, arithmetic overflow error, comes when a value is too big for its column, like 111111 in a TINYINT. Check the value or widen the column definition.
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.
SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
A simple Best Practices Analyzer Tutorial with images, run on an old laptop with SQL Server 2005 and many planted issues, to help you start using BPA.
SQL SERVER – 2005 Best Practices Analyzer (July BPA)
The July release of the SQL Server 2005 Best Practices Analyzer checks Windows and SQL Server settings against Microsoft best practices. Download link inside.
SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause
I asked every candidate the difference between HAVING and WHERE clause, and none got it right. HAVING filters groups, while WHERE filters individual rows.