Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than SQL Server?… Continue reading Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT...
2020-02-03 (first published: 2020-01-24)
3,096 reads
A Completely Complete Guide to how many bytes are used to represent characters in the T-SQL string datatypes… Continue reading How Many Bytes Per Character in SQL Server: a...
2019-12-04 (first published: 2019-11-22)
3,652 reads
A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...
2019-08-19 (first published: 2019-08-05)
1,081 reads
What is the maximum number of rows for the Table Value Constructor? And, do different uses of it behave differently?… Continue reading Maximum Number of Rows for the Table...
2019-05-27 (first published: 2019-05-09)
755 reads
(last updated: 2019-05-05 @ 11:55 EST / 2019-05-05 @ 15:55 UTC ) I had gone through the process of uninstalling the now obsolete SQL Server 2019 CTP, and then...
2019-05-20 (first published: 2019-05-05)
2,684 reads
(last updated: 2019-04-22 @ 13:00 EST / 2019-04-22 @ 17:00 UTC ) SQL Server 2012 introduced a significant improvement to CREATE CERTIFICATE: the ability to import a certificate —...
2019-05-03 (first published: 2019-04-22)
472 reads
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,222 reads