Viewing 15 posts - 5,071 through 5,085 (of 59,068 total)
If you want to have some fun with a Performance Tuning "Expert", provide them with the following questions... (there's more... these are a bit more advanced that "What's a Clustered...
June 18, 2021 at 5:01 pm
Developers routinely look to the DBA for advice about data modeling (often times after it's been deployed to production), but I don't get questions on the job...
June 18, 2021 at 4:51 pm
Jeff, before I even clicked on the comments, I knew you'd be here with GETDATE(). 🙂
Heh.. I certainly have cut the rug for that one. 😀
The way I...
June 18, 2021 at 3:48 pm
Ask someone if they know why an RDBMS is called relational.
The majority of candidates will give the wrong answer. This doesn't mean they should be rejected - they just...
June 18, 2021 at 3:41 pm
If I was looking for a lead DBA beyond the technical experience I would be looking for someone who
June 18, 2021 at 3:38 pm
...
It reminds me of when I was interviewing someone who had a Phd in Mathematics (and I DID verify that). You might think that someone applying for the...
June 18, 2021 at 3:33 pm
K. Thanks for the feedback. Me neither, for the record.
June 18, 2021 at 5:53 am
Heh... I'll give you another one... I interviewed a guy that claimed to be an expert at tuning SQL and T-SQL. I asked him what a clustered index was and...
June 18, 2021 at 5:48 am
Heh... so a DBA doesn't need to know what a Clustered Index is???
Sorry... Unless you're trying to hire a TRUE SYSTEM ONLY DBA, I find that laughable and even a...
June 18, 2021 at 5:31 am
Why? If what you're saying is true, then just use the first char in the value as the category, that's less overhead than any kind of table lookup.
Because...
June 18, 2021 at 12:10 am
Here are a couple more that won't have a corresponding END.
- BEGIN CONVERSATION TIMER;
- BEGIN DIALOG CONVERSATION;
- BEGIN DISTRIBUTED TRANSACTION;
Just curious... have you actually ever used any of those?
June 17, 2021 at 11:13 pm
I have used that before.. but was looking for something that would dump tables in order with foreign key reference in mind, so I could pickup this file and...
June 17, 2021 at 9:33 pm
If this is to be done on a Prod box, I wouldn't. If this is to be done on a Dev box, my question would be, why don't they already...
June 17, 2021 at 9:18 pm
If you're using PIVOT, you should have posted the code anyway... there is a method that usually better than PIVOT.
June 17, 2021 at 9:10 pm
You claim to have 3rd party software that demonstrates that. Why do we need to provide an example? I've never seen such a thing but could be wrong. Post the...
June 17, 2021 at 8:18 pm
Viewing 15 posts - 5,071 through 5,085 (of 59,068 total)