Reputation
33,070
Next tag badge:
107/100 score
19/20 answers
Badges
2 47 100
Newest
 Nice Answer
Impact
~1.1m people reached

2d
answered High Page Faults/sec low Page Reads/sec
2d
revised SQL Service Broker and AlwaysOn Issue
added 440 characters in body
2d
answered SQL Service Broker and AlwaysOn Issue
Apr
7
awarded  Nice Answer
Apr
6
answered The operating system returned error 665(The requested operation could not be completed due to a file system limitation) on SQL Server 2014
Apr
2
comment Clustered index on a column with low selectivity
What is the purpose of looking up a low selectivity value? You can't possible display significant chunk of those 300k values. So why are you looking it up? Processing, aggregates, what are you doing?
Mar
27
comment How to handle too many inserts?
SSB isolates your central server data (transactions) from slow network. There won't be any data locks while the SSB messages are being exchanged, no matter how slow the transfer.
Mar
27
answered How to handle too many inserts?
Mar
26
answered Getting Machine name from where stored procedure was last executed
Mar
25
awarded  Nice Answer
Mar
23
comment Is it a good idea to include a value column (e.g. from measurements) in an index?
Is also important to evaluate, if you have, the access path that requests specific parameter_id values. Eg. SELECT AVG(value) FROM measurements WHERE measuretime BETWEEN '2015-01-01' AND '2015-02-01' AND paraemeter_id=42. Such a query require another index, something like ON measurements(parameter_id, measuretime) INCLUDE (value) but be aware that this nearly doubles your storage size as the clustered and non-clustered indexes are neirly the same size..
Mar
23
comment Is it a good idea to include a value column (e.g. from measurements) in an index?
@staeff: I recommend you read this series: sqlskills.com/blogs/kimberly/category/the-tipping-point
Mar
23
answered Is it a good idea to include a value column (e.g. from measurements) in an index?
Mar
19
comment Add linked server from SQL Server 11.0.5058 to SQL Server 10.50.4000
Any firewall rules preventing SQL Server from establishing outbound connection?
Mar
18
awarded  Good Answer
Mar
18
comment No value to update but still an TABLE UPDATE Operator
If you want to understand why the cost is 75%, post the actual plan (.sqlplan XML) not a picture. It contains information that can explain the cost. You can also inspect the XML yourself, or use a better plan viewer like SQL Sentry Plan Explorer‌​.
Mar
18
revised No value to update but still an TABLE UPDATE Operator
added 309 characters in body
Mar
18
answered No value to update but still an TABLE UPDATE Operator
Mar
17
answered What permissions does db_owner not have? (In SQL Server 2008)
Mar
14
answered Get object script in SQL Server via T-SQL?