Reputation
6,492
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 27 75
Impact
~366k people reached

Apr
4
comment AlwaysEncrypted Conversion Fails
you cant encrypt existing data.
Apr
4
comment VSS Snapshot backups vs 'proper' SQL backups
read this answer: serverfault.com/a/182462/43822 ... also, what do you mean by "high io?" also, is this "shared storage solution" actually in the cloud, or is it an intermediary that's shipping off to an offsite storage location ("cloud")? i'm extremely wary of VSS-based backup solutions. also, SQL Writer doesnt appear to support log backups so you're not going to get log reuse msdn.microsoft.com/en-us/library/… personally, i'd switch to local native backups that are then moved offsite ("cloud").
Mar
31
comment what are the costs of enabling extended events?
To add to this, XE has its own process space, over against profiler trace so resource consumption is external to the sql os, as far as i recall.
Mar
31
comment indexes and partition switching - how it works
have you tried rebuilding the indexes on table b and then switching to see what happens?
Mar
30
reviewed Reviewed Database design for efficient read queries given lots of writes
Mar
30
reviewed Reviewed Merge replication: some subscribers initializing by downloading changes multiple times
Mar
30
reviewed Close MS-SQL index not using all the available columns as seek predicates
Mar
24
comment Event 4104, MSDTC Client 2
i'll upvote you for the effort and the answer. unfortunately this was 4 years ago and i no longer work at this company so i can't validate your assumptions. also, my opinions on DM are ... not very favorable.
Mar
24
reviewed Reviewed Database existence not happened correctly
Mar
24
reviewed Close Oracle GoldenGate replication is stuck
Mar
24
reviewed Close Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x
Mar
24
reviewed Close Altering an Apache Derby table's derby.storage.pageSize property after creation
Mar
24
reviewed Close FREETEMPORARY on blob with no reference
Mar
24
reviewed Close Change tracking on, but columns not tracking
Mar
14
awarded  Popular Question
Mar
14
answered Incremental statistics: find out which partitions have been resampled
Mar
12
accepted Does there exist a way to determine the exact file that contains an allocation unit in a filegroup of multiple files?
Mar
10
revised Does there exist a way to determine the exact file that contains an allocation unit in a filegroup of multiple files?
added 439 characters in body
Mar
10
comment Does there exist a way to determine the exact file that contains an allocation unit in a filegroup of multiple files?
Thanks. I'm don't really want to control where it goes, but rather see where it's gone.
Mar
10
asked Does there exist a way to determine the exact file that contains an allocation unit in a filegroup of multiple files?