Skip to main content
Remus Rusanu's user avatar
Remus Rusanu's user avatar
Remus Rusanu's user avatar
Remus Rusanu
  • Member for 13 years, 6 months
  • Last seen more than a month ago
220 votes
Accepted

When should a primary key be declared non-clustered?

89 votes

Why are numbers tables "invaluable"?

69 votes
Accepted

What is the difference between a connection and a session?

66 votes
Accepted

What is the purpose of the database 'owner'?

44 votes
Accepted

Table-Valued Parameter as Output parameter for stored procedure

44 votes
Accepted

Should I use many single field indexes, instead of specific multi column indexes?

43 votes

SQL Server "empty table" is slow after deleting all (12 million) records?

39 votes

Does restarting SQL Server speed it up?

35 votes
Accepted

How can I alter an existing Primary Key on SQL Azure?

35 votes
Accepted

Is the concept of a clustered index in a DB design sensical when using SSDs?

35 votes

How do I get a list of all the partitioned tables in my database?

34 votes
Accepted

When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?

31 votes
Accepted

Is NOLOCK always bad?

26 votes
Accepted

SQL Server EXECUTE AS trouble

23 votes

Is SELECT ROW_NUMBER() guaranteed to return results sorted by the generated row numbers?

23 votes
Accepted

Shrink Transaction Log While Using AlwaysOn Availability Group

23 votes

Error: Cannot Generate SSPI context

22 votes

The DELETE statement conflicted with the REFERENCE constraint

22 votes

How to escape '%' inside varchar @params for RAISERROR funcion in SQL Server 2012

22 votes
Accepted

CHECKPOINT or COMMIT writes to disk?

21 votes
Accepted

Difference between Full backup and Copy-only full backup

21 votes
Accepted

Where to learn SQL Server Service Broker?

21 votes

Implementing subtype of a subtype in type/subtype design pattern with mutually exclusive subclasses

21 votes
Accepted

Does SQL Server 2016 Standard Edition support table partitioning?

20 votes
Accepted

Difference between Owned Schemas and Role Membership for Microsoft SQL Server

20 votes
Accepted

what is difference between last_worker_time and last_elapsed_time in DMV sys.dm_exec_query_stats?

20 votes
Accepted

Does SQL Server evaluate functions once for every row?

20 votes

Unexpected scans during delete operation using WHERE IN

20 votes
Accepted

Improve performance of sys.dm_db_index_physical_stats

20 votes

High Disk I/O from sql server or is High disk I/O slowing sql server?

1
2 3 4 5
23