About a year ago we hired a DBA with over 10 years of experience. About total of 10 people inteviewed him - all of them he passed (and the questions...

When you drop the job you use procedure sp_delete_job.

So you might need to query some of the DMVs when and by whom that proc was used the last time.

You can start from here:

http://www.sqlservercentral.com/articles/Product+Reviews/litespeedforsqlserver/1862/

Do you think you can use compression software like LiteSpeed or RedGate

At my current job, I asked my boss-to-be about my hours before getting hired. So he said about 45 hrs/wk. 2 years later I ended up working at least 55-60hr/wk....

about 5 years ago, few jobs before, one of our DBs was about 1.5 TB: So our wknd maint included the floowing: we stop Logshipping, before reindexing ( every Saturday...

That is interesting but I’ve never been asked on a interview a business related questions, especially when was moving from insurance company to a financial services company. In most of...

When we were looking for the DBA in the HedgeFund, most important was a proven previous experience in Financial sector. Among the questions we asked were the following: what is...

If you will be able to convince your management to send you MS SQL Server DBA training course, it will give you a good initial push. I think 1 week...

you cannot run reindex on a DB with TB of data in a Full recovery mode. It will blow up your Tran Log dramatically. One weekend one of my coworkers...

And you can also created a job with notification which will run every time SQL Server Agent starts...

You can query registry to get that info

I am sure you find a better job, but I usually put all my qualifications on the resume, so in your case you would skip Replication\LogShipping, etc. And if asked...

I work in the financial industry and while all of the above technical questions are important, I am trying to spend not more then 20 mins on them. What more...

It is based on my personal experience. I used similar procedure for some time. Once of the tables starting getting more and more text data, report start providing more and...