Question I just learned that indexes can be disabled on a table. Even the clustered index can be disabled. After that, users can’t access the index or the data if clustered index. When will we disable an index? I just don’t understand the use case. … [Read More]
Question We are trying to solve connectivity issues for one of the app trying to pull data from very secured sql server behind firewall. I am not that expertise in security but need help on how to proceed in opening ports for that app to … [Read More]
Question Each night my SQLServer replication failed on a big table with the following error. It is failing on a different table each night but always on a relatively big table ( > 200,000 rows) The process could not bulk copy into table ‘"dbo"."Table01"’. (Source: … [Read More]
I’ve seen more and more events & communities adopt Codes of Conduct. Even local events, local user groups, and smaller online communities are adopting Codes of Conduct. That’s GREAT! …but it’s just a great start. It’s not that easy. Discoverability The issue of discoverability is … [Read More]
Question I am trying to import a bacpac file to my SQL Server Express 2016. An exception is thrown during the import with Returns: Incorrect syntax near ‘ADMINISTER’. I am running the import as the sa user. Later when I try to run the SQL … [Read More]
Question I’m simulating the situation where I take a backup from instance A and restore it on instance B. I followed the doc to Backup to Disk with Encryption. Since I’m using only my desktop to simulate the whole process, after taking the backup of … [Read More]
Question This has probably been asked before, but I couldn’t find the answer. I have a complex datamodel in sql-server-20XX (more likely to be something old) in which cascade delete has been turned off (by design). A large chunk of our database has been sold … [Read More]
Question I’m really confused by this SQL here, I have this sample where I am using the value from the main query in the subquery and then using XML PATH to add a comma between the dates. The setup is 2 tables one with the … [Read More]
I recently saw a question on DBA Stack Exchange (it has since been deleted by the author), who had a “special process” that ran regularly, and as part of that process, they disabled the trigger, did some stuff, and re-enabled it. During that process, the … [Read More]
Question Our team is migrating one of our databases to Amazon RDS MS SQL Server. As part of that, we have to rewrite some of our stored procedures. We have a stored procedure that performs a database backup to a network storage. The above stored … [Read More]
Copyright © 2026 | Andy Mallon | am2.co