FYI

someone on dbforums posted a simple script to test the performance of the various data types,

http://www.dbforums.com/showthread.php?t=1628644

the script seems to be a proof that internally SQL Server...

In this thread people seem to agree that it is more appropriate to have the foreign key on both the PK and TranTypeID... however I ran into a little design...

The Details column name is just for the sample. This little schema up there was just put together for showing an example. The details column can be ignored in my...

although I got 10x more answers on dbforums.com then here your posts seem to be the most straightforward 🙂

Basically my main intention was to categorize my database objects, a bit...

thanks for your input, what you've done make sense

I also posted on dbforums.com,

http://www.dbforums.com/showthread.php?t=1628324&page=1

feel free to read what people there have said, seems I am getting a wide...

Thanks!

thanks for the reply,

so let's say I go with scenario #3...

Knowing that in one of the two tables TranTypeID will always be the same. (In the table containing...

lol, as I see I am not the only one angry at the official answer....

the following 2 statements both return 27 years old...

select DATEDIFF(yy, '1/1/1980', GETDATE()) - CASE WHEN...

bump!

I wanna here from people on this one... I am new to DW world and this seems like a good scenario.

thanks

thanks for the comments, but when you say Mirroring gives you redundancy and clustering availability... I guess Mirroring gives you availability as well since your database are redundant. Can you...

I rewrote the query in a way that is not crashing... look at this strange thing... The first statement is returning the below error message while the second statement runs...

I am getting the exact same problem right now... My link servers are working for the most part, the only problem i have is when using the IN operator as...

make sense, great idea as well

thank you very much

thanks!