Performance Test of New Date Manipulation Functions (SQL Spackle)

Performance test of new SQL 2012 functions DateTimeFromParts and Format

SELECT * usage

SQL Server 2012 Performance Test: Gap Detection

Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...

T-SQL Tuesday #029 – Useful Feature of SQL Server 2012

This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...

Presenting at SQL Saturday #111

On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...

SQL Server 2012 Performance Test: Truncate a Date/Time to Different Parts

SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

This month, Argenis Fernandez (blog, @DBArgenis) is hosting our monthly T-SQL Tuesday, and he wants to know: Are you specialized?...

Presenting at SQL Saturday #110

On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...

Comparing Inline and Multi-Statement Table-Valued Functions

Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...

Presenting at SQL Saturday #96

I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC...