user avatar
user avatar
user avatar
usr
  • Member for 10 years, 4 months
  • Last seen more than a month ago
22 votes
Accepted

SQL Server's READ COMMITTED SNAPSHOT vs SNAPSHOT

22 votes

Using indexed views for aggregates - too good to be true?

15 votes
Accepted

Deadlocks From Locks on Same Temporary Tables In Different Processes

11 votes

Field order in a composite index order with high selectivity and low selectivity fields

10 votes

How do I include nulls during comparisons in SQL Server?

8 votes

SQL Server clustered index, index balancing and insert performance using NewID

8 votes
Accepted

SQL Native backup MIRROR TO performance

8 votes
Accepted

Database design for handling 1 billion rows and counting

7 votes

DBCC CHECKDB unfixable corruption: Indexed view contains rows that were not produced by the view definition

7 votes
Accepted

Is the runtime of checking for duplicate primary keys in SQL Server O(n)?

6 votes

In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?

6 votes
Accepted

Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables

6 votes

Create a new database in SQL Server 2008 R2, but it is not Blank

6 votes
Accepted

Why is my database stuck in the Restoring state?

6 votes
Accepted

Large Transaction Log Backups in Service Broker-enabled system

6 votes

Maximum table capacity in SQL Server 2008

6 votes
Accepted

Will the Query Optimizer Ignore A Fragmented Index?

6 votes
Accepted

Large (>22 trillion items) geospatial dataset with rapid (<1s) read query performance

5 votes

Backup internals - What happens when a backup job is running - in terms of locking and performance overhead in SQL Server?

5 votes
Accepted

Dropping PLE on query

5 votes

Why can't a differential backup specify its base?

5 votes
Accepted

Why does SQL Server require non-clustered index to use unique keys?

5 votes

Splitting a table based on business logic

5 votes
Accepted

Strange SQL Statement Behavior

5 votes
Accepted

Merge faster than Insert

4 votes
Accepted

Is there a less manual way of changing database properties for all databases in an instance?

4 votes
Accepted

Dramatic decrease in SQL Azure performance after scaling to new edition

4 votes

What is the minimum required compatibility level to use parallel SELECT INTO?

4 votes
Accepted

Simulate more RAM with SQL Server

4 votes
Accepted

Sequential GUID or bigint for 'huge' database table PK