![](https://mssql.fr/wp-content/uploads/2024/08/word-image-102912-2-570x126.jpeg)
Effective Strategies for Storing and Parsing JSON in SQL Server
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or […]
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or […]
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this […]
I’m not the first person to write about cleaning up unused or redundant indexes. You can read […]
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes […]
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, […]
In the previous posts in this series (part 1, part 2, part 3), I described how I […]
In part 2 of this series, I showed an example implementation of distributing a long-running workload in […]
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or […]
I recently had a restore job where I needed to split the work up into multiple parallel […]
Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on […]
String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts […]
It is always an afterthought. New objects are created that start off small and current. New feature […]
Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective […]
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” […]
Tell me if you’ve heard this one before: I changed data from my application, but when I […]
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based […]
There are plenty of applications and tools available that allow for the movement of data in and […]
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there […]
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […]
When people start learning a new field, for example T-SQL, it’s tempting to spend very little time […]
If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […]
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]
In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with […]
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items […]
A student of mine sent me a T-SQL challenge involving gap-filling of missing dates and balances. I […]
When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for […]
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Sometimes when working with very large sets of data, you may not want to return all of […]
When you are writing T-SQL scripts to save away, for example one to create a new database, […]
I’ve been at this for a while now, and have a very particular set of rules and […]
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items […]
How you used to do it For example, say you want to find all the read-write database […]
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t […]
Greg Larsen’s series on Learning T-SQL so far: The basic T-SQL Select Statement Ordering a result set […]
Entry in Greg Larsen’s series on Learning T-SQL. The series so far: The basic T-SQL Select Statement […]
SQL Server provides the GROUP BY clause as a means to take a set of detailed values […]