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

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

16 votes
Accepted

Select data divided in groups evenly distributed by value

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
Accepted

Insert into select into multiple related tables using INSERT_IDENTITY

10 votes

DayOfYear as per Indian fiscal year

10 votes

Invalid Column Using Row_Number()

9 votes
Accepted

DATEADD not producing a SARGable expectation of an index seek

9 votes
Accepted

Optimize Subquery with Windowing Function

8 votes
Accepted

Datawarehouse indexing

8 votes

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

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
Accepted

Find all instances where a user has been explicitly granted permissions on an object

5 votes

Use Distinct With Sum?

1
2 3 4 5
7