This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.
2013-07-08
2,585 reads
2013-07-05 (first published: 2010-11-23)
20,836 reads
A comprehensive list of trace flags for SQL Server that you can use to configure your server instance.
2013-07-05 (first published: 2010-06-03)
30,235 reads
SQL Server 2012 Integration Services introduces an innovative approach to deploying SSIS projects, known as Project Deployment Model. However, the traditional, package-based methodology remains available and supported, and, in some scenarios, it might be considered more viable, since it allows for separation of SQL Server Database Engine and SQL Server Integration Services.
2013-07-05
2,205 reads
While AlwaysOn and Columnar lookup are good enough reasons to migrate to SQL Server 2012, you need to be aware of the problems associated with certain virtualize environments.
2013-07-04
8,344 reads
Fifty years after starting the 'Art of Computer Programming', Don Knuth is still working hard at the project. It is considered amongst the "hundred or so books that shaped a century of science”. Richard Morris asks him how things are going, and to find out more about his many achievements.
2013-07-04
4,357 reads
In this article, Arshad Ali goes intp detail about how a data warehouse is different from operational data store and the different design methodologies for a data warehouse.
2013-07-03
6,374 reads
2013-07-02
1,764 reads
This article shows how you can change the maintenance plan owner in SQL SERVER
2013-07-02
9,591 reads
Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis. If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.
2013-07-02
3,463 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