I suggest you create a parent "supertype" table for your Announcements, Videos, etc tables. Reference that single parent table from your Tag table. You will find examples of such supertype...

The server normally only has access to physical drives and UNC paths. So if you can access your remote drive via a UNC path then yes it ought to be...

No. However, IDENTITY columns are generally used as surrogate keys and if you intend the column to be...

Have you asked your SAN vendor about their recommendations for SQL Server?

A view is a derived table defined in declarative code. Think of it as being a variable with a name and a value (the value is the data).

A stored procedure...

I like Apex SQL Code for SQL code generation. Codesmith is also very popular.

http://www.apexsql.com/sql_tools_code.asp

http://www.codesmithtools.com

Dave Schutz (3/26/2010)

---

I have 2 tables and first table is updated daily from our accounting app. Second table uses info from first table and needs to have that info updated...

I recommend you stay away from Kimball at least until you are confident of enough knowledge and experience to evaluate what he says properly. Personally, I think that most of...

David Lean (3/23/2010)

---

Too often lazy or inexperienced DB designers automatically create an Identity Column for PK of every table they create. And they fail to ensure the uniqueness of the...

"Associative Entity" is semantic modelling terminology and not a relational database term. I've...

Tom.Thomson (3/7/2010)

---

If something is unknown, it is unknown - end of story. Business stakeholders are generally well aware that there will be things that they don't know and don't want...

I don't think David was suggesting denormalization. He was describing the benefits of...

Am I right in understanding that you want to allow a key value to appear in one of two tables, but not in both? This is sometimes called a "distributed...

CREATE TABLE tbl (km INT NOT NULL, distance INT NOT NULL, price INT NOT NULL, PRIMARY KEY (km,distance));

A unique (and non-nullable) index is just SQL Server's method of implementing a candidate key. By creating a unique index you in effect create a key constraint as well. However,...