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 more than a week ago
2 votes
1 answer
1k views

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

1 vote
1 answer
7k views

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

33 votes
1 answer
2k views

SQL Server 2019 executes unreachable code

11 votes
1 answer
2k views

Non-deterministic sum of floats

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

2 votes
2 answers
1k views

sp_cursoropen chooses terrible execution plan

4 votes
2 answers
3k views

"Unrelated" INSERT and UPDATE blocking each other

8 votes
1 answer
831 views

Does SQL Server 2016 still contain sqlmaint.exe?

8 votes
2 answers
16k views

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

33 votes
3 answers
29k views

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

25 votes
3 answers
4k views

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

2 votes
1 answer
124 views

How to migrate a huge application to CONCAT_NULL_YIELDS_NULL ON

11 votes
4 answers
7k views

Invert a Boolean expression which can return UNKNOWN

4 votes
1 answer
821 views

Efficiently search for a prefix range in SQL Server

7 votes
1 answer
6k views

Sudden PRIMARY KEY violation on IDENTITY column

3 votes
3 answers
4k views

"Specify SQL Server administrators" - unusual default value

2 votes
2 answers
447 views

Statistics that are neither auto_created nor user_created

1 vote
1 answer
150 views

What relevance does the table-level ANSI_NULL setting have?

14 votes
1 answer
425 views

Should NOT IN be avoided?

4 votes
1 answer
481 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?