I've just found my answer

This is possible, but not cost effective as I'd need to use Enterprise.

http://download.microsoft.com/download/6/6/F/66FF3259-1466-4BBA-A505-2E3DA5B2B1FA/SQL_Server_2014_Licensing_Datasheet.pdf

I knew it would be a numpty moment. I was missing a where clause, so trying to do a top 10 over the entire dataset(?)

DECLARE @g geography = 'POINT(-1.43499...

Andy

might it be some browsers can't handle multiple heights and widths?

from the bottom image:

<img style="WIDTH:608px;HEIGHT:1614px;" height="1614" src="http://vsteamsystemcentral.com/images/ext/EntDBMetadata_31.png" width="608">

Chrome, IE9, FF for windows handle it OK (UK too)

slightly off topic: For the likes of windows passwords back in the 2000/2003 server days, it looked to the lay person (me) that, only stored the first 8 characters were...

Nice. Knew there must be a tool to do this

I can see my pcs graphics card will be busy this afternoon to see how long it takes to break my...

Monty Python reference?

BODMAS

Edit: Shucks... Toreador, beat me to it.

OK PEMDAS

Ouch!

A real longshot.

If you back it up and restore to a new named database (leave the original alone) on the same server, same instance same disk, but different...

Thank you. This is bound to bite me in the future.

Bookmarked

If you can lookup how to capture info from a command prompt and put it into a table, you could use the command:

Net start

To list all running processes. Joined with...

Interesting one. The explanation given isn't quite correct:

2. len(case name when 'master' then 'other' else 'name' end) > 4 --only the length of 'master' > 4, all other db's...

Cheers

Sorry about the name :blush: That'll teach me not to read things properly

Hi Tony

it wasn't 0x I was interested in, it was 0x00, but your previous suggestion worked fine:

select *,DATALENGTH(cast(substring(city,30,1) as varbinary))

from t_address

returns 1 against the record where there is something as...