Skip to main content
Erik Darling's user avatar
Erik Darling's user avatar
Erik Darling's user avatar
Erik Darling
  • Member for 10 years, 5 months
  • Last seen this week
102 votes
Accepted

Why is my query suddenly slower than it was yesterday?

65 votes
Accepted

What are different ways to replace ISNULL() in a WHERE clause that uses only literal values?

57 votes
Accepted

Slower SQL Server performance after allocating more CPU and RAM

49 votes
Accepted

Why does SQL Server use a better execution plan when I inline the variable?

47 votes
Accepted

Why does SQL Server return some rows while still executing the query, and sometimes not?

39 votes
Accepted

Does SQL Server support GREATEST and LEAST, if not what is the common workaround?

37 votes
Accepted

If a database only ever has one insert, is it bad to index every possible column combination?

37 votes
Accepted

SQL Server returns "Arithmetic overflow error converting expression to data type int."

35 votes
Accepted

Warning about memory "Excessive Grant" in the query plan - how to find out what is causing it?

33 votes
Accepted

SQL Server--If logic in stored procedure and the plan cache

32 votes

SQL Server has encountered occurences of I/O requests taking longer than 15 seconds

31 votes

Hide Select Output from T-SQL

31 votes

Cast to date is sargable but is it a good idea?

30 votes
Accepted

What will happen if I drop an existing partition scheme/function from a table with (huge volume of records)?

26 votes

Why would a SELECT query cause writes?

26 votes
Accepted

Does SQL Server's serializable isolation level lock entire table

25 votes

What does % in this WHERE clause do?

23 votes
Accepted

Best way to put commas into large numbers

22 votes
Accepted

If a CTE is defined in a query and is never used, does it make a sound?

22 votes
Accepted

SQL counting distinct over partition

20 votes

What happens to queries that are in progress when we change maxdop in live system and while they are executing?

20 votes
Accepted

Order By causes a scan on a large table

19 votes
Accepted

Why doesn't SQL Server have any missing index requests in the DMVs or Query Plans?

18 votes

Why is it recommended to store BLOBs in separate SQL Server tables?

18 votes

Best way to migrate a huge SQL Server database with low downtime over network

17 votes
Accepted

Better approach for "LIKE OR LIKE, OR LIKE, OR LIKE, OR LIKE"

17 votes

Colleague says to never use an OR statement in SQL, is this true?

17 votes
Accepted

Is it possible for SQL Server to grant more memory to a query than is available to the instance

16 votes
Accepted

Substring join or additional table, which is faster?

15 votes
Accepted

for xml path('') output

1
2 3 4 5
21