Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now
Database Administrators
Remus Rusanu
Meta user
Network profile
Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

677 Answers

Newest Activity Votes
188
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
54
What is the difference between a connection and a session?
Feb 22 '12 at 20:10
53
What is the purpose of the database 'owner'?
May 31 '12 at 9:05
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
29
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
CHECKPOINT or COMMIT writes to disk?
Sep 9 '14 at 11:35
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
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
The DELETE statement conflicted with the REFERENCE constraint
Apr 4 '13 at 12:02
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
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