Perfect Guys!!

thank you so much!

Gianluca Sartori (8/30/2011)

---

This should do:

;with data (string) as (

SELECT 'Saaaateres'

UNION ALL

SELECT 'NoRepeats'

UNION ALL

SELECT 'aabbbcdef'

),

tenRows (N) AS (

SELECT 1

UNION ALL SELECT 2

UNION ALL SELECT 3

UNION...

Thanks very much all for your very useful answers!!

I have a last request : How can I fin duplicates characters in a string . I mean I would like to...

drew.allen (8/26/2011)

---

I think this is what you are looking for.

WITH Test(TestField) AS (

SELECT 'aaa'

UNION

SELECT 'abc'

UNION

SELECT 'bbb'

UNION

SELECT 'bcd'

UNION

SELECT 'ccc'

UNION

SELECT 'cccccc'

UNION

SELECT 'cccccccccccccccccccccccc'

)

SELECT *

FROM Test

WHERE NOT TestField LIKE '%[^' + Left(TestField,1) + ']%'

It...

Here a table :

firstname lastname

-------------------- --------------------

aaaaaaa ccccccccccc

Jane ...

Thanks Phil,

but actually I need to check if all characters in my string are the same without to know the length of my string.

Tell me if I'm not clear and...

Thank you very much Jonathan

Hello Suresh,

thanks for your answer.

no it's a clustered Index and Yes it is a small table.

The fillfactor is 90.

Xavier

If your log file growth a lot, you can schedule a log backup every 30 minutes for example.

Yes you're right, but I tried to delete the other post wihtout success. I'm sorry.

Ok thank you very much

Ok thank you very much

yes I mean when I connect to a server from my machine the query takes longer than when I run it directly on the server.

I know the data travel across...

Hello Suresh,

from my computer I execute the query to the remote server.

It's a dedicated server.

Logs an datas files are on separate disks.

The RAM size of sql server will depend of the instances.

Actually I planned to implement 15 GB...

On each Instance there will be 5 databases for a 90 Gb total size.

There...