Reputation
55,252
Next tag badge:
131/100 score
19/20 answers
Badges
5 98 163
Newest
 Enlightened
Impact
~3.4m people reached

Apr
27
answered sys.dm_exec_procedure_stats reset
Apr
25
awarded  Enlightened
Apr
25
awarded  Nice Answer
Apr
24
awarded  Enlightened
Apr
24
awarded  Nice Answer
Apr
21
awarded  Enlightened
Apr
21
awarded  Nice Answer
Apr
14
revised Use of Trigger on table which can have 100 hits / second. Will it hamper performance?
added 844 characters in body
Apr
14
comment Use of Trigger on table which can have 100 hits / second. Will it hamper performance?
@marcellomiorelli: yes. there are many background read operations going on. UPDATE...WHERE: the WHERE bit is a read. INSERT requires a read of the PK and other unique indexes. DELETE/UPDATE may require a read of a parent table via a foreign key. etc.
Apr
14
answered Use of Trigger on table which can have 100 hits / second. Will it hamper performance?
Apr
13
awarded  Nice Answer
Apr
12
awarded  Nice Answer
Apr
12
answered 'Id' with the format: YYYYNNNNNN with the NNNNNN part restarting each year
Apr
11
answered SQL Server sample Update of Statistics misses highest RANGE_HI_KEY on ascending key column
Apr
11
revised Script/tool to use to check when the server is not being heavily used and configuring backup on Availbility Groups
added 61 characters in body
Apr
11
answered Script/tool to use to check when the server is not being heavily used and configuring backup on Availbility Groups
Apr
8
comment Adding custom language to SQL Server
No, because documentation only tells you what you can do usually.
Apr
8
revised SQL Server 2014 log growing just in Navision 2015 just when always on is active
added 40 characters in body
Apr
8
answered SQL Server 2014 log growing just in Navision 2015 just when always on is active
Apr
8
answered SQL Server Offline database