Viewing 15 posts - 1 through 15 (of 2,338 total)
Stop rebuilding indexes.
Microsoft's documentation states:
Index maintenance decisions should be made after considering multiple factors in the specific context of each workload, including the resource cost of maintenance. They should not...
November 21, 2024 at 5:15 pm
He he, 2022-07-03 13:41:52.0070000 is now unequal to 2022-07-03 13:41:52.007 depending on the data type 😉 😎
Show your code, ol' friend, so that people don't just look at...
November 12, 2024 at 5:12 pm
Visited some friends there a few months back, stayed within walking distance, ate there three times in two days.
Not Burgatory! Ed and Jeff will murder me!
The last time...
September 17, 2024 at 10:13 am
Your google search will return the same results as mine. You will find blogs and articles about this that conflict. Brent Ozar and Paul Randal have written a lot of...
August 21, 2024 at 5:20 pm
What is there to be confused about?
You have two servers, and two accounts. One is a sysadmin on one server, the other is not.
Sysadmin is the highest level of permissions...
August 20, 2024 at 7:57 pm
I am really curious what the use case is for being able to store values this large???
August 20, 2024 at 7:50 pm
I have always used the "Buffer Manager(*)\Cache Hit Ratio" counter to monitor the cache hit ratio in the past. This metric is currently at 100%.
What actions have you taken...
August 20, 2024 at 7:43 pm
Unless you re-start, it's not going to clear the old files up.
And honestly, I'm not sure I have ever set this. I have sp_cycle_Errorlog set up in a SQL job.
June 13, 2024 at 5:45 pm
Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.
I don't know what I can say or do and I'm fairly...
May 12, 2024 at 6:00 pm
Hey All,
Steve's on the road in Australia, so I'll let him respond here when he gets around to it. I just wanted to let you know why you might...
May 10, 2024 at 1:03 am
Dear Steve Jones...
I forget how long it's been since this site was moved to WordPress but it's been a long time. Those of us long-timers that are left (not...
May 8, 2024 at 8:14 pm
Unfortunately some of the images in question are not our images - for example the little arrows that show that you can sort a column aren't rendering. Those are...
May 3, 2024 at 1:41 pm
This was removed by the editor as SPAM
May 3, 2024 at 12:04 am
Store the images in a different location. Don't embed them into the report.
Create an images folder on the SSRS box, and point the report to the image there.
May 2, 2024 at 8:06 pm
We just upgraded to SQL 2022 and are experiencing the same thing.
To provide some context the reason we use a "Primary Checker" script like the original author is to...
May 2, 2024 at 7:49 pm
Viewing 15 posts - 1 through 15 (of 2,338 total)