User StrayCatDBA

17 votes

Accepted

SQL Server Transaction Backups vs Logs

answered Apr 18, 2013 at 3:41

13 votes

Accepted

Concatenation Physical Operation: Does it guarantee order of execution?

answered Apr 8, 2013 at 16:55

11 votes

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

answered Dec 3, 2012 at 16:21

10 votes

Accepted

Non-yielding IOCP Listener

answered Jan 26, 2013 at 18:24

9 votes

Accepted

linked list in SQL and Trees

answered Jul 12, 2013 at 17:08

8 votes

Accepted

Are database query optimizers aware of storage performance differences?

answered Apr 25, 2013 at 9:26

7 votes

Can Availability Groups replace transactional replication?

answered Jun 19, 2013 at 18:58

6 votes

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

answered May 22, 2018 at 18:58

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)

answered Aug 31, 2022 at 13:55

5 votes

Accepted

Lock escalation problem on a trigger

answered Apr 16, 2013 at 20:33

5 votes

Accepted

Buffer usage for index with no reads

answered Apr 17, 2013 at 21:14

5 votes

Detecting SQL Server Utilization with a query

answered Feb 12, 2013 at 16:51

4 votes

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

answered Feb 22, 2013 at 21:45

4 votes

CPUs Used for a SQL Server Instance

answered Nov 19, 2021 at 18:00

3 votes

Accepted

Parameter triggers different execution plan, but why?

answered Feb 12, 2013 at 17:00

3 votes

In-memory and hard-drive hybrid

answered Dec 6, 2012 at 16:05

3 votes

Moving one TempdB on 3 instance server

answered Apr 18, 2013 at 4:07

3 votes

Accepted

SQL Server fsync Options

answered Jun 27, 2013 at 11:01

3 votes

Accepted

maintaining full text index on large table

answered Apr 27, 2013 at 20:49

3 votes

Accepted

Linked SQL Server Issue

answered Feb 7, 2018 at 19:14

3 votes

Should I worry about failed login attempts on SQL Server

answered Mar 14, 2018 at 17:30

2 votes

Load Testing When SQL Server Caching Is Disabled

answered Mar 14, 2018 at 17:06

2 votes

Header and line item data source mismatch

answered Apr 25, 2013 at 10:34

2 votes

dimension table with "like" condition

answered May 22, 2013 at 15:02

2 votes

Accepted

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

answered May 22, 2013 at 16:17

2 votes

Nonclustered index is faster than clustered index?

answered Jun 18, 2013 at 17:31

2 votes

Accepted

SQL Server Full-Text Indexer with stoplists/stopwords

answered Dec 7, 2012 at 17:54

2 votes

Conditional WHERE clause

answered Jan 26, 2013 at 9:02

2 votes

MS SQL server - linked server target configuration

answered Aug 18, 2021 at 15:58

2 votes

Accepted

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

answered Sep 2, 2021 at 21:32

Stack Exchange Network

50 Answers

SQL Server Transaction Backups vs Logs

Concatenation Physical Operation: Does it guarantee order of execution?

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

Non-yielding IOCP Listener

linked list in SQL and Trees

Are database query optimizers aware of storage performance differences?

Can Availability Groups replace transactional replication?

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

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)

Lock escalation problem on a trigger

Buffer usage for index with no reads

Detecting SQL Server Utilization with a query

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

CPUs Used for a SQL Server Instance

Parameter triggers different execution plan, but why?

In-memory and hard-drive hybrid

Moving one TempdB on 3 instance server

SQL Server fsync Options

maintaining full text index on large table

Linked SQL Server Issue

Should I worry about failed login attempts on SQL Server

Load Testing When SQL Server Caching Is Disabled

Header and line item data source mismatch

dimension table with "like" condition

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

Nonclustered index is faster than clustered index?

SQL Server Full-Text Indexer with stoplists/stopwords

Conditional WHERE clause

MS SQL server - linked server target configuration

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