Not had a chance to go through it properly but at first skim read that looks like a massively comprehensive article!

Thanks! :w00t:

Rahul The Dba (2/9/2011)

---

It seems that you are well famaliar in SQL, so can you tell is it always needed to have a primary key, in table and is it...

Looks like I'm another one who's never used the STR() function and having read the article I think I'll keep it that way.

At least I have a good reason now...

fszendzielarz (11/10/2010)

---

Oh yes. I forgot about that.

Doesn't it seem ridiculous that functionality that is already implemented is disabled for those who cannot pay for it? The irony is that...

Partitioned Tables are Enterprise Edition only

So the answet to why not is 10's of thousands of dollars!

Martyn Hughes (10/19/2010)

---

I don't know why you'd want to go to such lengths to use SSIS, just use Pervasive (formerly Data Junction). It's a far superior way of getting data...

I had copied other queries in the same query window from...

Easy thing to check in these instances is the network.

Open the windows command prompt and make sure you can ping the database server.

Thanks for that...

I found this:

select 'weird', ascii(' ')

union all

select 'space',ascii(' ')

returned:

weird160

space 32

So it was a stray ascii 160 character which had somehow...

can't you ignore the second bracket in your search?

alternatively search for

exec('

and

exec(@[a-Z]

Thanks, I hadn't but I have now... lots of green ticks and no incompatibility warnings

I think what you're looking for is:

select 'SE_Country' as col1, count(*) from .....

union all

select 'FE_Country' as col1, count(*) from ....

union all

There is logic behind not using the date as the key to the date dimension... it stops developers from falling into the easy trap of using the key as the...

It was actually done in Oracle...

Just because something works doesn't mean its the right to go about it.

A query which takes 3 hours in...