As of May 31, 2023, we have updated our Code of Conduct.
StrayCatDBA's user avatar
StrayCatDBA's user avatar
StrayCatDBA's user avatar
StrayCatDBA
  • Member for 10 years, 6 months
  • Last seen this week
  • Lowell, AR, United States
17 votes
Accepted

SQL Server Transaction Backups vs Logs

13 votes
Accepted

Concatenation Physical Operation: Does it guarantee order of execution?

11 votes

Is it safe to rely on a shadow volume backup of the mdf and ldf files?

10 votes
Accepted

Non-yielding IOCP Listener

9 votes
Accepted

linked list in SQL and Trees

8 votes
Accepted

Are database query optimizers aware of storage performance differences?

7 votes

Can Availability Groups replace transactional replication?

6 votes

How to avoid a select query for holding a Sch-S lock

6 votes
Accepted

Why does memory reported by sys.dm_os_buffer_descriptors not match the max server memory when large db tables are queried? (Table size > max memory)

5 votes
Accepted

Lock escalation problem on a trigger

5 votes
Accepted

Buffer usage for index with no reads

5 votes

Detecting SQL Server Utilization with a query

4 votes

What is the significance of root and page level fragmentation in a clustered b-tree index?

4 votes

CPUs Used for a SQL Server Instance

3 votes
Accepted

Parameter triggers different execution plan, but why?

3 votes

In-memory and hard-drive hybrid

3 votes

Moving one TempdB on 3 instance server

3 votes
Accepted

SQL Server fsync Options

3 votes
Accepted

maintaining full text index on large table

3 votes
Accepted

Linked SQL Server Issue

3 votes

Should I worry about failed login attempts on SQL Server

2 votes

Load Testing When SQL Server Caching Is Disabled

2 votes

Header and line item data source mismatch

2 votes

dimension table with "like" condition

2 votes
Accepted

How would I change this relational model to fit a nosql database?

2 votes

Nonclustered index is faster than clustered index?

2 votes
Accepted

SQL Server Full-Text Indexer with stoplists/stopwords

2 votes

Conditional WHERE clause

2 votes

MS SQL server - linked server target configuration

2 votes
Accepted

What database level permissions are needed for to Transfer a Procedure to another schema