New posts in Sql Server 2016

What is a scalable way to simulate HASHBYTES using a SQL CLR scalar function?

Nested Loop has very low estimates due to skewed data

No Primary Key in some sql server tables

Help with wait type CHECK_TABLES_THREAD_BARRIER

Finding the Min value for a subgroup, filtering out preceding Min values within the same parent group

Is there any difference between a predicate using a literal value or a parameter value when that value will always be the same?

Query processor could not produce a query plan because of the hints defined in this query

SQL Staging Tables: Primary Key Clustered or Heap

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

How many partitions should I make for my clustered columnstore index tables? Should I partition the rowstore tables also?