Basically what's going on here is that someone is looking at some wireframes of the UI and that's getting translated directly into a database design. If they want to...

One thing I'd like to add is that you can use the one "Value" column for all the Latin-based charsets. I'm pretty sure all English, Spanish, French, etc can...

What you guys are talking about is EAV (Entity Attribute Value) patterns. Since you're only dealing with products, you EAV design will be simple and not have a lot...

One more thing you can do for unit tests is create a Database or Sql Server Project in Visual Studio for Database Architects. These projects have built-in tests as...

Just to add my 2 cents. I also have been down this path using loops and what not to audit data into a generic set of tables. However,...

The only thing I might be able to add to it is to see if using the new "APPLY" operator in your join to your Table function will speed things...

So, basically you are talking about an Audit table that just stores the "Audits" in a different Xml format? I've been doing that for a while but never relied...

Somewhat, but not that bad. Even so, because the EAV tables are usually very narrow (meaning, only a few columns), there's usually 1 or 2 indexes that do the...

I do understand that an Index on this theoretical "Bitmask" column would be expensive to maintain, but how is Indexing a Bitmask column any different than say a "LastName" column?...

One thing I'd like to add to what [andarin2] said with options #3 is that there is all this talk of space savings. When you design a table, the...

Hi, can anyone help with these stupid Multi-valued parameters!? Basically, the Report is doing a Search and Replace in my Query Text instead of just passing the parameter in...

This makes sense once you think about it. SSIS is written using the .NET Framework so all "Strings" in any .NET language are treated as Unicode (WSTR). It...

Can you include a brief code snippet, I can't really understand what you're doing to pass the variable.

Good input. You are right, it is 1-to-many, I probably didn't phrase that correctly. I meant it is somewhat of an EAV, but instead of being so arbitrary...

Thanks Scott! I was just passing in the name of my Procs manually, this will help alleviate that!