How do you group by a column and comma delimit multiple rows of names into one value? It is a popular question, and I answer it with FOR XML PATH.
SQL SERVER – UPDATE FROM SELECT Statement with Condition
An old college friend asked how to UPDATE one table from another with a condition. Here is his sample and the UPDATE FROM SELECT statement that solves it.
What Is a Data Type, and Why the Wrong One Costs You
A data type decides what a column holds, what it costs in bytes, and how SQL Server compares it. Why NVARCHAR doubles your storage, why float will not compare cleanly, and the conversion that quietly kills an index.
SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures
What are the .c, .dll, .obj and .pdb files created for Natively Compiled Stored Procedures in SQL Server 2014? A quick list of each extension and what it does.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
How many times did a procedure run, and how much CPU and IO did it use? The SSMS Resource Locking and Object Execution Statistics reports answer exactly that.
Choosing a Technical Conference Worth Attending
Choose a technical conference by matching sessions and audience to your skill goals, then counting the full cost before you book.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.