366 reputation
212
bio website aruplab.com
location United States
age 39
visits member for 3 years, 1 month
seen yesterday

I am a software engineer from Salt Lake City, Utah.

enter image description here


1d
accepted Change Data Capture in a services environment
Mar
27
answered Change Data Capture in a services environment
Mar
27
answered Benefits of table partitioning on same disk
Mar
26
asked Change Data Capture in a services environment
Mar
20
comment Purging Data that has Foreign Keys
@beeks - I thought that you could not drop the partition even if you had cleaned up the dependencies in the data correctly. Is there a way to do it via partition dropping if you know the order of operations?
Mar
19
asked Purging Data that has Foreign Keys
Feb
9
comment REORGANIZE seems to work as well as REBUILD all the time
You are correct that we don't have a provable performance metric to fragmenting. (I did not think about the reorg pulling it into memory.) We are not overly emphasizing defragmenting. Just trying to keep it down along with all the other stuff we do.
Feb
9
accepted REORGANIZE seems to work as well as REBUILD all the time
Feb
9
comment REORGANIZE seems to work as well as REBUILD all the time
Yeah, I have read that too. But we have noticed a bit of a performance improvement when we keep them de-fragmented. The fragmentation is fairly predictable (table and time) so we are just going to automate it. I just wanted to make sure that I am OK with the REORGANIZE over the REBUILD before it gets automated.
Feb
9
comment REORGANIZE seems to work as well as REBUILD all the time
If it was not working, then it would not lower the fragmentation? (IE: As long as the fragmentation goes down we don't need to worry?)
Feb
9
asked REORGANIZE seems to work as well as REBUILD all the time
Feb
3
comment Filtered Index is not selected once an identical, non-filtered, index is made
@JamesZ - I updated my example to show better the relationship. I am selecting a list of orders that each have a CustomerId on them. The CustomerId can be the same for many orders.
Feb
3
revised Filtered Index is not selected once an identical, non-filtered, index is made
deleted 49 characters in body
Feb
3
revised Filtered Index is not selected once an identical, non-filtered, index is made
added 324 characters in body
Feb
3
asked Filtered Index is not selected once an identical, non-filtered, index is made
Jan
22
awarded  Popular Question
Jan
13
comment Does partitioning help if you don't query on the partition value?
@AaronBertrand - Dang. Guess I was hoping that the indexes would be able to figure out that a partition was not needed.
Jan
13
comment Does partitioning help if you don't query on the partition value?
@AaronBertrand - In my real scenario, the users that need the high performance are almost always working with recent orders. I can't add the where clause to the query because it is possible that there will be an old order come through. Statically, there is probably a 98%-2% split of recent order work being done. To relate it to the example, the order with Agent Bob Whiely would very likely be a recent order by virtue of the fact that is being worked on by the person running this query.
Jan
13
asked Does partitioning help if you don't query on the partition value?
Jan
9
accepted What does a “Buffer cache hit ratio” of 9990 mean?