Viewing 15 posts - 61 through 75 (of 58,873 total)
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
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
Viewing 15 posts - 61 through 75 (of 58,873 total)