ok i have to do this with a asp.net script at the moment, in future we are going to change to sql 2008.
Thanks again for your answer :)
Just one more question,
i read the md5 or sha-1 hash strings are not collision resistent and there could be 2 same outputs?
I really need the values...
exactly what i looked for :)
Thank you very much for the fast answer!
I have a table with about 1 million rows, and i need to check if a record exists with a nvarchar value that is greater than 1000 bytes.
well i mean that if i start a select statement that needs about 2 seconds ( Like SELECT COUNT( DISTINCT myColumn ) FROM TABLE WITH(NOLOCK)... )...
Hi and thanks for the fast answer!
I use nolock at the moment, this improves performance.
Do you think moving to sql 2008 has "big" performance...
This is my first post here, so i hope this is the right place for it :)
I designed a database, where about 1 million rows per month are...
Separate names with a comma.