Daniel Hutmacher

Member for 9 years, 4 months
Last seen more than a week ago

Twitter
GitHub
sqlsunday.com
Stockholm, Sweden

Summary

Reputation

9,095

9.1k
8.7k
8.3k

2020
2021
2022
2023

Top tag

sql-server

Next privilege

10,000 Rep.

Access moderator tools

Badges

1

25

52

Newest

Notable Question

Next badge

63/80

Strunk & White

Answers

View all 196 answers

Score Activity Newest

43

Using source columns in OUTPUT INTO clause of an INSERT statement (SQL Server)

Nov 19, 2017

30

Why does adding a TOP 1 dramatically worsen performance?

Jan 28, 2016

25

Selecting data from another table using a foreign key

Feb 11, 2016

17

query processor ran out of internal resources - extremely long sql query

Feb 19, 2016

17

Add autoincrement to existing PK

Feb 5, 2016

Questions

View all 6 questions

Score Activity Newest Views

43

Why does changing the declared join column order introduce a sort?

Aug 16, 2018

11

ROW_NUMBER() without PARTITION BY still generates Segment iterator

Dec 2, 2014

11

How to reset statistics after UPDATE STATISTICS ... WITH ROWCOUNT

Feb 27, 2016

8

How can I achieve predicate pushdown in my view

Jul 24, 2021

6

Deploying and rolling back changes in an Availability Group database

Aug 9, 2016

Tags

View all 144 tags

sql-server

478

Score

132

posts

performance

123

Score

24

posts

query-performance

115

Score

19

posts

sql-server-2012

104

Score

24

posts

t-sql

90

Score

22

posts

Reputation

+10

XML parsing slowly

+10

Cross-product between table column and input values

+10

Query data before a commit transaction

+10

Select data divided in groups evenly distributed by value

Badges

View all badges

1

gold badge

Famous Question

Dec 2, 2015

25

silver badges

sql-server

Mar 29, 2018
Civic Duty

Feb 6, 2016
Guru

Aug 15, 2022

52

bronze badges

sql-server-2012

Jan 18, 2019
performance

Jan 3, 2020
Altruist

May 16, 2015

Accounts

View all 9 accounts

Database Administrators

9,095
1
25
52

213
1
6

121
4

116
5

101
2

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

692

upvotes

72

downvotes

206

question votes

558

answer votes