User Daniel Hutmacher - Database Administrators Stack Exchange

Daniel Hutmacher

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

Twitter
GitHub
sqlsunday.com
Stockholm, Sweden

196 Answers

Score Activity Newest

43 votes

Accepted

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

answered Nov 19, 2017 at 17:55

30 votes

Why does adding a TOP 1 dramatically worsen performance?

answered Jan 28, 2016 at 19:27

25 votes

Selecting data from another table using a foreign key

answered Feb 11, 2016 at 18:18

17 votes

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

answered Feb 19, 2016 at 10:03

17 votes

Accepted

Add autoincrement to existing PK

answered Feb 5, 2016 at 21:21

16 votes

Accepted

Select data divided in groups evenly distributed by value

answered Feb 1, 2016 at 22:37

15 votes

Accepted

What is the difference between `ORDER BY` and `PARTITION BY` arguments in the `OVER` clause?

answered Mar 23, 2017 at 21:08

14 votes

Accepted

Database: One table or many

answered Jan 26, 2016 at 8:54

13 votes

SARGable WHERE clause for two date columns

answered Mar 16, 2016 at 22:01

12 votes

Field order in a composite index order with high selectivity and low selectivity fields

answered Feb 17, 2016 at 22:56

11 votes

Accepted

CASE expression returns wrong value when using CEILING

answered Apr 24, 2016 at 17:23

10 votes

Invalid Column Using Row_Number()

answered May 12, 2017 at 12:55

10 votes

Accepted

Insert into select into multiple related tables using INSERT_IDENTITY

answered Aug 11, 2014 at 20:02

10 votes

DayOfYear as per Indian fiscal year

answered Jan 11, 2016 at 10:13

9 votes

Accepted

Optimize Subquery with Windowing Function

answered Apr 14, 2017 at 18:24

9 votes

Accepted

DATEADD not producing a SARGable expectation of an index seek

answered Mar 27, 2018 at 15:18

8 votes

How are SQL backups different from IT regular nightly server backups?

answered Feb 22, 2016 at 19:02

8 votes

Accepted

Datawarehouse indexing

answered Jan 31, 2016 at 15:27

7 votes

Optimized date compare in WHERE clause, convert or datediff=0?

answered Feb 4, 2016 at 7:30

7 votes

Purpose of Data Warehousing?

answered Nov 5, 2014 at 20:47

7 votes

Allow users to only view the databases they have access to

answered Jun 13, 2017 at 8:57

6 votes

Accepted

Risks associated with automatically shrinking TempDB as a SQL agent job?

answered May 15, 2017 at 7:31

6 votes

Accepted

Does it make sense to create index with all columns included

answered Mar 16, 2016 at 9:06

6 votes

Accepted

Financial database design

answered Nov 30, 2014 at 21:24

6 votes

Casting fails on subquery result

answered Aug 1, 2014 at 20:28

6 votes

Accepted

Improve a query using cursor to SET Based approach

answered Jan 23, 2016 at 11:06

6 votes

Why is my EXISTS query doing an index scan instead of an index seek?

answered Mar 19, 2016 at 22:41

5 votes

XML parsing slowly

answered Mar 31, 2016 at 5:42

5 votes

Average of last 4 runs of a product

answered Mar 3, 2016 at 19:11

5 votes

Accepted

How to Replicate data between a hosted database and a local database

answered Feb 12, 2016 at 17:40

1

2 3 4 5

…