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 it may have been part of starting at a new job. For some you may have learned it in school, …
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 the battle (link to video below) over which course we are going to launch first. We originally had a debate …
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 to say Danger, Danger, Danger, and he’d go in and like deal with some crocodile or something like that. And …
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 many rows can you insert into that table? It depends on the data type used. What happens when I run …
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 to list off of the indexes in the entire database. CREATE TABLE ##allindexes(databse_id INTEGER,table_id INTEGER,index_id INTEGER,table_name VARCHAR(1024));EXECUTE Sp_msforeachdb’use [?];INSERT INTO ##AllIndexesselect DB_ID() as database_id, object_id as table_id, index_id, namefrom sys.indexeswhere name is not null’ SELECT *FROM ##allindexes;DROP TABLE ##allindexes;
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 killed when you run DBCC CHECKTABLE with PHYSICAL_ONLY due to disk full. The session remains in KILLED\ROLLBACK state and threads …
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: [5] File Id: [1] – Copying encryption state183 2/20/2021 2:07:46 PM spid25s DBID: [5] File Header for File Id: [1] …
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 the icon was just not added. The SQL Configuration Manager is an important tool for configuring the sql instances installed …
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. What the previous show as that the longer the string gets the slower the concatenation is. So instead we declare …
Performance: Faster way to concatenate longer string Read more »