Reputation
783
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 9 27
Impact
~49k people reached

  • 0 posts edited
  • 13 helpful flags
  • 103 votes cast
Apr
20
asked Creating clustered primary key index with ONLINE option
Apr
13
accepted Incorrect statistics are used on index seek
Apr
12
comment Incorrect statistics are used on index seek
This is not generic answer at all. I use the SQL Sentry Plan Explorer and confirm that the engine is working with the correct estimations in the given example. I have read before your article about the temporary table statistics - as I am building dynamic SQL statements (executed with sp_executesql) the temp table statistics are not an issue.
Apr
11
comment Incorrect statistics are used on index seek
@MarkSinkinson No, I can't because there are a lot of logic and operations there.
Apr
11
asked Incorrect statistics are used on index seek
Mar
18
accepted How to use COLUMNS_UPDATED to check if any of certain columns are updated?
Mar
17
asked How to use COLUMNS_UPDATED to check if any of certain columns are updated?
Mar
16
awarded  Famous Question
Mar
1
accepted How to get the size of a spatial index?
Feb
29
asked How to get the size of a spatial index?
Jan
30
awarded  Nice Question
Jan
19
accepted How to install Microsoft SQL Server 2014 Standard Edition on trial?
Jan
18
revised How to install Microsoft SQL Server 2014 Standard Edition on trial?
added 148 characters in body
Jan
18
asked How to install Microsoft SQL Server 2014 Standard Edition on trial?
Jan
4
awarded  Famous Question
Dec
23
awarded  Popular Question
Dec
20
awarded  Popular Question
Dec
14
awarded  Popular Question
Dec
8
comment How to name table-variable function unique constraint?
@srutzky Yes, I have already checked it. Just being surprised.
Dec
8
accepted How to name table-variable function unique constraint?