31,425 reputation
24295
bio website rusanu.com/articles
location Seattle, WA
age 42
visits member for 3 years, 11 months
seen 2 hours ago

Dec
16
comment Installing SQL Server 2012 - Wait on the Database Engine recovery handle failed
"Check the SQL Server error log for potential causes."
Dec
12
comment Next value for Sequence Function
@MartinSmith: many lols
Dec
12
answered Next value for Sequence Function
Dec
9
answered Security or performance risks using SQL CLR
Dec
5
answered Does “Synchronous-Commit Availability Mode” ensure consistency between Replicas?
Dec
3
revised Sql server table insert performance optimization
edited body
Dec
3
revised Query on a SQL Server view with openquery to Hive returning wrong answer
added 20 characters in body
Dec
3
answered Sql server table insert performance optimization
Nov
28
comment InnoDB inserts 100 times slower than SQL Server inserts
Actually a quick search will quickly confirm that indeed MySQL does force a disk flush even when write cache is on.
Nov
28
comment InnoDB inserts 100 times slower than SQL Server inserts
4x, 5x could be explained by engine differences. I suspect MySQL is using an API that forces flush even when write cache is on. Therefore only SQL benefits from write cache, disturbing the result. You should expect the performance of having write cache off in production, or give up ACID durability guarantees. There are ways to get back the perf loss (batch commit, bigger transactions etc).
Nov
28
revised InnoDB inserts 100 times slower than SQL Server inserts
added 299 characters in body
Nov
28
revised InnoDB inserts 100 times slower than SQL Server inserts
added 274 characters in body
Nov
28
answered InnoDB inserts 100 times slower than SQL Server inserts
Nov
28
comment SELECT with lots of left join is very slow in SQL Server 2014
How to analyse SQL Server performance
Nov
27
awarded  Revival
Nov
27
comment Adding around 200 rows in a table grows size of the table by 400kb where avg row size is 0.2KB
Post the exact methods you used to measure the row size and the table size.
Nov
27
answered SQL Server - Logical Reads lowered, Execution time remained the same
Nov
26
awarded  Enlightened
Nov
26
awarded  Nice Answer
Nov
26
comment Setup error :Attempted to perform an unauthorized operation
View and Read SQL Server Setup Log Files