Sean Gallardy's user avatar
Sean Gallardy's user avatar
Sean Gallardy's user avatar
Sean Gallardy
  • Member for 8 years, 5 months
  • Last seen this week
75 votes
Accepted

Is it still best practice to avoid using the default ports for SQL Server?

31 votes
Accepted

Can SQL Server's crash resilience be improved?

28 votes

How is this SQL Server PK violation possible?

21 votes

The operating system returned error 21 (The device is not ready.)

21 votes
Accepted

Why is SQL Server setup recommending MAXDOP 8 here?

19 votes
Accepted

Non-yielding scheduler error in large memory server if the lock pages in memory option is disabled

19 votes
Accepted

Get Stored Procedure Result Column Types

17 votes

Does SQL Server 2017, including older versions, support 8k disk sector sizes?

16 votes
Accepted

How can I know what hashing algorithm SQL Server used to decrypt the encrypted data when using the function DECRYPTBYPASSPHRASE?

16 votes
Accepted

mssql revert changes made today without backup

15 votes
Accepted

Does changing "sa" password require a SQL restart (in mixed mode)?

15 votes
Accepted

How to "self audit" all of the SQL Server licenses at an organization?

14 votes
Accepted

Can one of Windows failover cluster nodes run on Linux?

13 votes

What is a "Partial Matching Index"?

13 votes

Restore a copy of the encrypted database

13 votes
Accepted

CPU Schedulers Offline

12 votes
Accepted

Should the database service be restarted after performing a restore?

12 votes
Accepted

Cannot Start SQL Server 2017?

12 votes
Accepted

What is a "hashed transaction" in SQL Server Replication terminology?

12 votes

ReadOnly queries on secondary server do not return correct values

11 votes
Accepted

SQL Server: can dynamic data masking be safe when providing a database backup?

11 votes

By Mistake Deleted AlwaysOn Availability Database from live Production Server

11 votes

Does @os_run_priority in sp_add_jobstep actually work in SQL Server 2008 R2?

11 votes
Accepted

patching SQL Server with Availability Group and Secondary Replica

10 votes
Accepted

How do I include nulls during comparisons in SQL Server?

10 votes
Accepted

SQL Server service account Windows privileges and rights

10 votes

What is the significance of the trailing dollar sign `$` on identifiers in SQL Server?

10 votes

SQL Cannot restore database on YOUNGER server version

10 votes

What is hot spotting in the context of adding files to tempdb?

10 votes
Accepted

Long Running Query on Read-Only Replica that takes moments on the Primary

1
2 3 4 5
18