Reputation
322
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 20
Impact
~46k people reached

  • 0 posts edited
  • 0 helpful flags
  • 25 votes cast
Mar
18
awarded  Popular Question
Mar
10
comment Trigger shouldn't block insert
its very unclear what you wrote here.
Mar
1
comment Why is sql server waiting for acknowledgment?
Thank you for the detailed explanations and solutions. @otherAnswers were also very helpful, but I could only accept one..
Mar
1
accepted Why is sql server waiting for acknowledgment?
Feb
26
comment Why is sql server waiting for acknowledgment?
I see. Thank you for that information.
Feb
26
comment Why is sql server waiting for acknowledgment?
whats the downside of turning on snapshot isolation?
Feb
26
comment Why is sql server waiting for acknowledgment?
Thanks for that link. since we do use uniqueidentifier as clustered index, the noLock is not an option as the pages split very frequently. question is if SNAPSHOT isolation level is safer in that regard?
Feb
26
comment Why is sql server waiting for acknowledgment?
Thank you for your comment, can I make NOLOCK on the server side via the SP? I'm trying to avoid changing the application as much as possible. also what is the risk of doing so? the data is never modified by that transaction.
Feb
26
comment Why is sql server waiting for acknowledgment?
Sorry, but you didn't add anything to what I didn't already know and wrote in the question. I want to know how to prevent that lock from being placed on the table. if that's not possible I would like to understand why. a select is not modifying any data, so why is a lock necessary?
Feb
26
asked Why is sql server waiting for acknowledgment?
Oct
20
awarded  Autobiographer
Oct
8
awarded  Popular Question
Aug
4
awarded  Popular Question
Jul
2
awarded  Curious
Oct
9
accepted How to repair Microsoft.SqlServer.Types assembly
Oct
3
awarded  Popular Question
Jun
4
awarded  Self-Learner
May
26
answered How to repair Microsoft.SqlServer.Types assembly
May
26
comment How to repair Microsoft.SqlServer.Types assembly
yes I did. but any way I redid the full database now. and it looks like this will work
May
26
asked How to repair Microsoft.SqlServer.Types assembly