Hey flo,

Thanks so much, very kind of you to say.

I agree that those 'phone numbers' are a pain to work with...:pinch:

I've enjoyed this thread, and I think you have too....

One more thought from me:

In the worst possible case, where all flags are independent and no sensible optimizations can be made from the database manager's knowledge of the data, the...

That's good news! And you're welcome, though I was just guessing...

Flo,

Awesome script - nice job!

That's some neat SQL for a 'developer' 😀

I wish the developers at my workplace were as SQL-literate. I particularly like the numbers table generation from...

nimdil (4/3/2009)

---

I understand. My point is - probability of getting 12 bits in 6 BIGINTS (when I have 5000 bits) is quite low without good statistics. I don't have good...

Not quite. Let me try again:

[Note that the probability of find the bits you are looking for in one column improves linearly with the number of bits in that...

nimdil (4/3/2009)

---

As we are working on 32-bit environment I've seen no advantage of BIGINT over INT as all bit-wise operations are made, as I recall, on 32bit segments. So more...

RJ (4/2/2009)

---

unfortunately i cann't add another table to the database though this would help me run procedure in checkpoint.

i have to create transaction within a loop to delete user &...

Hey flo,

Agreed. I put some further thoughts in my previous post which you might not have seen yet.

I wonder whether the OP would see any benefit from using BIGINT...

Hey there,

{mode=psychic}

Assuming you have a DEFAULT constraint on the columns set to GetDate() or CURRENT_TIMESTAMP or GetUtcDate(), and that you are using the table editor in Management Studio to enter...

Hey there,

It's very difficult to guess based on the information provided, but:

1. If you trace the server looking for queries using excessive CPU, does anything stand out?

2. Do...

Hey there,

From our experience with virtualising SQL Server (OLTP and OLAP) using fairly high-end hardware and Win2k8, I feel comfortable summarising the team's experiences as: just don't do it!

Whatever theory...

Hi!

Can...

Hey there nimdil,

In the quick test I threw together, the intersect was implemented as an inner loop join, seeking on an index on both inner and outer inputs. It seems...

Hi Flo,

Your idea there is intriguing, but it left me with a couple of questions:

1. Does it support AND / OR combined searches as in the posted examples?

2. ...