Stack Exchange Archives - Andy M Mallon

How to see restore history of a deleted database?

November 11, 2024 Andy 0

Question For example, I had a database and I want to see which physical backup file was used to restore into it. The problem is that the database was deleted. How can I see the record? asked 2019-11-23 by sql-noob Answer Depending on how the … [Read More]

Migrating my Stack Overflow answers to blog posts (Sorry for the spam)

November 11, 2024 Andy 0

For a while, I have been thinking about using my Stack Overflow answers (and answers on other sites on the Stack Exchange Network), and storing a copy of them here, on my blog as well. All posts on the Stack Exchange network are covered under … [Read More]

PowerShell can’t see network locations after SQLPS module is loaded

August 15, 2024 Andy 0

vstrien is using the (legacy) SQLPS Powershell module, and running into a bug where importing the module changes your current directory.

Enforce a specific constraint to be checked first?

October 6, 2023 Andy 0

Question I have the following SQL Server table : For the two constraints I listed the more important constraint first hoping that if both constraints are violated, the first one would be triggered and displayed to the user. However, it appears the constraints are declared … [Read More]

AG secondary is out of sync for hours after index maintenance

February 21, 2023 Andy 0

Question We have a 3TB OLTP database running Siemens Opcenter MES software at one of our manufacturing plants in China. This is setup in an Always-On Availability group with one secondary node. As this is a manufacturing plant, we are only provided 11 1/2 hours … [Read More]

What’s the use case of disabling an index?

September 25, 2022 Andy 0

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]

GRANT ADMINISTER Database Bulk Operations – Incorrect syntax near ADMINISTER

May 23, 2022 Andy 0

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]

How to await the execution of the rds_backup_database stored procedure?

March 3, 2022 Andy 0

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]

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

February 15, 2022 Andy 0

Question When I am running: Ctrl+Alt+R will run the web browser in an SSMS tab. However, this now produces the message: I do have MS Edge installed but SSMS is not finding it. What should I do to help SSMS find MS Edge and use … [Read More]

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

February 10, 2022 Andy 0

Question I have a SQL query that looks for values in a table on a range of dates. If no record is found, I would like to generate rows with default values. Example of one of the table existing records: DeviceId Time Context Value 1 … [Read More]