Skip to main content
Share Your Experience: Take the 2024 Developer Survey
usr's user avatar
usr's user avatar
usr's user avatar
usr
  • Member for 12 years, 3 months
  • Last seen more than a month ago
1 vote

How to prove the lack of implicit order in a database?

1 vote
Accepted

Does SQL Server allow moving backwards with standby file?

2 votes

sp_send_dbmail usage best practice

2 votes

Optimizing SQL Server for an app that repeatedly hits the database with the exact same query?

3 votes

Why SQL server does not have column-level locking?

6 votes
Accepted

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

6 votes

Why can't a differential backup specify its base?

5 votes
Accepted

Dropping PLE on query

11 votes

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

5 votes
Accepted

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

0 votes

What process would you use to determine references on a database that has no integrity?

2 votes

Does a covering nonclustered index help to answer Select * queries?

2 votes
Accepted

How to Resolve Corruption Detected by BACKUP WITH CHECKSUM, But NOT DBCC CHECKDB?

6 votes
Accepted

Will the Query Optimizer Ignore A Fragmented Index?

4 votes

How many backup devices is recommended to improve backup performance?

0 votes

Does index rebuild time depend on the fragmentation level?

0 votes

SQL Server 2008 R2 Partitioning - same FileGroup, 1 File, 2 partition_numbers - HELP

3 votes

How is combined index implemented in SQL Server

4 votes
Accepted

Can I restore a differential backup to the 2nd newest full backup?

1 vote

Joining from database A to view in database B; where is processing done?

4 votes

What is lost when I create a Foreign Key using `WITH NOCHECK`?

0 votes

Select statements during long update

3 votes

Operation System error 665 with VLDB backup (The requested operation could not be completed due to a file system limitation)

1 vote

Move a Filestream column between tables

3 votes
Accepted

Order of DROP_EXISTING and ONLINE for CREATE INDEX

4 votes
Accepted

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

6 votes
Accepted

Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables

6 votes

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

1 vote

Why is vertical scaling expensive?

3 votes

Getting a realistic query plan when partitioning with low volumes of data