3,688 reputation
11227
bio website
location
age
visits member for 2 years, 11 months
seen 21 hours ago

Huge fan of SQL Server, I've been searching for opportunities to work on more MSSQL projects which is why I'm here.

I have been working in mixed environments with a combination of MySQL, PostgreSQL, LDAP and SQL Server for the past 15 years.


21h
awarded  Notable Question
Oct
17
accepted Tracking Down Application Timeout Errors in SQL Server
Oct
15
answered Tracking Down Application Timeout Errors in SQL Server
Oct
15
revised Tracking Down Application Timeout Errors in SQL Server
edited title
Oct
15
comment Tracking Down Application Timeout Errors in SQL Server
Hello @AaronBertrand. It turns out that SQL Server profiler was capturing a user error event with a value of 2 - Abort when IIS cancels query execution. I didn't notice anything showing up in Attention or a case where stmt:completed was empty.
Oct
14
asked Tracking Down Application Timeout Errors in SQL Server
Oct
3
revised Socket recv() timeout on secondary nodes
added 779 characters in body
Oct
3
answered Socket recv() timeout on secondary nodes
Sep
30
awarded  Explainer
Sep
26
awarded  Famous Question
Sep
24
awarded  Autobiographer
Sep
22
comment High MySQL “InnoDB Writes Per Second” - Can't see the queries?
Updated my answer
Sep
22
revised High MySQL “InnoDB Writes Per Second” - Can't see the queries?
added 294 characters in body
Sep
22
comment High MySQL “InnoDB Writes Per Second” - Can't see the queries?
SHOW PROCESSLIST is going to give you the queries being executed now, how does MySQL workbench calculate the actual number of queries being processed?
Sep
22
answered High MySQL “InnoDB Writes Per Second” - Can't see the queries?
Sep
22
comment High MySQL “InnoDB Writes Per Second” - Can't see the queries?
The number of writes per second is pretty close to the number of queries per second. This graph doesn't give enough detail to determine how many queries each client is executing on the server. So perhaps, those 30 clients are executing dozens of queries.
Sep
19
comment How to setup complex multi-column index for massive table
Hello again, switching to InnoDB in a test environment, would allow you to test under both engines. It would be nice to know if an improvement, if any is possible.
Sep
18
comment How to setup complex multi-column index for massive table
Would the query fit into RAM, if you switched the table engine to InnoDB?
Sep
18
revised Update tag range on MongoDB range shard
added 509 characters in body
Sep
18
revised Update tag range on MongoDB range shard
added 36 characters in body