Reputation
546
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 13
Newest
 Constituent
Impact
~19k people reached

Aug
10
accepted Performance/Health checking queries for a user with Read permissions
Aug
10
accepted Does Resource Governor help protect page life expectancy?
Aug
5
revised Understanding `dbcc showcontig` Record Size
Fix bad formatting of link
Aug
5
suggested approved edit on Understanding `dbcc showcontig` Record Size
Aug
5
revised Understanding `dbcc showcontig` Record Size
Added in the details for the replacement of SHOWCONTIG
Aug
5
suggested approved edit on Understanding `dbcc showcontig` Record Size
Aug
5
accepted Understanding `dbcc showcontig` Record Size
Aug
4
awarded  Constituent
Aug
4
revised Does Resource Governor help protect page life expectancy?
deleted 6 characters in body
Aug
4
asked Does Resource Governor help protect page life expectancy?
Aug
4
asked Understanding `dbcc showcontig` Record Size
Aug
3
awarded  Caucus
Aug
2
accepted What is the different between compression on the PK vs. on the Table?
Jul
2
comment Trigger/Event that fires when a Transaction finishes
@MisterMagoo - true that sounds bad. But I really have one service that does the updating. But there are several scenarios (other apps) that call this service. I did not explain that well.
Jul
2
comment Trigger/Event that fires when a Transaction finishes
@mustaccio - I looked into that quite a bit. Unfortunately indexed views have a lot of restrictions. My query has no way around a few of them.
Jul
2
asked Trigger/Event that fires when a Transaction finishes
Jun
29
accepted Insert a range of numbers from a call to sp_sequence_get_range
Jun
29
comment Insert a range of numbers from a call to sp_sequence_get_range
I like the number table option. Thank you again for the great answer!
Jun
29
comment Insert a range of numbers from a call to sp_sequence_get_range
Perfect! Thank you! What is master.dbo.spt_values? Looks like a system table. Are you just using it because it has a lot of rows? Is it safe to use a system table like this?
Jun
29
revised Insert a range of numbers from a call to sp_sequence_get_range
added 23 characters in body