Hi @Chandra, The marking might not appear consistent in places, but this was a conscious decision with regards to poorly referenced answers. In several answers, text from BOL was copied verbatim without any references to the original text, and in su...

Size of Bulk logged transaction log backups...

Absolutely right, the entire transaction is rolled back. But it's worth noting that any violation of a constraint would have the same effect, such as a duplicate value into a column with a unique constraint/index, or violating a check constraint. This...

Absolutely right, the entire transaction is rolled back. But it's worth noting that any violation of a constraint would have the same effect, such as a duplicate value into a column with a unique constraint/index, or violating a check constraint. This...

My question in the recent Beyond Relational BI Quiz (see http://beyondrelational.com/quiz/sqlserver/bi/2011/questions/132/use-of-foreign-key-constraints.aspx) sparked a bit of debate about Foreign Keys, and whether they should b...

My question in the recent Beyond Relational BI Quiz (see http://beyondrelational.com/quiz/sqlserver/bi/2011/questions/132/use-of-foreign-key-constraints.aspx) sparked a bit of debate about Foreign Keys, and whether they ...

I think this is a great conversation, and certainly covers a huge amount of the arguments for and against foreign key constraints! I knew when I set the question that there was an element of subjectivity about it, and that different people sit in diffe...

Should Foreign Key constraints be used in a Data Warehouse?...

What small change can often see dramatic performance improvements when searching wide strings?...

The post tells us about the ERDs for System Views and DMVs and where we can get Microsoft’s own System Views Map for SQL Server 2005 displaying all of the system views and DMVs and their connecting relationships....