No thrills about spills
Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...
2015-09-21
766 reads
Blog Posts
Predicates and Event Data
A predicate is a filtering mechanism used in SQL Server to target specific data when either querying or updating rows.
Related Posts:
Short Circuiting Your Session January 5, 2019
How To:...
2015-09-21
6 reads
Predicates and Event Data
At one time or another, a predicate has been the best friend or worst enemy of the data professional. If...
2015-09-21
718 reads
Simple Merges KDiff3 at SQL in the City
One of the hassles of working in a development team is that you will have conflicts between your code and...
2015-09-21
1,042 reads
Speaking at SQLSaturday #446, Oregon 2015
I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as...
2015-09-21
434 reads
Step by Step SSIS - Conditional Split Transformation TIP #117
In the series of Zero to Hero in SSIS this is our next post. In this post we will see...
2015-09-21
3,275 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
646 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
367 reads
Why I hate Pie Charts
The pie chart should be avoided at all costs. Why?
you can only display a limited number of slices (although that...
2015-09-21
541 reads
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
304 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers