Viewing 15 posts - 1 through 15 (of 110 total)
Steve, how does setting the parameter to NONE meet the requirement that "we want Query Store to continue to monitor these queries?" The AUTO setting filters out small adhoc queries...
February 21, 2023 at 7:11 pm
From the reference page, if a database is damaged, try to take a tail-log backup by using the WITH CONTINUE_AFTER_ERROR option of the BACKUP statement. Also on that page, Important:...
February 10, 2023 at 7:29 pm
Ant-Green, some good points.
Prasad, what is the point of the last step? If I raise an error in the first step and exist or raise an error and jump to...
February 9, 2023 at 6:55 pm
I just wonder what the logic was the convinced the SQL Server development team that you should allow creating synonyms on non-existent objects.
January 19, 2023 at 5:38 pm
If user databases were created don't those databases still have the collation that is effect when they were created? I have changed the collation at the database level but then...
January 12, 2023 at 7:05 pm
I do not see anything scary about NULLs as UNKNOWN is a perfectly good answer.
November 28, 2022 at 4:12 pm
Being that MS says, "Opting out of SQL Server usage and diagnostic data collection is supported, but the service can't be removed or disabled" per https://learn.microsoft.com/en-us/sql/sql-server/usage-and-diagnostic-data-in-local-audit?view=sql-server-2017#turning-local-audit-on-or-off
You can opt...
October 14, 2022 at 5:52 pm
I do not really like this question or answer very much. The question is pretty vague. When the blob is under 1M storage in the database is usually faster but...
July 1, 2022 at 5:13 pm
Rune, I agree with you. I looked up the command and this would see the way to go.
ALTER DATABASE ENCRYPTION KEY REGENERATE WITH ALGORITHM = { AES_128 | AES_192 |...
June 3, 2022 at 7:23 pm
Steve, per the reference "Returns the Showplan in XML format for the batch specified by the plan handle. The plan specified by the plan handle can either be cached or...
March 9, 2022 at 8:32 pm
It is unfortunate that the problem text in the email for which the final answer is correct and the text of the problem on the answer page, and for which...
October 15, 2021 at 7:23 pm
sagar, for those of us who make minimal use of SSIS and house SSIS packages in MSDB or in an SSIS catalog then how do we find the value for...
September 27, 2021 at 3:15 pm
Good point Larry. If I add an ELSE to Larry's query and try to define @NumOfHolidys with a different data type I get an error that the variable name has...
August 13, 2021 at 3:25 pm
I always use fixed size file growth for database and log files. This is a nightly restore over an existing database so some of your suggestions will not apply, but...
September 18, 2020 at 1:16 am
Alejandro, thank you for the reply. The database is in SIMPLE recovery mode with the backup coming from another server where the database is also in SIMPLE recovery mode. But...
July 24, 2020 at 6:29 pm
Viewing 15 posts - 1 through 15 (of 110 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy