|
|
-
Mike Lewis Answered 6 Months ago through Quizzes
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...
|
-
Mike Lewis Asked 8 Months ago through Quizzes
Size of Bulk logged transaction log backups...
|
-
Mike Lewis Commented 9 Months ago through Blogs
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...
|
-
Mike Lewis Commented 9 Months ago through Blogs
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...
|
-
Mike Lewis Posted 10 Months ago through Blogs
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...
|
-
Mike Lewis Posted 10 Months ago through Blogs
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 ...
|
-
Mike Lewis Answered 11 Months ago through Quizzes
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...
|
-
Mike Lewis Asked 11 Months ago through Quizzes
Should Foreign Key constraints be used in a Data Warehouse?...
|
-
Mike Lewis Asked 1 Years ago through Quizzes
What small change can often see dramatic performance improvements when searching wide strings?...
|
-
Mike Lewis Posted 1 Years ago through Blogs
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....
|