Hope you guys don't mind me chiming in... We're working on a new system now, and my goal is to have a globally unique ID (whether INT or UNIQUEIDENTIFIER) for...

sql_lock (10/18/2010)

---

there is a simlar discussion going on...

http://www.sqlservercentral.com/Forums/Topic1002532-263-1.aspx%5B/quote%5D

Thanks, I didn't see that before posting, but I'm reading through it now.

Lowell (10/18/2010)

---

no need to re-invent the wheel;

starting with SQL 2005, a new function NEWSEQUENTIALID() will return a GUID, but the values are more indexable, as they return items that...

Grant Fritchey (10/6/2010)

---

Yes, the interim table approach will allow for data integrity. But I wouldn't try to do the universal interim table. Despite the fact that it adds to the...

Grant Fritchey (10/6/2010)

---

The way to go with something like Address is to create the one address table and then multiple mapping tables. That way, if you have two different objects,...

Hey Guys --

Thanks for the great advice, but the problem we're running into is we don't know if a client will want cash flows and other tables that roll up...

As a student I downloaded SQL Server 2008 Developer (not R2) from the Microsoft Dreamspark website - https://www.dreamspark.com - but you must be a validated student for it...

I just found this on Microsoft's site - http://msdn.microsoft.com/en-us/library/bb500440.aspx - which I didn't see when searching before posting my question. So with this does anyone know of...

I'm unfamiliar with multi-master referential integrity and can't find much about it...

Feature Packs are added functionality that may have been an afterthought or just not in high enough demand to add to SQL Server outta the box or to a Service...

malavika.ramanathan (7/16/2010)

---

HI All,

I have begun with basic data warehousing concepts now. I need to learn SSAS. Could anyone tell me how to start with it?

I dont know anything abt...

da-zero (7/16/2010)

---

That is the solution mostly used in SQL 2005 to execute SSIS-packages in 32-bit mode.

However, in SQL 2008, you can just select an option in the SSIS-job stept that...

Michael.. I found a 'solution' that's working, but it may be worth setting-up a processing server just for such jobs since the solution isn't ideal.

My work around was to use...

I just ran across one of Ralph Kimball's articles addressing this exact problem:

http://intelligent-enterprise.informationweek.com/020221/504warehouse1_1.jhtml

In my modeling I'll follow his suggestion, which several replies to my OP also recommended, and...

Thanks for the great suggestions. Using the scenario of keeping the currencies in their native format with a Currency Dim table with daily conversion rates (which we already have in...