Clustered Index Uniquifier Existence and Size
In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...
2017-09-19
1,558 reads
In SQL Server, each and every row in a table needs to be accessible by itself, whether or not you...
2017-09-19
1,558 reads
In the previous post in this series on SQLCLR in SQL Server 2017 — Part 4: “Trusted Assemblies” — The Disappointment — we...
2017-09-04
397 reads
Recap
Before we look at “Trusted Assemblies”, let’s take a moment to review the context of the situation. First, the “Good”:...
2017-08-28
1,294 reads
Welcome back, everyone. In the previous post in this series, I explained how to work within the new SQLCLR security...
2017-08-16
688 reads
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
947 reads
The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...
2017-08-07
2,328 reads
In SQL Server Management Studio (SSMS), there are a lot of options and functions. In fact, there are so many...
2017-07-20
1,876 reads
SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...
2017-07-17
555 reads
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
1,972 reads
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
4,471 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers