aaah duh.... figured out how to search...

here it is.

Of course he counterracts his own "don't" statement from before and says it shouldn't matter. Which is what I thought until...

What's odd, was that I was in a session held by Microsoft about 2 years ago and the expert talking about performance recommended against it. Something about how the...

BLAH! Why...

I get this if I run the script.

Msg 102, Level 15, State 1, Line 8

Incorrect syntax near 'GO'.

If I remove the semi-colon from the GO, it works.

Hugo Kornelis (11/30/2012)

---

Tom, I also have been trying to find when cascading referential integrity was introduced. Like you, I could not find anything conclusive, but I might very well have...

Koen Verbeeck (11/30/2012)

---

Yes. But changing it is also normal.

Just because the default...

My normal scenarios include Nullable foreign keys and DELETE CASCADE options.

I completely concur

On CASCADE...

I thought it was a good question... a little bit tedious for me to pick through (apparently I need more coffee or something), but a good one nonetheless.

I was going to say... method two.

cast(cast(reverse(substring(cast(@t as binary(9)),2,5))

as binary(5)) as bigint)*100

Lacks a select, lacks a declare for @t, etc... and the question was , which methods...

I should have looked at and answered this one this morning.

Instead I'm sitting here after a big lunch barely concious... I think I picked answers at random.

Just an FYI here.

I managed to get my SSIS package to process SSAS.

I did it by creating a Job in SQL Agent to run the IS task.

When I then ran...

This is something I've wanted to have in my pocket for a long time.

SQL has always made sense to me... MDX has not... and until I've read and re-read this...

Oh and of course I got it wrong... because I just went with

SELECT ASCII('Z')-ASCII('0')

Sadly I'm just too dang American... A thru Z, 0 thru 9... sure... but ASCII isn't Latin1_General_CI_AS

SQL Kiwi (11/1/2012)

---

derek.colley (11/1/2012)

---

I'm afraid this question was just too obscure for me. It's a good question, sure, but why would I need to know this or reference it...