Viewing 15 posts - 46 through 60 (of 60 total)
someone on dbforums posted a simple script to test the performance of the various data types,
the script seems to be a proof that internally SQL Server...
March 25, 2008 at 9:25 pm
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...
March 25, 2008 at 7:25 am
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...
March 24, 2008 at 3:12 pm
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...
March 17, 2008 at 8:56 am
thanks for your input, what you've done make sense
I also posted on dbforums.com,
feel free to read what people there have said, seems I am getting a wide...
March 17, 2008 at 8:08 am
March 14, 2008 at 2:48 pm
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...
March 14, 2008 at 2:31 pm
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...
March 12, 2008 at 3:09 pm
I wanna here from people on this one... I am new to DW world and this seems like a good scenario.
February 15, 2008 at 9:28 am
April 16, 2007 at 12:28 pm
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...
April 16, 2007 at 11:29 am
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...
July 31, 2006 at 6:56 am
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...
July 31, 2006 at 6:48 am
make sense, great idea as well
thank you very much
March 21, 2006 at 7:51 am
March 20, 2006 at 9:16 am