Reputation
3,756
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 7 31
Newest
 Civic Duty
Impact
~19k people reached

2d
awarded  Civic Duty
2d
answered Is there a way to force Deferred Name Resolution even if the table exists when creating a sproc?
Jan
15
awarded  Nice Answer
Jan
15
revised SQL Server 2014 COUNT(DISTINCT x) ignores statistics density vector for column x
added 187 characters in body
Jan
15
accepted SQL Server 2014 COUNT(DISTINCT x) ignores statistics density vector for column x
Jan
14
awarded  Nice Answer
Jan
13
comment Is there impact on query execution as more partitions are added to a table?
The short answer: yes. However, whether that impact is a positive, negative, or a more nuanced mix of the two depends entirely on what you are trying to do. If you post the full table definition and example query that you are trying to optimize, we may be able to help.
Jan
13
awarded  Nice Question
Jan
13
revised SQL Server 2014 COUNT(DISTINCT x) ignores statistics density vector for column x
Specify which trace flag shows the selectivity estimates in SQL 2014
Jan
13
awarded  Enlightened
Jan
13
awarded  Nice Answer
Jan
12
revised How to make use of Batch Mode with an UNPIVOT (a loop join)?
added 1013 characters in body
Jan
12
revised How to make use of Batch Mode with an UNPIVOT (a loop join)?
added 5 characters in body
Jan
12
revised How to make use of Batch Mode with an UNPIVOT (a loop join)?
added 284 characters in body
Jan
12
revised How to make use of Batch Mode with an UNPIVOT (a loop join)?
fix type in query column alias
Jan
12
revised SQL Server 2014 COUNT(DISTINCT x) ignores statistics density vector for column x
added 108 characters in body
Jan
12
revised How to make use of Batch Mode with an UNPIVOT (a loop join)?
added 1339 characters in body
Jan
12
revised How to make use of Batch Mode with an UNPIVOT (a loop join)?
added 663 characters in body
Jan
12
answered How to make use of Batch Mode with an UNPIVOT (a loop join)?
Jan
12
asked SQL Server 2014 COUNT(DISTINCT x) ignores statistics density vector for column x