2012-10-26 (first published: 2012-10-02)
961 reads
Scripts
2012-10-25 (first published: 2012-10-12)
1,957 reads
2012-10-23 (first published: 2012-09-12)
2,985 reads
New feature in SQL Server 2012 - Sequence
A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.
2012-10-22 (first published: 2012-09-11)
2,065 reads
Show Job Run Snapshot
Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.
2012-10-19 (first published: 2012-09-17)
1,150 reads
Read large C2 Audit Mode trace files
Here's a set of scripts that allow you to save pertinent information from SQL Server Profiler trace files.
2012-10-18 (first published: 2012-09-20)
625 reads
Port check for SQL Server connectivity
Generates a script to check connectivity between a list of SQL Server instances on a specified port.
2012-10-17 (first published: 2012-08-09)
2,126 reads
2012-10-16 (first published: 2012-09-21)
2,562 reads
2012-10-12 (first published: 2012-09-10)
1,806 reads
Job Summary
This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.
2012-10-10 (first published: 2011-11-02)
2,117 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