Click here to Skip to main content
15,906,708 members
Home / Discussions / Database
   

Database

 
GeneralRe: User name changed in active directory, SQL Server shows old user name Pin
GuyThiebaut15-Jan-15 9:01
professionalGuyThiebaut15-Jan-15 9:01 
GeneralRe: User name changed in active directory, SQL Server shows old user name Pin
Richard Deeming15-Jan-15 9:18
mveRichard Deeming15-Jan-15 9:18 
GeneralRe: User name changed in active directory, SQL Server shows old user name Pin
GuyThiebaut15-Jan-15 9:22
professionalGuyThiebaut15-Jan-15 9:22 
AnswerSUCCESS! Pin
GuyThiebaut15-Jan-15 22:37
professionalGuyThiebaut15-Jan-15 22:37 
QuestionIsolation Level Pin
Member 1137363813-Jan-15 19:07
Member 1137363813-Jan-15 19:07 
AnswerRe: Isolation Level Pin
Eddy Vluggen13-Jan-15 23:44
professionalEddy Vluggen13-Jan-15 23:44 
GeneralRe: Isolation Level Pin
Member 1137363814-Jan-15 0:30
Member 1137363814-Jan-15 0:30 
GeneralRe: Isolation Level Pin
Eddy Vluggen14-Jan-15 2:56
professionalEddy Vluggen14-Jan-15 2:56 
Member 11373638 wrote:
I did all these findings
Which findings?

Member 11373638 wrote:
and altered the procedures.
What did you alter?

Member 11373638 wrote:
I am just struck with this Serializable isolation.
There is two queries that keep waiting on each other. Once you know which ones, you can check whether they use the default isolation. I don't see a reason why this should be "serialized" and not the default value.

Depending on WHAT the queries do, you can define an alternative. If it is a read, then you might opt for a dirty read - or to wait until the other query is finished. If it are two writes, then you'd either need a queue, or a way to specify whom the victim will be. It will never be possible to update a single field using two queries simultaneous, so there will always be a victim unless the logic changes.

TL;DR yes, but changing the level will not automatically fix it.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Isolation Level Pin
Member 1137363814-Jan-15 16:57
Member 1137363814-Jan-15 16:57 
AnswerRe: Isolation Level Pin
Eddy Vluggen15-Jan-15 9:56
professionalEddy Vluggen15-Jan-15 9:56 
GeneralRe: Isolation Level Pin
Member 1137363815-Jan-15 17:15
Member 1137363815-Jan-15 17:15 
GeneralRe: Isolation Level Pin
Eddy Vluggen16-Jan-15 7:58
professionalEddy Vluggen16-Jan-15 7:58 
QuestionAudit Tables for Many-Many Relationships Pin
Matt U.13-Jan-15 3:40
Matt U.13-Jan-15 3:40 
AnswerRe: Audit Tables for Many-Many Relationships Pin
Eddy Vluggen13-Jan-15 7:49
professionalEddy Vluggen13-Jan-15 7:49 
GeneralRe: Audit Tables for Many-Many Relationships Pin
Matt U.13-Jan-15 10:00
Matt U.13-Jan-15 10:00 
GeneralRe: Audit Tables for Many-Many Relationships Pin
Eddy Vluggen13-Jan-15 12:49
professionalEddy Vluggen13-Jan-15 12:49 
AnswerRe: Audit Tables for Many-Many Relationships Pin
Mycroft Holmes13-Jan-15 11:42
professionalMycroft Holmes13-Jan-15 11:42 
Questionhelp me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay12-Jan-15 21:16
Nguyen Jay12-Jan-15 21:16 
QuestionRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 5:33
professionalZurdoDev13-Jan-15 5:33 
AnswerRe: help me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay13-Jan-15 5:40
Nguyen Jay13-Jan-15 5:40 
AnswerRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 5:44
professionalZurdoDev13-Jan-15 5:44 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay13-Jan-15 5:53
Nguyen Jay13-Jan-15 5:53 
AnswerRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 6:00
professionalZurdoDev13-Jan-15 6:00 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
Nguyen Jay13-Jan-15 6:03
Nguyen Jay13-Jan-15 6:03 
GeneralRe: help me ..plz share me database Contact.mdf microsoft Pin
ZurdoDev13-Jan-15 6:06
professionalZurdoDev13-Jan-15 6:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.