Getting Started with SQL Server?
Everyone has their story of how they got started with SQL Server, and they range quite a bit. You might be that developer that was… Read More »Getting Started with SQL Server?
SQL Server
Announcing our Newest SQL Server Course
We are pleased to announce our our new SQL Server Course >>>”Getting Started with Microsoft SQL Server” <<< We are launching this course with a… Read More »Announcing our Newest SQL Server Course
Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS
Steve Stedman So years ago, when my kids were growing up, and they were watching the Discovery Channel, or Animal Planet, or whatever it was… Read More »Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS
Are you wasting half the capacity of IDENTITY?
When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer… Read More »Are you wasting half the capacity of IDENTITY?
Get a List of Tables That Are Compressed
Modern versions of SQL Server have the option for row or page level compression. Here is the script to find those tables that have compression… Read More »Get a List of Tables That Are Compressed
Finding the names of all indexes on a SQL Server
I needed a way to list the indexes for an entire database, but I was running into a problem using sys.indexes that I could only… Read More »Finding the names of all indexes on a SQL Server
New cumulative update for SQL Server 2017
Microsoft has just release an cumulative update for SQL Server 2017 CU 23. I am always interested in fixes to DBCC CHECKDB and DBCC CHECKTABLE.… Read More »New cumulative update for SQL Server 2017
NO DEK Update for File ID
Since installing SQL Server 2019 CU9, I have been getting lots of errors about NO DEK Update for almost every file. Here is an excerpt… Read More »NO DEK Update for File ID
SQL Configuration Manager Missing
On a number of recent installs of SQL Server that I have worked on, I have noticed that the SQL Configuration Manager has been missing… Read More »SQL Configuration Manager Missing
Performance: Faster way to concatenate longer string
After my post yesterday on the performance implications of concatenating long strings with the + operator and the CONCAT function, today I am following up… Read More »Performance: Faster way to concatenate longer string