Don't get me wrong, I am very positive about CLR integration, and functions in particular is where I see myself using it the most. In the URL example I would...

Adam, I agree fully that 'true' business logic as you define it has only one place and that is in the database. However, I also believe that the logic should...

Like Kenneth said, most probably there are some design issues here. Personally, I do not allow columns to have NULLs (or use any default value) and I do not design...

Heaps have indexid = 0, text/image data have indexid = 255. So it is included in the where clause. Personally, I would change the where clause to indexid BETWEEN 1...

If the files are not found in the old location (which is stored in the mdf file) you need to specify each file in the CREATE DATABASE ... FOR ATTACH...

If you tell us what you are trying to do with the view we can give you more advice.

Yes, exactly so. This is nothing unusual. The database has the constraints that make sure the business requirements are guaranteed, and any application (or user) accessing the database must understand...

I think the simplest solution is to change the check constraint that I mentioned to say E1 < E2. That way you avoid duplicates and it of course also includes...

As I see it, no, it does not break 1st (or any) normal form. The fact that they contain foreign keys to other tables, or in this case the same...

I do not interpret the question in that way. As I understand it there is a table T1 { e, c0...cn } where e and c0...cn is a number of...

There is no command-line option to run a specific stored procedure. However, you can mark stored procedures in the master database to automatically start whenever SQL Server is started, not...

Hehe, yes, I was almost afraid to post my answer. I felt there must be something I was missing, but finally figured there weren't. Followers