3,695 reputation
11227
bio website
location
age
visits member for 2 years, 11 months
seen yesterday

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.


2d
accepted Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?
2d
comment Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?
Thank you Max. Turned out I needed to run cports as administrator. After that, I was able to kill the connection. Is it at all possible to see the roll-back activity happening in real time? In other words, what a specific rollback process is actually doing.
2d
comment Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?
@MaxVernon Microsoft SQL Server 2008 (SP3) ENTERPRISE
2d
comment Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?
Hi @MaxVernon. Thanks for the advice. That's what I thought. Its an INSERT on the MSSQL pulling data from Oracle. How can I figure out if a rollback is taking place, if the ROLLBACK completion stays at 0%?
2d
revised Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?
added 370 characters in body
2d
revised Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?
deleted 15 characters in body
2d
asked Oracle OLEDB Connections hang in SQL Server: Can I restart Instance?
Oct
21
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