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

677 Answers

Newest Activity Votes
187
When should a primary key be declared non-clustered?
Nov 10 '11 at 22:39
81
Why are numbers tables “invaluable”?
Jan 25 '12 at 0:58
53
What is the purpose of the database 'owner'?
May 31 '12 at 9:05
51
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
37
Does restarting SQL Server speed it up?
Oct 24 '11 at 17:54
36
Should I use many single field indexes, instead of specific multi column indexes?
Feb 10 '12 at 18:55
35
Table-Valued Parameter as Output parameter for stored procedure
Feb 23 '12 at 18:02
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
31
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
30
Is NOLOCK always bad?
Jan 13 '12 at 19:23
27
How do I get a list of all the partitioned tables in my database?
Mar 14 '12 at 19:11
24
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
Shrink Transaction Log While Using AlwaysOn Availability Group
Aug 13 '14 at 7:56
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
20
Where to learn SQL Server Service Broker?
May 23 '12 at 11:51
19
Simulate deadlock with more than 2 processes
May 25 '16 at 13:32
19
CHECKPOINT or COMMIT writes to disk?
Sep 9 '14 at 11:35
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
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 2008 - Partitioning and Clustered Indexes
Mar 29 '11 at 23:58
18
SQL Server - Temporary vs. Physical Tables
Jul 4 '10 at 17:19
17
The DELETE statement conflicted with the REFERENCE constraint
Apr 4 '13 at 12:02
17
Implementing subtype of a subtype in type/subtype design pattern with mutually exclusive subclasses
Jun 7 '16 at 12:35
17
How can I prove that the following T-SQL is bad for performance?
Sep 16 '13 at 10:34
17
SQL Server Express on Windows 8 isn't locking MDF database files
Mar 26 '13 at 7:52
1 2 3 4 5 … 23