Viewing 15 posts - 1 through 15 (of 312 total)
Just enabled the Query store this morning.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 14, 2025 at 3:07 pm
It is already set to 150.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
April 14, 2025 at 2:52 pm
I ended up following instructions on this video which solved the issue
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 15, 2025 at 5:26 pm
All, sorry for not replying to the thread. The secondary server has been offline since Saturday. I have a maintenance window tomorrow so the plan is to reseed via AG...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 26, 2024 at 4:23 pm
Also is this server running SQL and SSIS? If SQL is also running on it I'd look at the memory allocation for SQL and make sure you're leaving 6-8GB...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 10, 2024 at 9:14 pm
ALTER DATABASE MyDB SET OFFLINE WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE MyDB FROM DISK = 'D:\Backup\MyDB.bak' WITH REPLACE, STATS = 10;
Restore command
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 30, 2024 at 1:00 am
Even though the database is in simple recovery mode, I see "offline rollforward begins" in extended events when I restore a database.
Date transfer is complete
backup set is restored
offline rollforward begins
Processing...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 29, 2024 at 7:37 pm
WITH STATUS AS
(
SELECT BUSINESS_UNIT, PROJECT_ID, effdt, Project_Status, ROW_NUMBER() OVER (Partition BY Project_ID Order by effdt desc, effseq desc) as RN from PS.Project_Status
)
Select Distinct
prj.Business_Unitas ProjectBusinessUnit
,B.descras ProjectBusinessUnitName
,CAST (NULL as...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 8, 2024 at 4:00 pm
Thanks frederico_fonseca
This is the url
https://www.brentozar.com/pastetheplan/?id=S1e6Wn7MR
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 4, 2024 at 1:04 pm
I will just provide some details.
As of last week, almost everyone had access to run select against some restricted views
Then I generated the list of users who had read only...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 26, 2024 at 3:24 pm
Any feedback?? Anyone??
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 25, 2024 at 6:31 pm
I did suggest creating a new table, dumping only Feb 2024 data, renaming the new one and old one. No response yet from the user.
Also, this table has 4 indexes.
1...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 29, 2024 at 2:23 pm
I changed the Legacy cardinality Estimation setting to ON and now both queries are taking the same time.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 26, 2023 at 1:37 pm
Hey experts, I am really hoping to get any feedback. Just trying to understand why this behavior...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 6, 2023 at 7:11 pm
I came across an article where I had to add 1 in the end like reports1, restart the services and viola it worked. Changing it back to reports worked as...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 22, 2023 at 1:24 pm
Viewing 15 posts - 1 through 15 (of 312 total)