21,867 reputation
661124
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 9 months
seen 42 mins ago

Dec
19
revised Retrieving n rows per group
Added bounty, examples, removed tag
Dec
19
revised In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?
Added SQLCLR implementation
Dec
19
revised In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?
Added SQLCLR implementation
Dec
19
revised How do I create a partition using a bit field in SQL Server 2014
added 173 characters in body
Dec
19
revised How do I create a partition using a bit field in SQL Server 2014
added 402 characters in body
Dec
18
revised Questions about the SET DATEFORMAT command
deleted 4 characters in body; edited tags; edited title
Dec
18
revised Adding subpartitions to existing partitioned table
Removed tag from title, added version subtag, minor formatting
Dec
18
revised Different thread states in query execution
Removed tag from title, minor formatting and typo corrections
Dec
18
revised Results for every hour of the day even data if not present
deleted 9 characters in body
Dec
18
revised Results for every hour of the day even data if not present
added 435 characters in body; edited tags; edited title
Dec
18
revised Grant users privilege to use QUERYTRACEON 9481
added 26 characters in body; edited title
Dec
17
revised Retrieving n rows per group
added 102 characters in body
Dec
17
revised Excessive sort memory grant
added 8 characters in body
Dec
17
revised What are the alternates to replication?
added 6 characters in body; edited tags; edited title
Dec
17
revised After mysql server restarts I cannot see my own database
rolled back to a previous revision
Dec
17
revised After mysql server restarts I cannot see my own database
Formatting
Dec
17
revised Convert a date to yyyymmdd format
deleted 42 characters in body; edited tags; edited title
Dec
17
revised Evaluation edition expired
added 1 character in body; edited tags; edited title
Dec
17
revised Does SQL Server CASE statement evaluate all conditions or exit on first TRUE condition?
added 45 characters in body; edited tags
Dec
17
revised How to add an automatically-populated custom sequence number?
added 18 characters in body; edited tags; edited title