Viewing 15 posts - 931 through 945 (of 4,080 total)
About partitioning. Look at example "H" here in BOL:
http://msdn.microsoft.com/en-us/library/ms174979.aspx
Partitions are subsets of a single table defined by a range of values. Each partition points...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 13, 2011 at 3:11 pm
Sonny, if correctly designed and coded, SQL is efficient up into millions and millions of rows. FYI, partitioning is a technique for segmenting...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 12, 2011 at 2:49 pm
I have to ask: If all of the tables have similar data, why aren't you simply using one big table?
The query would be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2011 at 11:01 am
The first one looks like a running total. But I can't make any sense of the other rows.
Neither (50-10 = 10) nor (20-5=5 ) compute for me.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 12, 2011 at 3:46 pm
Not being a problem, Evil Kraig. 😉
What made you decide to change your name?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 12, 2011 at 6:11 am
Congratulations and good luck, Lynn.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 12, 2011 at 6:00 am
Congratulations, Brandie!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 11, 2011 at 4:58 pm
If the ID is included as part of the index, the optimizer can find MAX by matching on [field_name1] and [field_name2], then reading the last value of ID. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 11, 2011 at 4:53 pm
Comments withdrawn. Gail's example below is a lot more clear and concise than all my verbage.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 11, 2011 at 3:12 pm
Well-written CLR has proven to have some clear performance advantages over T-SQL in performing complicated string manipulation, such as parsing of large text strings. Solutions that require array...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 8, 2011 at 8:54 pm
Where is the 'd' coming from in your output set? Is it a typo?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 8, 2011 at 8:37 pm
You could also cross apply a subquery to get the TOP (1) row sorted by date descending, or use Row_Number() ordered by date descending where row_number() = 1. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 8, 2011 at 8:25 pm
Lynn Pettis (8/7/2011)
Someone obviously took exception with my opinion.Hope my response wasn't too harsh.
Edit: Fix typo.
You're response was fine as usual, Lynn. The OP wanted the "Make MVP...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2011 at 10:01 pm
WHERE clauses evaluate expressions which return true or false values. Two simple examples:
WHERE 1 = 1 -- will return ALL rows
WHERE 1 = 0 -- will...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2011 at 6:30 pm
Sorry, misread the question.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2011 at 8:25 am
Viewing 15 posts - 931 through 945 (of 4,080 total)