The OVER Clause arrived in SQL Server 2005, yet few know all its uses. In Notes from the Field #101, Kathi Kellenberger explains it with window functions.
SQL SERVER – Database Testing and Waitfor Delay – Notes from the Field #099
Kevin Hazzard shows how WAITFOR DELAY helps with database testing, like mocking procedures that simulate client data for ETL. Notes from the Field #099.
SQL SERVER – What’s the Difference between ROW_NUMBER, RANK, and DENSE_RANK? – Notes from the Field #096
Kathi Kellenberger explains the difference between ROW_NUMBER, RANK, and DENSE_RANK, three T-SQL window functions, in Notes from the Field #096.
SQL SERVER – Different Methods to Extract Scale Part From Decimal Number
Need only the digits after the decimal point? Here are different methods to extract scale part from decimal numbers, using ABS with CAST or string functions.
SQL SERVER – Fix @@ServerName Property Value When Incorrect
A colleague’s @@ServerName returned NULL instead of the server name. Here is why the value can be wrong and how to fix the @@ServerName property.
SQL SERVER – What are T-SQL Median? – Notes from the Field #090
SQL Server has no MEDIAN function. Kathi Kellenberger explains what a median is and how to calculate a T-SQL median in Notes from the Field #090.
SQL SERVER – Knowing the Source Application Using APP_NAME() Function
The APP_NAME() function returns the application name of the current session. See what it returns in SSMS and how it helps you audit where data comes from.