This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on.
2008-07-29
4,102 reads
Registration for SQLBits III, to be held at Hatfield in the UK on September 13th, is now open! SQLBits is the UK's finest SQL Server technical conference, and it's 100% free to attend!
2008-07-29 (first published: 2008-07-23)
1,837 reads
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
2008-07-29
72 reads
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
2008-07-29
63 reads
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
2008-07-29
76 reads
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
26,388 reads
This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data
2008-07-28
2,854 reads
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
2008-07-28
539 reads
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
2008-07-28
754 reads
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
2008-07-28
502 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Adding new column with DEFAULT
I've got a web application for my side business. I've added a SQL Server...
Comments posted to this topic are about the item Looking for New Blood
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