128 reputation
9
bio website qdsa.nl
location Barneveld
age
visits member for 2 years, 5 months
seen Jun 25 at 13:43

Developer using C#, mssql, Html, Javascript jQuery, css and lots of other tools as well.


Sep
24
awarded  Autobiographer
May
26
comment SQL Server 2012 performance degradation
We cannot stop SQL Server. It is a production environment. The reboots even occur during night when there is 0 IIS usage
May
26
comment SQL Server 2012 performance degradation
@AaronBertrand I already asked but they claim there is nothing strange. I don't know much about virtualization. Anything concrete I can tell them to look at?
May
24
comment SQL Server 2012 performance degradation
Yes, they say nothing is wrong with the hardware or virtual environment. Anything i can ask them to check?
May
24
comment SQL Server 2012 performance degradation
It is a relatively new server. In the system logs I don't see antyhing happening. Windows is activated when i check the computer properties window
May
24
awarded  Commentator
May
24
comment SQL Server 2012 performance degradation
The OS has 4GB. SQL has 3GB. It is on a hosted server which is in the cloud and virtual.
May
24
asked SQL Server 2012 performance degradation
Apr
13
awarded  Popular Question
Feb
28
comment difference between UPDLOCK and FOR UPDATE
Maybe you missed the ... in the code. also there is code before and after the moment this code is called. The flow of the program (which I won't discuss) makes it mandatory that certain records need to be locked with 100% certainty that the row cannot be updated by another statement.
Feb
27
revised difference between UPDLOCK and FOR UPDATE
added 59 characters in body
Feb
27
awarded  Editor
Feb
27
comment difference between UPDLOCK and FOR UPDATE
I updated the question, perhaps with this you can help me out?
Feb
27
revised difference between UPDLOCK and FOR UPDATE
added 603 characters in body
Feb
27
comment difference between UPDLOCK and FOR UPDATE
the above code is exactly what we use. the dots are just other code and lookups. Your answer looks like you didn't read the code provided since i did include a column list and a transaction and am not using a cursor. Or am I missing your point here?
Feb
27
comment difference between UPDLOCK and FOR UPDATE
Thanks. You say: 'in general'. I need to know if there is ANY specific difference between the 2 statements. We are using MSSQL only
Feb
27
asked difference between UPDLOCK and FOR UPDATE
Feb
1
comment Get counts grouped by month and year
True, Didn't know a better way to do it tough
Feb
1
answered Get counts grouped by month and year
Jan
31
awarded  Informed