Repairing a replication subscriber

It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...

I'm alive!!!!

Hi all!
Sorry for long delay but i was a pretty busy preparing SQLSat
Now mission is accomplished and i'll return to...

No thrills about spills

Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...

Predicates and Event Data

At one time or another, a predicate has been the best friend or worst enemy of the data professional. If...

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