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
27 votes
Accepted

Azure Data Studio - Intellisense does not detect tables, yet queries work. How do I fix this?

19 votes
Accepted

What's the use case of disabling an index?

19 votes
Accepted

Nonclustered index storage on clustered columnstore

19 votes
Accepted

Reconnect "not connected" query windows in SSMS to original connection

17 votes
Accepted

Why the instance name of SQL Server Express is changing?

16 votes

MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can't Bring It Online

16 votes
Accepted

Why is part of transaction committed when stored procedure faults?

16 votes
Accepted

Does it ever make sense to have a clustered and non clustered index for the same column

14 votes
Accepted

Why do I have to backup a transaction log twice for it to shrink?

14 votes

Job waiting on CXCONSUMER

14 votes
Accepted

Commit or rollback SQLServer-SQLTransaction when no data changed

13 votes
Accepted

What is the row overhead when using Page Compression?

12 votes

How do I preserve leading zeros for varchar field

11 votes
Accepted

What are the .BCP files inside a .bacpak file?

11 votes

Getting the first Monday after the third Friday

11 votes
Accepted

SQL Server service - Not Starting With Automatic Startup, "The system cannot find the file specified", but starts fine manually

11 votes

CASE statement issue

11 votes
Accepted

Is it possible to re-use a query plan from the plan cache from one database in another database?

11 votes

SQL database stuck in recovery

11 votes
Accepted

Preventing SQL injection in dynamic SQL

11 votes
Accepted

Using DateTime Variable In Where Clause

10 votes
Accepted

Prevent Modification of dbo objects while allowing other schemas to be modified

10 votes

How to add 1100 columns in SQL Server

10 votes

Is it possible to do a partial transaction log backup with SQL Server 2017? I don't have enough disk space to do a full backup

10 votes
Accepted

Add default rows to the query result if restrictions are not met

10 votes

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

10 votes

Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?

9 votes
Accepted

Restoring only differences with SQL differential backups?

9 votes
Accepted

Does SQL Server ignore STATISTICS for varchar columns as this article suggests?

9 votes
Accepted

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

1
2 3 4 5
10