SOreadytohelp

Philip Kelley questions

Philip Kelley answers

• Get the last children from database
• How to handle Gmail addresses?
• How to see variable values in SQL Profiler when Trigger fires?
• Best Way to call a Web Service from TSQL
• Most efficient way to query multiple identical tables in separate databases
• In what situations would Rank and Dense Rank be useful?
• How to change the default value of a column in SQL Server
• How to refresh a test instance of SQL server with production data without using full backups
• Merge Statement and Identity Insert
• How to Convert a SQL Query using Common Table Expressions to One Without (for SQL Server 2000)