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 sitting too close to the SQL Server and someone named you the DBA. For others …
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 sitting too close to the SQL Server and someone named you the DBA. For others …
We are pleased to announce our our new SQL Server Course >>>”Getting Started with Microsoft SQL Server” <<< We are launching this course with a 50% OFF discount code! Coupon Code: INTRO50 *For a limited time only* Yes, Kiana won …
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 where the Crocodile Hunter was there. And I remember Steve Irwin, the Crocodile Hunter used …
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 data type category, except for the bit data type, or decimal data type. So how …
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 enabled: Tested on SQL Server 2019.
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 see the indexes for the current database. Below is the solution that I put together …
Finding the names of all indexes on a SQL Server Read more »
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. There was one fix related to CHECKTABLE that fixes an issue where the session gets …
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 from the SQL Server log file. 182 2/20/2021 2:07:46 PM spid25s Refresh DEK for DBID: …
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 from the start menu, not sure if someone deleted it from the menu, or if …
After my post yesterday on the performance implications of concatenating long strings with the + operator and the CONCAT function, today I am following up with a way to speed up concatenation if you need to build really long strings. …
Performance: Faster way to concatenate longer string Read more »