SQL Server Tune Your Transaction Log
Whenever a transaction log file grows the space it is allocated is divided up into virtual log files (VLFs). Depending...
2018-02-26
100 reads
Gavin Draper
Stop Worrying About Index Fragmentation and Manage Your Statistics
I see a lot of posts online about rebuilding indexes in a scheduled maintenance task, this is a pretty intensive...
2018-02-25
81 reads
Fixing a SQL Server That Wont Start Due To Max Memory Being Set Too Low
I recently came up against a SQL Server instance that wouldnt start, after going through the event log the reason...
2017-08-09
224 reads
SQL Server Unique Constraints With Where Conditions
Imagine we have the following table
Users
FieldTypeIdINTUsernameNVARCHARDeletedBITThen imagine we want Username to be unique for non deleted users. Normally we would...
2017-08-02
49 reads
Upgrade Your SQL Server CASE Statements With IIF and CHOOSE
SQL Server 2012 introduced IIF and CHOOSE functions and I completely missed they even existed until recently. They make some...
2017-07-06
52 reads
SQL Server 2017+ How To Replace Multiple Characters In A Single Statement With TRANSLATE
The REPLACE function in SQL Server has until now been quite limited. SQL Server 2017 has introduced a new TRANSLATE...
2017-07-05
1,841 reads
Level Up Your SQL Server Cross Platform Skills With mssql-scripter
The ability to export a script of database objects has for a long time been a feature of SQL Server...
2017-06-27
83 reads
SQL Server 2017 Concatenation With STRING_AGG
One of the new less publicized features in SQL Server 2017 is STRING_AGG. This new feature can take an expression...
2017-06-20
90 reads
SQL Server Installed and Running on macOS In Less Than 5 Minutes (With Video)
SQL Server 2017 is the first version of SQL Server that will also run natively on Linux and on macOS...
2017-06-19
42 reads
SQL Server 2017 Graph Data Features In Action
The Wikipedia Graph Database page has the following definition…
In computing, a graph database is a database that uses graph structures...
2017-06-12
109 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers