Reputation
501
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 13
Newest
 Caucus
Impact
~18k people reached

  • 0 posts edited
  • 0 helpful flags
  • 58 votes cast
15h
awarded  Caucus
2d
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
Jun
29
comment Insert a range of numbers from a call to sp_sequence_get_range
@AaronBertrand - I mean that after the call to sp_sequence_get_range, I want a set based way to insert 38 - 50 (every other) into a table. So no, I don't want to avoid the call to sp_sequence_get_range. (I updated my question to be a bit more clear on this.)
Jun
29
asked Insert a range of numbers from a call to sp_sequence_get_range
Jun
25
accepted Dynamic Partition Elimination when using “OR ” or “IN”
Jun
25
comment Dynamic Partition Elimination when using “OR ” or “IN”
@AaronBertrand - Yes it is. And a union does work. Is my only option to replace all my "or"s and "in"s with repeat Union queries ? And if so, why?
Jun
25
asked Dynamic Partition Elimination when using “OR ” or “IN”
Jun
19
accepted Order of DROP_EXISTING and ONLINE for CREATE INDEX
Jun
18
asked Order of DROP_EXISTING and ONLINE for CREATE INDEX
Jun
18
accepted Sql Server thinks I have different Data Compression when swaping partitions
Jun
17
comment Sql Server thinks I have different Data Compression when swaping partitions
@DanGuzman - You were right. I setup a repro and it worked fine. I am guessing that somehow I got my tables crossed while renaming from the olde table to the new. So I was trying to swap the partition of the wrong table (That did not have the right compression). If you want to post an answer about making sure your source table is what you think it is, I will accept it.
Jun
17
revised Sql Server thinks I have different Data Compression when swaping partitions
deleted 2 characters in body
Jun
17
asked Sql Server thinks I have different Data Compression when swaping partitions