Reputation
417
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 16
Impact
~21k people reached

  • 0 posts edited
  • 0 helpful flags
  • 23 votes cast
Mar
9
awarded  Notable Question
Dec
2
awarded  Popular Question
Sep
11
awarded  Popular Question
Aug
4
awarded  Yearling
Jul
2
awarded  Curious
Feb
7
awarded  Notable Question
Nov
17
awarded  Popular Question
Sep
30
awarded  Notable Question
Sep
26
asked How to insert and or update a variable number of records and prevent concurrency issues
Jun
21
awarded  Popular Question
Mar
14
awarded  Popular Question
Oct
11
awarded  Popular Question
Sep
4
asked How to remove xmlns from child elements with FOR XML
Jun
14
comment How to prevent daily index fragmentation of 99%
I am rebuilding every day right now but I wonder if I can prevent this from having to happen every day since I can anticipate pretty well on how the data evolves.
Jun
14
revised How to prevent daily index fragmentation of 99%
added 878 characters in body
Jun
14
asked How to prevent daily index fragmentation of 99%
Jan
24
accepted What affects the speed of a count(*) besides the number of records
Jan
24
asked What affects the speed of a count(*) besides the number of records
Jan
16
comment What are the disadvantage/consequences of moving updated column to separate table to prevent table lock on the original table?
I ended up going with the snapshot isolation level. The batched approach also worked but I got very random performance out of it and sometimes over 1000% worse.
Jan
16
accepted What are the disadvantage/consequences of moving updated column to separate table to prevent table lock on the original table?