35 reputation
4
bio website
location Atlanta, GA
age 41
visits member for 4 years
seen May 22 at 18:27

Jul
2
awarded  Curious
Oct
7
asked How to make OPENXML call set based
Sep
21
asked SQL Server 2008 SP1 Transactional Replication of a Partitioned Table Generates StackDump
Mar
30
asked FILESTREAM Enabled Database and Backup Compression
Feb
23
accepted Query Performance Degrades with High Number of Logical Reads
Feb
23
comment Query Performance Degrades with High Number of Logical Reads
Thanks Brent. Is this also applicable to dynamic sql?
Feb
23
asked Query Performance Degrades with High Number of Logical Reads
Jan
25
awarded  Scholar
Jan
25
comment sys.dm_db_missing_index_stats reports existing index
yep, pounded my head against this a few times. indexes are identical in every aspect. i believe that paul randal's blog post referenced above clears things up. i actually blindly applied this index based on the recommendation. i monitor usage stats to ensure that the index supports queries after having deployed. in this case, this appears to be one that is recommended but not used.
Jan
25
accepted sys.dm_db_missing_index_stats reports existing index
Jan
24
asked sys.dm_db_missing_index_stats reports existing index
Jan
21
comment FILESTREAM waits
thanks for the response ... anti-virus software isn't installed on this host. have you worked with filestream in a production environment? if so, what has the experience been for you? So far, it's been a mixed bag from my perspective.
Jan
20
awarded  Student
Jan
20
asked FILESTREAM waits
Jan
10
awarded  Tumbleweed
Nov
24
asked Defragment a FILESTREAM data container