Display More Than 8000 Characters (SQL Spackle)
SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).
2013-06-28 (first published: 2011-01-27)
21,029 reads
SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).
2013-06-28 (first published: 2011-01-27)
21,029 reads
2011-02-18 (first published: 2011-01-25)
2,922 reads
The BIT data type is an awkward fit for a SQL database. It doesn't have just two values, and it can do unexpected things in expressions. What is worse, it is a flag rather than a predicate, and so its overuse, along with bit masks, is a prime candidate for being listed as a 'SQL Code Smell'. Joe Celko makes the case.
2011-01-24
3,676 reads
2011-01-21
3,874 reads
2011-01-13
3,869 reads
2011-01-28 (first published: 2011-01-11)
1,624 reads
It is always more efficient to maintain referential integrity by using constraints rather than triggers. Sometimes it isn't obvious how to do this. Until a recent idea by Alex Kuznetsov, the history table presented problems for checking data that were difficult to solve with constraints. Joe Celko explains.
2011-01-11
3,294 reads
2011-01-10
2,912 reads
2011-01-06
2,818 reads
2011-01-04
3,415 reads
The post Analytics vs. Advanced Analytics appeared first on Joyful Craftsmen.
By Brian Kelley
Recently, on a post celebrating a female professional earning a significant achievement within the...
By Rob Sewell
Four of our favorite new themes.
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers