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
621 reads
You know that old SQL Server you’ve left running the last 5 years and had numerous databases dropped and restored...
2018-12-06
621 reads
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
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
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
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
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 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 has a number of settings set on a session that can influence the behaviour or queries. When debugging...
2018-06-01
106 reads
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
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
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Sometimes, Troubleshooting Is Hard
Comments posted to this topic are about the item Dimensional Modeling Case Study, Part...
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