Trusting STRING_SPLIT() order in Azure SQL Database
Learn about the changes to the STRING_SPLIT function in Azure SQL Database that allows you to specify ordinal position of the output.
2021-12-03
T-SQL
SQLFacts - A Free Toolkit for SQL Server Database Engineers
SQLFacts is a FREE suite of 26 (and counting) tools for SQL Server database development, database administration, and performance tuning. The toolkit is all T-SQL code and it includes the functionality of hundreds of short scripts.
2021-11-19
9,550 reads
Handling an unknown number of parameters in SQL Server
In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.
2021-11-10
Model and Log Trend Reversals for Time Series Data in SQL Server
This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well as exponential moving averages with different period lengths.
2021-10-15
Learning the SQL GROUP BY Clause
Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.
2021-10-06
How LAG compares to other techniques
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
2021-09-24
Executing a TSQL batch multiple times using GO
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
2021-08-27
Migrate Key-Value Pairs from Python Dictionary to SQL Server via JSON
This article will demonstrate how to migrate via JSON, key-value pairs from a Python dictionary object to a SQL Server table.
2021-07-16
Mergers and acquisitions in Insurance
The insurance sector has seen a marked rise in mergers and acquisitions over the past 12 months, and although these can be an excellent way to leap beyond organic growth, M&As can result in challenges with technology. In this blog, COEO's James Boother provides some tips on how, with good planning, technologies can be a real advantage in your next acquisition.
2021-07-14
What does SET NOCOUNT ON do?
When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. Read Brent's blog to see him demo it by writing a stored procedure in the Stack Overflow database.
2021-07-05
Blogs
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
T-SQL Tuesday #174: Job Interview Questions
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Forums
getting logged in user name to the pc that running the report
hi all, is there anyway in SQL to getting logged in user name to...
What is the monkey type?
Monkey type is a free online typing practice website that offers a variety of...
SQL JOB add/modified
Is there a trigger to notify when a new SQL Agent job is created/modified?
Question of the Day
Full Text Editions
In which editions can I use Full-Text and semantic search?
See possible answers