Reputation
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 12
Impact
~15k people reached

  • 0 posts edited
  • 0 helpful flags
  • 42 votes cast
Apr
24
comment Create Nested XML in a Sql Server Indexed (Materialized) View
@AaronBertrand - Unfortunately the data does change a fair amount. I am holding manually materializing as the last resort. If I have to, I can, but I would rather not.
Apr
24
revised Create Nested XML in a Sql Server Indexed (Materialized) View
added 192 characters in body
Apr
24
asked Create Nested XML in a Sql Server Indexed (Materialized) View
Apr
17
accepted SQL Server vs SOLR (Or any document db)
Apr
8
comment SQL Server vs SOLR (Or any document db)
@TomV - I don't really have a "customer" database. My situation is much more complex. I was just trying to simplify it so that the specifics of my domain did not get in the way of my question.
Apr
7
asked SQL Server vs SOLR (Or any document db)
Mar
30
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