You haven't really given enough information. What's the server for? How is it used? Load?

Or are you saying how to get SQL Server onto a server? It's a simple install.

Try the default trace, but I'm not sure if will be there.

No, it shouldn't delete this stuff. The reason is that you might drop a database (there is no DELETE) because of an issue and then restore it. The information in...

If you want to learn about ROW_NUMBER(), read the documentation in BOL. No sens in having someone explain it to you if you haven't tried.

ROW_NUMBER works for a result set....

Keep it simple.

Gather the spreadsheets up, build a database with the names of products and subproducts (2 tables). Ask someone to count the number of products and subproduct.

Time them. My...

By default the express edition of SQL Server, you have a named instance. I believe it's SQLEXPRESS, which means the name is [machine name]\SQLEXPRESS and you will need to use...

I'm not big on Wikis either, and I'm concerned about ending up settling battles between people that argue back and forth on a topic.

Wiki sounds good until people start to...

xp_cmdshell or an Agent Job.

T-SQL works within the server. It cannot see anything outside of the SQL service without a shell like xp_cmdshell.

You would use the same commands that you...

There may be some resources for free, but almost all exam related books cost money. Authors work hard to build these books and you ought to pay them for their...

Well it's 9:56pm, Wed night, and I'm finally getting to this, after a busy day. I did get time off to run, run the kids around, karate, so it hasn't...

My pleasure. I don't like to give the whole answer until you've had a chance to try it, but if you get stuck, post what you've got and we'll help...

No, no issue in general, but if you have code in your trigger that is v7 specific, it might be an issue.

Moved to SQL 2000. Please post in the appropriate...

I had to read it 3 or 4 times to make sure I wasn't missing something. Is the logic for estimation really that hard?

Calculate the 2nd Friday in T-SQL. It's not a hard algorithm, but you need to work through the possible range of days and check the date.

So if you can do...

it's a time and bandwidth issue.

If it takes 10 hours to copy, the secondary is then "backup time" + 10 hours + restore time = time behind primary when you...