There are wizards for both of these. If you have having issues, post a question on the specific issue. These are used for very different technologies used for different things.

An int will join quicker just because it's smaller, but in most systems, it is likely a negligible delay. Plenty of people use SSN, email, etc. as PKs and they...

Please don't cross post things. We see all the forums.

Once you have called the stored procedure, the output parameter comes out in @d and you can use that in a...

That looks interesting. Reminds me of ISO9001, which a couple companies I worked for adhered to. While it was annoying on day to day basis, I think it does...

I have heard some people having scale issues with the CLR procedures, and I've tried to ping NASDAQ, but no word yet.

I'd think that would bother NASDAQ, but most of...

Hiding your logic from clients is overrated. If that's all you're selling them with the software, you're not providing much service. Don't forget that you schema, the code oyu use,...

There's no way to do this I'm aware of right now. The iFTS indexing service in 2008 can index an Excel file, but I'm not sure you can consume it...

I think you'd want to set the trace to run at startup and then log to a table in a database that very, very few people (and not the DBAs)...

Fair point on the filing cabinet, but I think computer systems are expected to have better security. Also, the physical nature of notes tends to mean that you can protect...

This is directly reading from the DB. The command is sent to the server and then the server executes this.

You can set this up as a linked server, but you...

I don't know your application, but perhaps something was resubmitted or yo u are missing information and don't know it.

I would check the application and see if there is a...

Logins don't have database roles, only users.

This information is easily stored in security system catalog views.

http://msdn.microsoft.com/en-us/library/ms188786.aspx

http://msdn.microsoft.com/en-us/library/ms190331.aspx

It completely depends. Patterns of access, how much are we talking about (rows and columns), and more.

This isn't necessarily something I'd worry about too early in design. It would help...

Data from one table usually sticks in the same filegroup, not sure about the same file.

Late responding, but SQL Express should work fine.