Restore Script Generator
Create restore script from a SQL Backup file. A must have for your DBA Tool Belt.
2013-06-18 (first published: 2013-05-30)
2,322 reads
Scripts
Re-Trust Untrusted Foreign Keys and Constraints
This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.
2013-06-17 (first published: 2013-05-30)
1,175 reads
How Long Backups Will Take
When you are running a backup or a restore, this script gives you an estimate of completion time.
2013-06-14 (first published: 2013-05-30)
1,624 reads
2013-06-13 (first published: 2013-05-30)
3,137 reads
Insert Commas Into Number String
Function to take a number as a string and return it with commas separating thousands, millions, etc.
2013-06-07 (first published: 2009-03-31)
2,443 reads
2013-06-06 (first published: 2009-03-16)
2,654 reads
What got restored from where, by who and when
Ever wondered what got restored, who did the restore and where the backup came from that did the restore?
2013-06-04 (first published: 2012-08-23)
2,035 reads
Get Rid of All Those Pesky 1 MB File Growth DB Files
Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.
2013-05-31 (first published: 2012-11-10)
1,466 reads
Search all stored procedures on all databases
Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.
2013-05-30 (first published: 2013-05-22)
1,753 reads
Find Blocked SQL and Blocked By Information.
This is a stored procedure which can be used to find which processes are been blocked by each other. This Procedure will also provide SQL information associated with the blocked SPID.
2013-05-23 (first published: 2009-06-15)
2,858 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCP Tumpang (08218200205) WhatsApp
ALAMAT : Jl. Raya Tumpang No.1, Ledoksari, Tumpang, Kec. Tumpang, Kabupaten Malang, Jawa Timur...
BCA KCP Kepanjen (08218200205) WhatsApp
ALAMAT : Jl. Jend. Yani Jl.Pahlawan No.99, Ardirejo, Kepanjen, Kec. Kepanjen, Kabupaten Malang, Jawa...
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
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