T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
2,538 reads
In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.
2019-01-30
2,074 reads
When Covid took out the PASS organization, I had someone say to me, “Well,...
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
My report has been working fine. Now, when I run the report, the Location...
I have a server set up as publisher/distributor and another as subscriber to a...
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers