The problem with anything but a fairly superficial description is, that in my experience, it's highly unlikely that the interviewer actually knows anything about normalization.

Yes,
       if sa is disabled, sa owned jobs will run and sa owned databases will be accessible.  SA is disabled on all our boxes at setup and we have...

Thanks folks, your help is greatly appreciated

Hi,
    try running the script on here to provide Gail with the information requested.  Run it during your slowest period, if you have one.  Also, read through the...

If you do it without using the WITH COPY ONLY option, it's going to break the restore chain.

"These people will need to be data experts with experience in security and a lot of knowledge about the protection of data"
This is a nice idea, and one which...

Hi,
    as Jason's suggesting it's probably because it's a small table/index.  Initially SQL Server allocates storage in what are called mixed extents - i.e. the extent is shared with...

Also, with a tempdb anywhere near that size, I would make sure that Instant File Initialisation is set on.  If not, you're going to be twiddling your thumbs for some...

While there are, as stated, obvious risks to updating certain types of data via reports, I think it's highly unlikely that this ability would be removed.  That would then mean...

Whenever it gets to the stage where it is, I'm off.  Life's too short to spend a third or more of it stewing doing makework jobs IMO.  80%+ of the...