Viewing 15 posts - 121 through 135 (of 158 total)
When you need to display different descriptions for Products based on culture, you're doing an EAV even though you've defined the columns very specifically to Products, and in...
May 20, 2008 at 1:14 pm
I get these files which are basically text streams and they are only delimited by record.
I've written a utlity to handle it now (it's slow and difficult to...
May 20, 2008 at 10:10 am
1) Do I need to use the intermediate table or is there a way to do this going straight from the parameter string to the final table (while still being...
May 7, 2008 at 9:02 am
For the use of a tally table or other mechanism, populating a variable with sample data like the above is completely wrong! Those delimited values would never be passed...
May 7, 2008 at 8:52 am
Don't ask users what they want, figure out what they're trying to do and then tell them what they want.
I couldn't agree more. To quote (or paraphrase) Henry Ford:...
April 16, 2008 at 8:58 am
The "Ragged Right" Files I have to deal with are Mixed Row Type files as well. Because of that, I cannot use column names from the csv file, but...
March 6, 2008 at 8:57 am
TheSQLGuru (2/19/2008)
I bet...
February 19, 2008 at 11:27 am
Christopher Ford (2/13/2008)
Since OVER() doesn't support ORDER BY when used with an aggregation.
How about this one?
SELECT J1.AccountID,
J1.Date,
...
February 14, 2008 at 8:06 am
Re: Defaults
First off, I'm pretty sure there is some sort of team/committee for each Microsoft product that decides on what the defaults should be. I'm also sure that decisions...
February 13, 2008 at 12:56 pm
Did you test using the Clustered Index with the ORDER BY subquery? It seems to me that the ORDER BY Would enforce the order, but since you are using...
January 31, 2008 at 6:32 am
I think that there are several issues that aren't well thought out about this type of consolidation.
The biggest, I think, is scale. I bike a bit, but I'm not...
January 10, 2008 at 6:29 am
Excellent question, James. Our policy is to never use auto number columns for anything other than identifying a row for update or delete.
I guess that doesn't really answer my...
December 11, 2007 at 2:54 pm
RowID, StateCode, StateName, Deleted, LastUpdated
Yes indeed. We typically have 5 custom fields on every table (Custom01 through Custom05) but not on the fact tables.
RowID, OrderTypeID, OrderTypeName, Deleted, LastUpdated
What do you...
December 11, 2007 at 12:53 pm
We have a table with state names and abbreviations. There are not likely to be more of them. We also have about a dozen small fact tables like that. Big...
December 11, 2007 at 10:44 am
By confusion, I was referring to the original scenario. PK/FKs are solely for maintaining referential integrity.
Assignments does not need a PK since it will never be a FK in another...
December 11, 2007 at 9:47 am
Viewing 15 posts - 121 through 135 (of 158 total)