Daniel Hutmacher's user avatar
Daniel Hutmacher's user avatar
Daniel Hutmacher's user avatar
Daniel Hutmacher
  • Member for 9 years, 7 months
  • Last seen more than a week ago
44 votes
Accepted

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

30 votes

Why does adding a TOP 1 dramatically worsen performance?

25 votes

Selecting data from another table using a foreign key

17 votes
Accepted

Add autoincrement to existing PK

17 votes

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

16 votes
Accepted

Select data divided in groups evenly distributed by value

16 votes
Accepted

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

14 votes
Accepted

Database: One table or many

13 votes

SARGable WHERE clause for two date columns

12 votes

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

11 votes
Accepted

CASE expression returns wrong value when using CEILING

10 votes

Invalid Column Using Row_Number()

10 votes
Accepted

Insert into select into multiple related tables using INSERT_IDENTITY

10 votes

DayOfYear as per Indian fiscal year

9 votes
Accepted

Optimize Subquery with Windowing Function

9 votes
Accepted

DATEADD not producing a SARGable expectation of an index seek

8 votes

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

8 votes
Accepted

Datawarehouse indexing

7 votes

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

7 votes

Purpose of Data Warehousing?

7 votes

Allow users to only view the databases they have access to

6 votes
Accepted

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

6 votes
Accepted

Financial database design

6 votes

Casting fails on subquery result

6 votes
Accepted

Improve a query using cursor to SET Based approach

6 votes
Accepted

Does it make sense to create index with all columns included

6 votes

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

5 votes

XML parsing slowly

5 votes

Average of last 4 runs of a product

5 votes
Accepted

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

1
2 3 4 5
7