New posts in Sql Server 2014

Forcing Flow Distinct

SQL Server Insert Into - How to identify the column that is causing truncation error

SQL Server 2014 compression and maximum row size

Select a CSV string as multiple columns

Unable to truncate transaction log, log_reuse_wait_desc - AVAILABILITY_REPLICA

how to generate the creation script for partition function and partition schema?

How does one investigate the performance of a BULK INSERT statement?

Why does this seek on BIGINT col have extra constant scan, compute scalar, and nested loops operators?

Why does Inner Join introduce a hidden sort?

What can be the downside of always having a single integer column as primary key?