user avatar
user avatar
user avatar
variable
  • Member for 3 years, 9 months
  • Last seen this week
10 votes
3 answers
2k views

Are the limits of varchar(8000) and nvarchar(4000) because of the sql server page size (8KB=8192 Bytes)?

9 votes
3 answers
918 views

What is the point of TRY CATCH block when XACT_ABORT is turned ON?

8 votes
1 answer
24k views

Always On Failover Clustering vs Always On Availability Groups

7 votes
1 answer
674 views

What are the problems with using NOLOCK given an approach to handle the short comings?

7 votes
3 answers
2k views

What does SQL server do with the query output once it is read by the client?

6 votes
2 answers
565 views

Which execution plan is stored in the plan cache?

5 votes
3 answers
529 views

Does upgrading the database compatibility level post migration result in any breaking results?

5 votes
2 answers
292 views

Is the data exchange on connection from client to server sent as plain text over the wire?

5 votes
2 answers
568 views

With a multi column non clustered index, and the SELECT on middle column, why does SQL server query this index rather than scanning the table?

5 votes
2 answers
427 views

Backup cut-off time for Full, Differential, Log, File, Partial backups

5 votes
2 answers
491 views

Will non copy only full backup impact transaction log backups chain?

4 votes
4 answers
3k views

SQL server database backup - Destination Disk - Adding multiple files - does it duplicate or split backup into the files?

4 votes
1 answer
2k views

What does the maximum SQL Server memory configuration limit?

4 votes
3 answers
899 views

How to recover from a SQL server log file drive crash?

3 votes
1 answer
78 views

How to conclude whether the full text service is installed and/or used?

3 votes
3 answers
77 views

Why is total and target server memory never reaching the configured memory value?

3 votes
2 answers
87 views

Does selecting data from heap (table without clustered index) with nolock block writers?

3 votes
2 answers
66 views

Whether `SQL Server: Memory Manager: Target Server Memory (KB)` is ideal amount of memory based on recent workload OR the max memory setting?

3 votes
1 answer
385 views

Why does WITH(NOLOCK) take shared locks and don't such locks block writes?

3 votes
2 answers
3k views

Database backup - Use case of FORMAT and INIT

3 votes
1 answer
3k views

Always ON - What is the difference between the virtual cluster name and Listener

3 votes
3 answers
308 views

How to reset session in management studio tab?

3 votes
1 answer
355 views

What is the difference between database snapshot and VSS database snapshot backup?

3 votes
1 answer
153 views

Manual log backup makes restore strategy useless upto next full backup only?

3 votes
2 answers
1k views

Can indexing be a solution to SQL deadlocks that are caused due to lock resources?

3 votes
2 answers
430 views

How does SQL Server handle parallel UPDATE transaction that prospectively would result into rows that would match the WHERE clause of 1st transaction?

2 votes
1 answer
137 views

Does sql server lock entire table and keep it locked when the table is heap?

2 votes
1 answer
135 views

Why is “Access this computer from the network” permission required for proxy credential?

2 votes
1 answer
175 views

What is the difference between creating database role and application role?

2 votes
1 answer
84 views

Does simple recovery model not log bulk inserts?

1
2 3 4 5
9