Viewing 15 posts - 241 through 255 (of 59,048 total)
It's free. Like it says in the presentation, send me an email to the email address I provided and I'll send you the zip file that I give folks when...
November 26, 2024 at 11:53 pm
Heh... "It's Shake'n'Bake and I helped"! 😀
November 26, 2024 at 11:49 pm
Hi Dig , You should disable all your MaintenancePlan related jobs in "sql server agent" .
Welcome but, if you're going to say something like that, you should explain why...
November 25, 2024 at 6:09 am
Happy Thanks Giving to you as well, Rick and to all the denizens of SSC.
November 25, 2024 at 6:00 am
Heh,... thanks for the feedback, Steve. It was a story that explained that if you "know the gazintas, anything is possible"... even in SQL. And, it was actually really simple...
November 25, 2024 at 3:02 am
I disagree with "stop rebuilding indexes." The quote you provided doesn't seem to support that statement if I take it as is, no caveats.
Regardless, we already have regular checkups...
November 24, 2024 at 8:51 pm
For Minimal Logging on a Table with a Clustered Index. Note that at least one of these is missing from the documentation but absolutely required to make Minimal Logging work.
November 24, 2024 at 8:25 pm
I would like to have a 4 day Thanksgiving weekend where no one needed help doing something.
November 24, 2024 at 7:49 pm
If the symbol and trade_date form a unique pair in the entire table, make that combination the Clustered Primary Key. Leave this clustered index on the table at all times......
November 23, 2024 at 2:54 pm
GENERATE_SERIES() has a "little" problem for me. I generate shedloads of test data and the following problem means that I'll not be giving up the fnTally function any time soon...
November 22, 2024 at 2:44 am
Crud. I just did a code review where this happened and forgot about it when I answered here. 🙁
And great question, BTW!
November 22, 2024 at 2:26 am
I don't know how many people need the precision Jeff sees issues with.
People seem to be missing the point here. The simple fact is that it...
November 22, 2024 at 2:21 am
Wondering if anyone has time to point me to resources regarding this particular question: Microsoft Recommendations for Update Stats? – SQLServerCentral Forums?
I posted a take at the following...
November 22, 2024 at 2:18 am
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...
November 21, 2024 at 8:22 pm
Thank you Jeff - I'd never tried that in all my years since SQL Server V7.0
You bet. I hope that's one thing that they'll never change.
November 21, 2024 at 2:54 pm
Viewing 15 posts - 241 through 255 (of 59,048 total)