Wait for Mirror treshold
This procedure checks if a mirror treshold exists and wait until this treshold is cleared or after a specified time.
2009-11-10 (first published: 2009-10-23)
501 reads
Scripts
Using a function to parse/return the Nth field of a delimited column
A useful SQL function to parse a single string with delimited values for the "N"th occurrence
2009-11-06 (first published: 2009-10-15)
1,453 reads
Custom cleanup procedure for backup files
There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.
2009-11-05 (first published: 2009-10-09)
1,553 reads
Retrieve consecutive records from the table based the value difference
Retrieve consecutive records from the table based the value difference
2009-11-04 (first published: 2009-10-06)
955 reads
2009-11-03 (first published: 2009-10-06)
1,954 reads
Generating Rollback Proc with CDC
This will generate a rollback procedure for any table with CDC enabled for all columns
2009-11-02 (first published: 2009-10-08)
1,064 reads
Ultimate Alter Script generator
In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.
2009-10-30 (first published: 2009-10-01)
1,370 reads
Script SQL Table Schema as XML-XSD
When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.
2009-10-28 (first published: 2009-10-06)
1,542 reads
The Ultimate Connection Summarizer and Trouble Finder
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
2009-10-22 (first published: 2008-09-18)
6,079 reads
2009-10-21 (first published: 2009-10-01)
2,312 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
T-SQL Tuesday #202: The Two Outages I Won't Ever Forget
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
Forums
Performance Regression After Upgrading from SQL Server 2016 to 2022
Hello everyone, Last week we performed an upgrade of our SQL Server instance, moving...
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers