Reputation
34,054
Next tag badge:
454/400 score
79/80 answers
Badges
2 49 104
Newest
 Good Answer
Impact
~1.2m people reached

16m
answered SQL Server: track database changes
1h
comment Index performance on ON versus WHERE
Do you really have a @table variabled with a non-clustered index that covers all fields, and no clustered index? or is just a simplification?
17h
comment What is the best option to easily fix fragmented heap indexes?
What exactly are you trying to 'fix'? Fragmentation on its own means nothing. Did you do aperf analysis that shows fragmentation to be an issue?
Jun
24
answered Building a ColumnStore index hogs system resources
Jun
23
answered SharePoint 2013 Database encryption
Jun
18
answered SQL Server 2012 Express installation failed
Jun
16
comment Why does SQL Server 2005 only use an IS lock in this scenario?
TOP 1 .. GROUP BY ... ORDER BY vs. MIN ... GROUP BY give a different semantically query. I recommend you post exact table definition along with test data you use.
Jun
10
comment Disk Read IO Throttle not showing in perfmon Windows Server 2012 r2
The list of counters available in the PhysicalDisk Object is documented. There is no Disk Read IO Throttle per sec counter.
Jun
9
answered sql server listen on multiple ports
Jun
9
comment Online index rebuild snapshot location and impact of filling index drive
As I say, the destination must match the final index destination, otherwise the data would have to be moved after the index is built.
Jun
9
comment Online index rebuild snapshot location and impact of filling index drive
Not exactly. The tempdb space needed depends whether a sort is actually needed, read SORT_IN_TEMPDB Option For Indexes. This is completely orthogonal to the index being online or offline built.
Jun
8
revised Online index rebuild snapshot location and impact of filling index drive
added 1 character in body
Jun
8
answered Online index rebuild snapshot location and impact of filling index drive
Jun
5
comment Is adding index on bit column significantly slow down inserts?
@drzaus: not true. A query plan is generic and has to work bot for '0' and for '1'. The optimizer will almost always choose a scan over the base table rather than use the index.
Jun
2
awarded  Good Answer
Jun
2
awarded  Nice Answer
Jun
2
revised The multi-part identifier > “a.surveyid” could not be bound
added 126 characters in body
May
29
answered SQL Server statistics
May
27
answered Database with FILESTREAM enabled gives Error 3056 during backup
May
27
answered What is the different between resource pools and workload groups in sql server?