Viewing 15 posts - 226 through 240 (of 59,039 total)
Several years after that my old boss related to me that the bug fixes had never been released, and the whole system had been retired and replaced.
Ya just gotta...
December 1, 2024 at 10:48 pm
I believe the more common, and better, naming for tables is plural. I can't think of a major relational dbms that uses singular system table names.
For example: sys.objects (SQL...
November 30, 2024 at 5:32 pm
Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, I...
November 27, 2024 at 4:08 am
Wow. Just ... WOW. Watched the 1.2. Now going to watch 3.
Thanks, Jeff.
That's the same reaction I had when the size charts gave me a hint about what was...
November 27, 2024 at 12:28 am
Bumping my own post because of the 2nd page issue on this forum.
November 26, 2024 at 11:59 pm
Oh, and can I get a favor? Can everyone to update their posts with the proper spelling of my name? Brandie.
Sorry and done.
November 26, 2024 at 11:58 pm
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
Viewing 15 posts - 226 through 240 (of 59,039 total)