SQL Server Find Unused Data Files
You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...
2018-12-06
622 reads
Gavin Draper
Live Query Stats of Running Queries
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-11-24
237 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
204 reads
Why Wont SQL Server Use My Filtered Index?
As with most of my posts of late all examples here are using the StackOverflow SQL Server database that can...
2018-10-02
112 reads
Missing Index Recommendations, These Are Not The Indexes You’re Looking For
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
139 reads
Missing Index Recommendations, These Are Not The Indexes You're Looking For
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
150 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
187 reads
SQL Server How to Check What Settings Are Set On Active Sessions
SQL Server has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
106 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note : I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
139 reads
SQL Server Minimally Logged Inserts (Assume Nothing!)
Side note :
I originally started this post to show with examples all the scenarios where you can get minimal logging...
2018-05-29
159 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Cycle Logs (non-error log)
Hello all, I am hoping that this is an easy question and I'm just...
Execution plan shows enormous number of records
The problem was reported to us by a customer. They shared a graphic execution...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers