Build Unicode strings with UNISTR in SQL Server 2025, compare NCHAR, and preserve accented letters, Hindi text, and emoji in storage.
SQL SERVER – DMV to Identify Incremental Statistics – Performance improvements in SQL Server 2014 – Part 3
Part 3 of my series on SQL Server 2014 performance improvements: a DMV to identify incremental statistics, after the basics and a simple example.
SQL SERVER – Simple Example of Incremental Statistics – Performance improvements in SQL Server 2014 – Part 2
Part 2 of my series on SQL Server 2014 performance improvements: a simple example of incremental statistics, after learning what it is in part 1.
SQL SERVER – What is Incremental Statistics? – Performance improvements in SQL Server 2014 – Part 1
This is the first part of the series Incremental Statistics. Here is the index of the complete series. Let us learn it together in the blog.
Which SQL Server Edition Do You Need?
Which SQL Server edition do you need? Express, Developer, Standard and Enterprise compared in plain terms, plus the licensing trap where a free Developer Edition quietly ends up running the business.
Unstable Queries: Finding Wide Duration Swings in Query Store
Find unstable queries with Query Store duration spread, weight averages, and separate plan changes from waits and parameter effects.
SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026
I was once corrected on Page Life Expectancy. Here my friend Tim Radney explains in simple words what a good value for Page Life Expectancy really is.