http://connect.microsoft.com/SQLServer/feedback/details/415171/finnish-swedish-collation-does-not-handle-sorting-correctly

it's by design. You will need to change collation or use the collate keyword

I was pretty sure that it's not possible, but i'm not an expert, so i needed a little confirmation first.

I think i'll go with the coincidence explanation. Thank you two...

Yeah sorry, i made a mistake while typing the truncate.

I think i found an explanation to this behavior :

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx

http://www2.sqlblog.com/blogs/alexander_kuznetsov/archive/2009/04/10/selects-under-read-committed-and-repeatable-read-may-return-incorrect-results.aspx

The update of the bit field made the select return the...

If anyone still have this issue, Microsoft finally gave an answer with a solution to this :

https://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-failover-results-in-reseed-of-identity]

Thank you for the info

If string is the slowest, is there any difference between a integer and a binary field ?

well i learned something today.

Thank you !

Thank you for the clarification

This thread showed me that i should not...

Thank you for the info

You can actually prevent this behavior on sequence with the NO CACHE option. It's too bad we can't do the same with identity column.

I guess the insert hyperlink button is broken 😉

And thank you Gila, thats exactly the answer i was looking for (if a fix already exists or not for this !)

I dont have always on ( i am on standard version)

For the table definition. It does this with any table with an identy field on it. I found this...

So if anyone open this thread in the futur, it's infact a display bug.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/d5645ed8-24e8-4c16-be57-e0ba85305f53

To help anyone understand what im talking about, i added a screenshot.

it's in french, but i think you can still understand what is going on !

Storage = Stockage

octets = bytes

To...