Skip to main content
Share Your Experience: Take the 2024 Developer Survey
AMtwo's user avatar
AMtwo's user avatar
AMtwo's user avatar
AMtwo
  • Member for 9 years, 6 months
  • Last seen more than a week ago
4 votes
Accepted

AG secondary is out of sync for hours after index maintenance

0 votes
Accepted

How to pass variable value to a flag in AZCopy?

7 votes
Accepted

Does adding a column to a table increase the transaction log size (SQL Server)?

3 votes

SQL Modulo Function gives the wrong value?

2 votes
Accepted

Merging data from identical tables from multiple databases into one larger table. N-1 table replication

4 votes

How to failover in a database mirroring session when the safety mode is off and no witness

9 votes
Accepted

Is SQL Server affected by OpenSSL 3.0 Vulnerabilities: CVE 2022-3786 and CVE 2022-3602

7 votes
Accepted

What is a good way to get a time for the data freshness when the source is log shipped to another server?

5 votes
Accepted

Can Redgate SQL Backup Restore SQB to Older SQL Version

5 votes
Accepted

Install SQL Server 2016 SP2 on SP3 - Windows Updates says that?

19 votes
Accepted

What's the use case of disabling an index?

8 votes
Accepted

Which of those parameters is default in DBCC SHRINKFILE command?

7 votes
Accepted

What ports to open for sql server behind secure domain firewall

2 votes

snapshot replication - corrupted BCP files

4 votes

SSMS doesn't rename files automatically when restoring a specific database. Why?

5 votes
Accepted

NUMAnodes and SQL Server performance

3 votes
Accepted

Why is disk queue length an ineffective measure when there is no latency?

2 votes
Accepted

GRANT ADMINISTER Database Bulk Operations - Incorrect syntax near ADMINISTER

7 votes
Accepted

Temporarily turn on Cascade Delete

7 votes
Accepted

How to estimate cpu based on peak rate of query requests?

4 votes
Accepted

How do I generate the private key needed to restore the encrypted backup?

3 votes

Log Shipping is failing with a 'Could not cleanup History'

3 votes
Accepted

Azure SQL - Hyperscale service tier - are table partitions supported

6 votes
Accepted

SQL Main query value used in the WHERE in the subquery

4 votes
Accepted

How to await the execution of the rds_backup_database stored procedure?

2 votes

SQLCMD fails if -c; is specified in parameters on SQL Server 2019

2 votes
Accepted

Return SQL Agent Job status in SSRS when executing job from SSRS

5 votes
Accepted

How to revoke SA permissions that seem to be "stuck" to a login?

10 votes

How to change the web browser used by SSMS when you hit Ctrl+Alt+R

1 vote
Accepted

Allow create table (dynamic name) and insert but nothing else

1
2 3 4 5
10