32,690 reputation
24799
bio website rusanu.com/articles
location Seattle, WA
age 42
visits member for 4 years, 2 months
seen 53 mins ago

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?
Mar
12
answered How can I switch to sa account from guest session in 2012 sql server?
Mar
10
comment Restore db with encrypted column in SQL Server, without overwriting existing Service Master Key
You were lucky indeed that SMK still worked, allowed you to add a password of choice.
Mar
9
answered Restore db with encrypted column in SQL Server, without overwriting existing Service Master Key
Mar
6
answered Improve sql server lookup table performance
Mar
4
comment How to perform server-side transaction timeout if COMMIT TRANSACTION will never arrive?
Note that pressing STOP in SSMS is not equivalent to any 'hung' or crash in you client app. STOP is equivalent to your application hitting the SqlCommand.CommandTimeout and initiating a query abort. The equivalent of app crash would be to kill SSMS or Disconnect the query window (but SSMS would refuse to disconnect 'abruptly' while running a batch, so will try to abort it first, different from an app crash behavior)
Mar
4
comment How to perform server-side transaction timeout if COMMIT TRANSACTION will never arrive?
Aborted batch is not a disconnect, so it should not and does not abort the transaction (pressing STOP in SSMS is aborting the current batch, not the transaction). Look also at SET XACT_ABORT ON.