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:...

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...

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...

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...

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...

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...

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...

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...

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...

Yes, Foreign Keys Help Performance

I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example....