Viewing 15 posts - 121 through 135 (of 149 total)
Hi Bob (Dixie etc)
Re:
If anyone would post up some examples where a cursor solution outperforms a set-based solution, I will look at them respectfully.
Here's an interesting discussion I encountered...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
July 17, 2011 at 6:26 am
...of course the real take-home message is that you're much better off avoiding BETWEEN when dealing with datetime (or smalldatetime (or floating point)) data.
You can be sure you'll get what...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
July 2, 2011 at 11:47 pm
Oh ye of little faith.
HL7[/url] is the answer to your prayers as surely as a wagon needs a cummerbund. Quiet please. This is important. You must consider the HL7 protocol....
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 13, 2011 at 10:07 pm
Who IS that masked man?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 9, 2011 at 2:55 am
So (to labour the point) if the incoming string is "01-06-05-04" then:
:: "01" is not a valid answer?
:: "01-04" is considered to be the same as...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 8, 2011 at 10:53 pm
Now that I think about it:
:: What to the incoming strings represent?
:: What do the numbers in the incoming strings represent?
:: Is the...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 8, 2011 at 10:34 pm
OK. So what are the rules around "all possible combination"?
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 8, 2011 at 10:25 pm
Is this the sort of thing you're getting at?
IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL
DROP TABLE #test;
...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
March 8, 2011 at 10:05 pm
So a filtered index reduces the number of columns and (importantly) the number of rows you need to search, whereas an indexed view... does pretty much the same thing. Where...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 17, 2011 at 10:05 am
There is some great feedback here. I'm going to take it away, digest it and come back with some feedback of my own and hopefully the germ of a plan....
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 9, 2011 at 12:29 pm
Apologies for my lack of clarity and thanks for the feedback Ashish. You say...
The problem could not be just because of nolock, the join within the query might be the...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
February 9, 2011 at 4:27 am
Maybe I missed something in the previous replies, but the real question might be "Why has my DB grown so large?" It would be good to know how it's designed,...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 24, 2011 at 12:12 pm
Who cares that a guid takes up 4x the space if you have 100x the processing power and memory? What about 1000x?
The argument that it's OK for data to take...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
January 1, 2011 at 1:52 pm
This sort of thing does have its amusing side sometimes. An organization I used to work for hired a data warehousing "expert" to fix the mess their warehouse was in....
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
December 31, 2010 at 1:34 pm
I think 70% of my points come from the novelty questions on public holidays. The other 45% comes from cheating. What does that say about me? Anyways I like this...
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell
December 24, 2010 at 4:59 am
Viewing 15 posts - 121 through 135 (of 149 total)