Hi there,
            in terms of performance, one thing you'll need - in order to prevent issues with other processes, even when they will not be touching the records in...

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...