user avatar
user avatar
user avatar
StrayCatDBA
  • Member for 9 years, 7 months
  • Last seen this week
  • Lowell, AR, United States
17 votes
Accepted

SQL Server Transaction Backups vs Logs

12 votes
Accepted

Concatenation Physical Operation: Does it guarantee order of execution?

10 votes

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

9 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?

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

5 votes

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

4 votes

CPUs Used for a SQL Server Instance

4 votes

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

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

How to achieve Dynamic SQL Query with Multiple parmeters to handle null values also

1 vote
Accepted

Good practices for patching SQL nodes in High Availability solution