If you want a couple of examples to wrap your head around:

1) Entities: subscriber, magazine. join table: subscriber to magazine.

2) Entities: programmers, programming languages. join table: programmer to programming...

sysadmin role members map into every database as dbo, including master. The dbo user never has permissions checked. Therefore, a member of the sysadmin role has access to all objects.

I don't think the system tables are going to help you here if the foreign key constraints were never specified. You could try and do a column_name to column_name comparison...

Gimli, you are correct. However, look at how cost is initially assigned and how that affects how long they remain in cache. That's why stored procedures are typically better.

Also, the...

Typically, if you can afford it, RAID 0+1 (hardware solution) is the way to go. Database, logs, and temp db all on 3 different physical sets of drives. If possible,...

Open your services console for the database server. You can also get to through Computer Management. Is the Microsoft Search service running? Also, are there any related events in the...

Many-to-many relationships are modeled with what is typically called a join table or a junction table (but that's just two of many names used). You'll find more about how relationships...

This is going to depend on the relationship between the two "entities" you're modeling. For instance:

If I have cars and tires as my entities, I'll have a one-to-many relationship...

Only by doing a dynamic SQL query using EXEC or EXEC sp_executesql. But then the query runs in another batch process, meaning it's the same as if you had issued...

Yes. The physical files can be named anything so long as they are compliant with the requirements Windows has for file names. DBCC finds the information in sysdatabases in the...

Insight Manager can do cluster monitoring. It's not specific to SQL Server. It'll report on any resource failing... meaning if you have clustered file servers, etc., it's great there, too....

If you don't go the trigger route, you can run traces, though you'll have to trace all statements and then parse out the deletes. Generally, though, if you need to...

I believe when you designate it as the SQL Server service account, it is automatically added as a login, provided you do so through Enterprise Manger. The SQL Server service...

What happens if you just write a dummy ASP page using a different tool, even Notepad, just to confirm you're getting data back? Say open the recordset by calling the...

You didn't indicate which hardware vendor you're using. If you're using HP equipment, you can install and use System Insight Manager (you'll need a separate server for monitoring). SIM is...