I use ScriptDb from codeplex.com.

It does the whole database (tables, views, functions, etc) in one go so you can then just compare with your reference copy.

As I mentioned elsewhere, I still remember thinking "That's a big spaceship".

Then Darth's Star Destroyer comes into view, and goes on and on and on and I thought "No! THAT's...

Lynn Pettis (4/29/2009)

---

Now for something totally the same...

How many...

josephptran2002 (4/28/2009)

---

Hi

Yes there is a whole bunch of column fields name in where clause. But if you look carefully then it's just repeated columns such as DEClearedDate then DESecondClearedDate or...

Bob Hovious (4/23/2009)

---

With respect to testing, and I apologize for not having done more, it seems there are at least three or four variables about the test data to consider:

1....

Bob Hovious (4/23/2009)

---

Thanks, Flo 🙂

Derek, please don't feel you have to apologize. That needed to be tested. As usual, the answer is "It depends." ...

Hi Bob,

I did a few more tests (beyond the earlier table) and on my systems, the double-tally acheives better than half CPU time at long executions (.e.g 146 second vs...

OK. I ran more tests. It seems that on my systems, tally+charindex performs better on lower numbers but the double tally scales better.

[font="Courier New"]

                            Tally + CHARINDEX         Double tally        

Rows in     Rows...

Sorry to put a fly in the ointment, but I've tried a variation on your double-barrelled tally solution based on a problem mentioned here (splitting sentences into words at spaces).

I...

SanjayAttray (4/22/2009)

---

select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 2

or

select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 1

gives you same result.

NULL1

NULLmanoj

I tried on all sql server versions and result is same. ...

As Jeff indicated, the whole problem of splitting sentences into words can be done by the method he points to.

However, even if fnWord is treated as a 'black box', the...

Thanks

Not for me it isn't! As far as I'm concerned, this...

I clicked this as a T-SQL question I'd overlooked. I've never used MDX yet and would join the view that MDX is not T-SQL, so the 'except' operator is not...

Of course, when I thought about it, the Perl to split a string would simply be.

@lines = split('\ n',$string)

Since I usually need to do more complex matches I immediately thought...