Hi Bob (Dixie etc)

Re:

Here's an interesting discussion I encountered...

...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...

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....

Who IS that masked man?

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...

Now that I think about it:

:: What to the incoming strings represent?

:: What do the numbers in the incoming strings represent?

:: Is the...

OK. So what are the rules around "all possible combination"?

Is this the sort of thing you're getting at?

IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL

DROP TABLE #test;

...

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...

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....

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...

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,...

@Thomas-282729

The argument that it's OK for data...

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....

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...