Skip to main content
Heinzi's user avatar
Heinzi's user avatar
Heinzi's user avatar
Heinzi
  • Member for 12 years, 6 months
  • Last seen this week
2 votes
1 answer
1k views

OBJECT_ID(...) function vs join on sys.tables and sys.schemas

33 votes
3 answers
29k views

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

11 votes
4 answers
7k views

Invert a Boolean expression which can return UNKNOWN

33 votes
1 answer
2k views

SQL Server 2019 executes unreachable code

1 vote
1 answer
6k views

What can I do with VIEW DEFINITION permissions that I can't do with ALTER permissions?

8 votes
2 answers
16k views

How do I translate a Windows SID to an SQL Server server_user_sid?

14 votes
1 answer
422 views

Should NOT IN be avoided?

11 votes
1 answer
2k views

Non-deterministic sum of floats

8 votes
1 answer
830 views

Does SQL Server 2016 still contain sqlmaint.exe?

23 votes
5 answers
4k views

Can SQL Server's crash resilience be improved?

26 votes
3 answers
1k views

SQL Server splits A <> B into A < B OR A > B, yielding strange results if B is non-deterministic

25 votes
3 answers
4k views

How do I cancel an app lock request in SQL Server?

4 votes
2 answers
3k views

"Unrelated" INSERT and UPDATE blocking each other

2 votes
2 answers
1k views

sp_cursoropen chooses terrible execution plan

7 votes
1 answer
6k views

Sudden PRIMARY KEY violation on IDENTITY column

2 votes
1 answer
124 views

How to migrate a huge application to CONCAT_NULL_YIELDS_NULL ON

4 votes
1 answer
804 views

Efficiently search for a prefix range in SQL Server

3 votes
3 answers
4k views

"Specify SQL Server administrators" - unusual default value

2 votes
2 answers
443 views

Statistics that are neither auto_created nor user_created

1 vote
1 answer
149 views

What relevance does the table-level ANSI_NULL setting have?

4 votes
1 answer
478 views

Can I tell SQL Server to "do something" when a connection is closed?

5 votes
1 answer
453 views

GROUP BY on a dependent field

30 votes
3 answers
8k views

Why does ANSI SQL define SUM(no rows) as NULL?

16 votes
1 answer
5k views

How do I find out *why* a user has certain effective permissions?