StrayCatDBA's user avatar
StrayCatDBA's user avatar
StrayCatDBA's user avatar
StrayCatDBA
  • Member for 10 years, 10 months
  • Last seen this week
  • Lowell, AR, United States
2 votes
Accepted

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

2 votes

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

1 vote

MS SQL Server High Data File I/O Latency

1 vote
Accepted

Good practices for patching SQL nodes in High Availability solution

1 vote
Accepted

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

1 vote

Proper Index for WHERE X <> 1 AND Y <> 1 ORDER BY Z

1 vote

Recover data from accidental update

1 vote

calculate duration between intervals of 15 minute

1 vote
Accepted

Linked Server - Double Hop - Kerberos - TCP

0 votes

SQL Server on ssd seems slow

0 votes

Required values for the performance counters

0 votes

Row estimates always too low

0 votes

Fulltext search limiting users possibilities

0 votes

Estimating resource utilization for one database

0 votes

What is the best permissions to set for only creating and managing own databases?

0 votes
Accepted

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

0 votes

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

0 votes

SQL Server 2017 - Read-Committed Snapshot isolation update deadlocks

0 votes

Restore database and transactions logs

-1 votes

Execution plan flips Filter and Execute Scalar when using the PK, causes cast to fail

1
2