Viewing 15 posts - 9,436 through 9,450 (of 59,078 total)
Great Article. But Unfortunately I can't find attached file!!! anyone can help?
It's going to be a bit... the new forum software has a problem in it that made all...
April 18, 2019 at 5:29 pm
Heh... and here we are trying to teach someone on an interview to be either a DBA or a Developer how to be ethical. This should be an innate attribute...
April 18, 2019 at 4:09 pm
Heh... I wasn't going to tell the OP about that... I didn't want to make it any easier for him to do it the wrong way. The SSNs have to...
April 18, 2019 at 1:58 pm
Well, crud... I resurrected an old "Passport" disk and found my old animated "Death Star" explosion of rebar but the new forum apparently doesn't support animated GIFs. Had...
April 18, 2019 at 1:52 pm
This guy has asked a half dozen interview questions. I'm not helping him to get a job he's not qualified to do.
April 18, 2019 at 1:47 pm
Are these all interview/homework questions? ethical question, replication, Adjusting T-sql to prevent injection, accidenly dropping production, failover, idol steps to take. Why don't...
April 18, 2019 at 1:44 pm
Another option it to dynamically create the resulting table. Starting from a table with all the items and an empty price column, and loop through all the price lists....
April 18, 2019 at 1:32 pm
Lordy... all these interview questions you're asking. And the word should be "ideal" and not "idol". 😉
The bottom line should be that NO ONE gets any privs to prod without...
April 18, 2019 at 1:23 pm
Again, this sounds like another interview question. Again, I'll only provide hints because if you're applying for a DBA job, it's YOU that has to learn and simple memorization isn't...
April 18, 2019 at 1:20 pm
This sounds like an interview question... especially since you've asked so many similar questions.
I'll give you some hints, though...
BEGIN TRANSACTION
ABSOLUTE HONESTY
April 18, 2019 at 1:16 pm
@s-2.bellini
Yes, I appreciate that a lot of people abuse TempDB and thanks for the feedback there. For these type of articles, though, I can't presume that it's safe to sometimes...
April 18, 2019 at 1:13 pm
If you did a shrink-file, you inverted some index and that's the worst form of fragmentation there is. You MUST do index maintenance to any fragmented index immediately after a...
April 18, 2019 at 5:07 am
First of all, you don't want it to be a VARCHAR(MAX). You can't index LOBs.
Second of all, there aren't many SSNs and it wouldn't take much more than a day...
April 18, 2019 at 4:53 am
Hi Grant, Do I really need to have any kind of certificate to apply for an entry level job? And also I graduated high school and have some college...
April 18, 2019 at 4:44 am
Viewing 15 posts - 9,436 through 9,450 (of 59,078 total)