How Check Constraints MIGHT Improve Your Queries and Missing Index Requests
In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.
2018-11-23
3,977 reads
In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.
2018-11-23
3,977 reads
2016-02-23
1,489 reads
2016-01-28
1,596 reads
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
2015-05-12
6,913 reads
2015-05-01
1,784 reads
Check Constraints play a very important role in SQL Server as it allows data validation rules to be imposed at the SQL Server instance level itself instead of writing rules for each application.
2013-08-08
5,038 reads
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
2013-07-30
14,003 reads
This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.
2013-06-17 (first published: 2013-05-30)
1,033 reads
2011-12-27
3,209 reads
When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to to easily coexist with Agile methodologies for application development? Nick suggests that the technical solutions already exist, and the dissonance is more due to cultural and organizational problems
2011-05-04
6,129 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers