Oh and I'd set the databases in simple mode. Not sure you want to deal with up to the minute recovery for users.

If you do, then you need to manage...

Backups, maybe have them set a preference (folder) and run a backup to there? depending on how knowledgeable your users are, either let them pick a name, run it as...

create a function, query sys.objects using your criteria.

First I'd suggest you get Management Studio so you can more easily view things.

second, did you create another login or a user? A login has access to connect to the...

My guess is that they'll leave the open source product as it is, letting it evolve over time. I think that this will put more pressure on Oracle, IBM, and...

Again, that doesn't help. It depends on what your data is.

If you are storing phone numbers, you don't need a varchar(50). You can reduce that to 10 char in the...

This sounds like a homework assignment. Please make your own attempt at this and show some effort.

This is a holdover from pre v7. Not sure that you need this information anymore.

This isn't something easily answered. It depends on your data.

Pick something that you think fits your data, with some pad for character values. Dates are dates, numbers are integers or...

As Jeff mentioned, we're more than happy to help. However take the time to describe what you want, include relevant code, but we're not going to dig through your code....

There's a place to change the default file locations in the server properties, Database Settings.

I'd do the detach, attach listed above.

You need to learn the concepts in the exam guides and then practice things in SSMS (adding users, other objects, editing them, making backups, etc.). those skills are needed on...

Congrats and likely you'll learn about a lot of things besides databases and SQL. That can only be good and help you in other positions.

The advice above is great and...

This absolutely should be tested, but if the drive letters are the same, you should be ok. SQL stores these in the master database, as seen by the OS.

To be...

Almost certainly this will be left in memory if it's queried with any frequency, no need to pin it.