A function was causing CPU spikes. How many times was that function called, and at what cost? The SQL Server 2016 DMV dm_exec_function_stats shows it.
SQL SERVER – CREATE OR ALTER Supported in Service Pack 1 of SQL Server 2016
No more IF EXISTS and DROP before CREATE. SQL Server 2016 Service Pack 1 adds CREATE OR ALTER for stored procedures and other objects.
How to Use OR Condition in CASE WHEN Statement? – Interview Question of the Week #102
How do you use an OR condition in a CASE WHEN statement? A tricky interview question, and how to write it so the logic works.
SQL SERVER – System Function @@IDLE to Find System Ideal Time
Running @@IDLE returns a number that is hard to read. Here is what this system function measures and how to turn it into idle time you can understand.
Telling Which Platform You Run On With SERVERPROPERTY EngineEdition
Read EngineEdition with edition and version properties, select platform-aware diagnostics, and avoid treating an engine family as a license.
How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091
How do you introduce a Time Delay between two T-SQL commands? An interview question developers ask often, answered with WAITFOR DELAY.
SQL SERVER – How to Join a Table Valued Function with a Database Table
How do you join a table valued function with a database table? I try it on the WideWorldImporters sample database. It works from SQL Server 2008 on.