Delete Data from SQL Server Table in Batches
In this tip we cover a T-SQL script that allows you to batch delete older data from tables and save the deleted records to an archive table.
2020-03-31
T-SQL
Tagging SQL Server Changes in SQL Monitor
How to use RAISERROR() in T-SQL to send annotations to SQL Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics.
2020-03-30
Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
4,430 reads
Introduction to STRING_SPLIT function in SQL
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
7,497 reads
Mean Median Mode using SQL and DAX
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
2020-02-28
2,142 reads
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
5,803 reads
Handling Aggregations on a Poorly Designed Database
When the database design is not great, you may have to write some creative queries to get what you need.
2020-02-17
3,212 reads
Calculate Moving Averages using T-SQL in SQL Server
Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]
2020-02-04
5,086 reads
Prevent SQL Server Blocking using Lock_Timeout
In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.
2020-01-24
T-SQL script to purge all the tables including foreign key references
T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
1,221 reads
Blogs
SQL Prompt and SSMS 18.5
By Steve Jones
I downloaded SSMS 18.5, as there were a lot of fixes in here and...
Jupyter Book Challenges in ADS
By Steve Jones
I was excited to try the Jupyter Book feature in the March Azure Data...
Join me (virtually) in Adelaide!
I will be presenting a session to the Adelaide SQL Server User Group on...
Forums
2020 Nike Air Force 1 Low WMNS White Multi
features a White leather upper with Pink mesh side panels, Orange on the lateral...
Issue with case statement
i have a table A where the data looks like ID Name Phone CODE...
Implementing Reporting Application Enhancements with No Downtime
Comments posted to this topic are about the item Implementing Reporting Application Enhancements with...
Ask SSC