It varies by company and interviewer. I don't usually ask the same question in 2 different interviews.

I usually ask a couple of questions on indexes, at least one on execution...

Is this for a written interview test, or did someone ask you these?

If you're trying to memorise answers for an interview, don't. A good interviewer can see through that very...

If you open enterprise manager, and look down the bottom of the tree you should see SQLAgent.

Expand that out. The jobs are recorded under there.

Does that help?

Profiler won't show you anything. Profiler captures events sent to the server. When a tran log is restored, the SQL engine works through the tran log and just does the...

No need to start a second thread. People have already posted suggestions to your other one - http://www.sqlservercentral.com/Forums/Topic481421-338-1.aspx

Did you copy the files off a CD/DVD? If so, they'll be marked readonly (file property) and hence the DB will be read only once attached.

Is the folder that the DB files are in either encrypted or compressed?

That will...

The Practical troubleshooting book (edited by Ken Henderson) has a chapter dedicated to memory, including when and why to use the switches and exactly what effect they have. It's a...

If you're using SQL 2000, you can't create a covering index over 150 fields. Index keys are limited to 16 columns.

In 2005 and...

SQL 2005's a lot better at ORs than 2000 was. It now can (and sometimes does) process an or the same way it would process a union.

Try them both, see...

The changes to the allocation pages are logged, otherwise you couldn't...

Are you using SQL 2005 or 2000?

There shouldn't be any difference in performance.

I'm curious. Why do you need to do this?

You can use a startup procedure, or you can create a job that will run when SQL agent starts. Either will...