User Remus Rusanu

218 votes

Accepted

When should a primary key be declared non-clustered?

answered Nov 10, 2011 at 22:39

89 votes

Why are numbers tables "invaluable"?

answered Jan 25, 2012 at 0:58

69 votes

Accepted

What is the difference between a connection and a session?

answered Feb 22, 2012 at 20:10

65 votes

Accepted

What is the purpose of the database 'owner'?

answered May 31, 2012 at 9:05

44 votes

Accepted

Table-Valued Parameter as Output parameter for stored procedure

answered Feb 23, 2012 at 18:02

44 votes

Accepted

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

answered Feb 10, 2012 at 18:55

42 votes

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

answered Mar 8, 2012 at 1:12

39 votes

Does restarting SQL Server speed it up?

answered Oct 24, 2011 at 17:54

35 votes

Accepted

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

answered Oct 18, 2011 at 21:38

35 votes

Accepted

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

answered Nov 28, 2011 at 20:09

35 votes

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

answered Mar 14, 2012 at 19:11

34 votes

Accepted

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

answered Mar 4, 2014 at 20:41

31 votes

Accepted

Is NOLOCK always bad?

answered Jan 13, 2012 at 19:23

26 votes

Accepted

SQL Server EXECUTE AS trouble

answered Oct 13, 2012 at 9:52

23 votes

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

answered Oct 23, 2012 at 14:53

23 votes

Accepted

Shrink Transaction Log While Using AlwaysOn Availability Group

answered Aug 13, 2014 at 7:56

23 votes

Error: Cannot Generate SSPI context

answered Feb 21, 2015 at 10:02

22 votes

The DELETE statement conflicted with the REFERENCE constraint

answered Apr 4, 2013 at 12:02

22 votes

Accepted

CHECKPOINT or COMMIT writes to disk?

answered Sep 9, 2014 at 11:35

21 votes

Accepted

Difference between Full backup and Copy-only full backup

answered Jul 8, 2013 at 8:10

21 votes

Accepted

Where to learn SQL Server Service Broker?

answered May 23, 2012 at 11:51

21 votes

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

answered Aug 18, 2014 at 9:56

21 votes

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

answered Jun 7, 2016 at 12:35

20 votes

Accepted

Does SQL Server evaluate functions once for every row?

answered May 28, 2012 at 9:21

20 votes

Unexpected scans during delete operation using WHERE IN

answered Jun 2, 2012 at 21:25

20 votes

Accepted

Improve performance of sys.dm_db_index_physical_stats

answered Jul 10, 2012 at 9:20

20 votes

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

answered Apr 13, 2012 at 23:20

20 votes

Accepted

Does SQL Server 2016 Standard Edition support table partitioning?

answered Dec 30, 2016 at 9:57

19 votes

Accepted

Difference between Owned Schemas and Role Membership for Microsoft SQL Server

answered Feb 22, 2013 at 12:07

19 votes

Accepted

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

answered Dec 24, 2012 at 8:49

Stack Exchange Network

677 Answers

When should a primary key be declared non-clustered?

Why are numbers tables "invaluable"?

What is the difference between a connection and a session?

What is the purpose of the database 'owner'?

Table-Valued Parameter as Output parameter for stored procedure

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

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

Does restarting SQL Server speed it up?

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

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

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

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

Is NOLOCK always bad?

SQL Server EXECUTE AS trouble

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

Shrink Transaction Log While Using AlwaysOn Availability Group

Error: Cannot Generate SSPI context

The DELETE statement conflicted with the REFERENCE constraint

CHECKPOINT or COMMIT writes to disk?

Difference between Full backup and Copy-only full backup

Where to learn SQL Server Service Broker?

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

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

Does SQL Server evaluate functions once for every row?

Unexpected scans during delete operation using WHERE IN

Improve performance of sys.dm_db_index_physical_stats

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

Does SQL Server 2016 Standard Edition support table partitioning?

Difference between Owned Schemas and Role Membership for Microsoft SQL Server

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