User StrayCatDBA

2 votes

Variable Value Set in TRY CATCH is Discarded When Trigger is Coded a Certain Way

answered Jul 6 at 17:15

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

0 votes

Restore database and transactions logs

answered Aug 25, 2022 at 17:57

1 vote

MS SQL Server High Data File I/O Latency

answered Aug 25, 2022 at 17:29

0 votes

SQL Server 2017 - Read-Committed Snapshot isolation update deadlocks

answered Aug 25, 2022 at 16:38

4 votes

CPUs Used for a SQL Server Instance

answered Nov 19, 2021 at 18:00

0 votes

Recalculate "Estimated I/O Cost" without exporting and importing database

answered Sep 10, 2021 at 17:53

2 votes

Accepted

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

answered Sep 2, 2021 at 21:32

2 votes

MS SQL server - linked server target configuration

answered Aug 18, 2021 at 15:58

1 vote

Accepted

Azure tempdb filling up while trying to convert a large table to columnstore... how to mitigate?

answered Jul 15, 2020 at 22:25

1 vote

Accepted

Good practices for patching SQL nodes in High Availability solution

answered Jul 15, 2020 at 21:37

0 votes

Accepted

Updating SQL Server 2016SP2 to latest CU in Cluster...what happens?

answered Jul 15, 2020 at 19:32

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

2 votes

Accepted

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

answered Sep 20, 2018 at 19:45

6 votes

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

answered May 22, 2018 at 18:58

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

1 vote

calculate duration between intervals of 15 minute

answered Mar 14, 2018 at 15:33

0 votes

SQL Server on ssd seems slow

answered Mar 6, 2018 at 16:01

1 vote

Accepted

Linked Server - Double Hop - Kerberos - TCP

answered Feb 23, 2018 at 16:31

0 votes

Row estimates always too low

answered Feb 14, 2018 at 20:27

0 votes

Required values for the performance counters

answered Feb 14, 2018 at 16:13

3 votes

Accepted

Linked SQL Server Issue

answered Feb 7, 2018 at 19:14

0 votes

Estimating resource utilization for one database

answered Feb 6, 2018 at 21:59

13 votes

Accepted

Concatenation Physical Operation: Does it guarantee order of execution?

answered Apr 8, 2013 at 16:55

7 votes

Can Availability Groups replace transactional replication?

answered Jun 19, 2013 at 18:58

0 votes

Fulltext search limiting users possibilities

answered Jul 14, 2013 at 2:57

3 votes

Accepted

SQL Server fsync Options

answered Jun 27, 2013 at 11:01

2 votes

Nonclustered index is faster than clustered index?

answered Jun 18, 2013 at 17:31

Stack Exchange Network

50 Answers

Variable Value Set in TRY CATCH is Discarded When Trigger is Coded a Certain Way

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)

Restore database and transactions logs

MS SQL Server High Data File I/O Latency

SQL Server 2017 - Read-Committed Snapshot isolation update deadlocks

CPUs Used for a SQL Server Instance

Recalculate "Estimated I/O Cost" without exporting and importing database

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

MS SQL server - linked server target configuration

Azure tempdb filling up while trying to convert a large table to columnstore... how to mitigate?

Good practices for patching SQL nodes in High Availability solution

Updating SQL Server 2016SP2 to latest CU in Cluster...what happens?

linked list in SQL and Trees

Are database query optimizers aware of storage performance differences?

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

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

Should I worry about failed login attempts on SQL Server

Load Testing When SQL Server Caching Is Disabled

calculate duration between intervals of 15 minute

SQL Server on ssd seems slow

Linked Server - Double Hop - Kerberos - TCP

Row estimates always too low

Required values for the performance counters

Linked SQL Server Issue

Estimating resource utilization for one database

Concatenation Physical Operation: Does it guarantee order of execution?

Can Availability Groups replace transactional replication?

Fulltext search limiting users possibilities

SQL Server fsync Options

Nonclustered index is faster than clustered index?