Database Administrators
Profile Activity
Meta user
Network profile
Remus Rusanu
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

677 Answers

Votes Activity Newest
197
When should a primary key be declared non-clustered?
Nov 10 '11 at 22:39
82
Why are numbers tables “invaluable”?
Jan 25 '12 at 0:58
59
What is the purpose of the database 'owner'?
May 31 '12 at 9:05
58
What is the difference between a connection and a session?
Feb 22 '12 at 20:10
42
SQL Server “empty table” is slow after deleting all (12 million) records?
Mar 8 '12 at 1:12
39
Should I use many single field indexes, instead of specific multi column indexes?
Feb 10 '12 at 18:55
38
Table-Valued Parameter as Output parameter for stored procedure
Feb 23 '12 at 18:02
37
Does restarting SQL Server speed it up?
Oct 24 '11 at 17:54
34
How can I alter an existing Primary Key on SQL Azure?
Oct 18 '11 at 21:38
34
Is the concept of a clustered index in a DB design sensical when using SSDs?
Nov 28 '11 at 20:09
33
When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
Mar 4 '14 at 20:41
31
Is NOLOCK always bad?
Jan 13 '12 at 19:23
30
How do I get a list of all the partitioned tables in my database?
Mar 14 '12 at 19:11
26
SQL Server EXECUTE AS trouble
Oct 13 '12 at 9:52
22
Is SELECT ROW_NUMBER() guaranteed to return results sorted by the generated row numbers?
Oct 23 '12 at 14:53
21
CHECKPOINT or COMMIT writes to disk?
Sep 9 '14 at 11:35
21
Shrink Transaction Log While Using AlwaysOn Availability Group
Aug 13 '14 at 7:56
21
Where to learn SQL Server Service Broker?
May 23 '12 at 11:51
20
The DELETE statement conflicted with the REFERENCE constraint
Apr 4 '13 at 12:02
20
Improve performance of sys.dm_db_index_physical_stats
Jul 10 '12 at 9:20
20
Unexpected scans during delete operation using WHERE IN
Jun 2 '12 at 21:25
19
Simulate deadlock with more than 2 processes
May 25 '16 at 13:32
19
High Disk I/O from sql server or is High disk I/O slowing sql server?
Apr 13 '12 at 23:20
19
Determining how a schema change occurred?
Jan 16 '12 at 23:55
19
SQL Server 2008 - Partitioning and Clustered Indexes
Mar 29 '11 at 23:58
18
Implementing subtype of a subtype in type/subtype design pattern with mutually exclusive subclasses
Jun 7 '16 at 12:35
18
Difference between Owned Schemas and Role Membership for Microsoft SQL Server
Feb 22 '13 at 12:07
18
SQL Server database on an SSD - any advantage to a separate file for every table?
Feb 27 '12 at 22:08
18
SQL Server - Temporary vs. Physical Tables
Jul 4 '10 at 17:19
17
How can I prove that the following T-SQL is bad for performance?
Sep 16 '13 at 10:34
1
2 3 4 5
…
23