802 reputation
1719
bio website
location London, United Kingdom
age 36
visits member for 2 years, 6 months
seen 6 hours ago

SQL Server DBA/developer


Aug
28
comment Memory Issue - SQL Server 2008r2
Can you post what sp_whoisactive output looks like when you see this amount of memory usage from MEMORYCLERK_SQLOPTIMIZER?
Aug
27
comment Recovering MySQL root password (XAMPP)
Glad to hear it. I think you could document the steps that worked for you and then self-answer if you want.
Aug
26
comment Recovering MySQL root password (XAMPP)
Does this work? learntech.imsu.ox.ac.uk/blog/?p=151
Aug
25
comment Huge differences of performance of MySQL in two servers
Sounds like you should upgrade the OS on the test server and make it prod : )
Aug
23
comment Infinite loop in MySQL when connecting to database
Yes, the log entries you pasted just show MySQL starting successfully.
Aug
22
comment how to resolve mssqlsystemresource.mdf corruption?
What happened to R:\aSQL\? Is that a mount point? If so, does it still exist?
Aug
22
comment What makes yum difficult with RAID
yum is a software package manager. It isn't aware of what RAID level you're using. I'd suggest asking the person who told you this for clarification, as it seems to make no sense. This is like saying 'it's difficult to use RAID5 with Windows Update'.
Aug
1
awarded  Notable Question
Jul
17
revised Security implications of restoring a backup from an unknown source?
added 26 characters in body
Jul
17
answered Security implications of restoring a backup from an unknown source?
Jul
8
comment Is it possible to have the transaction log file write to a disk on a remote machine?
I don't think this addresses the actual question. The OP appears to be asking about hosting the transaction log on a remote server, over a CIFS share or some other means.
Jul
4
comment Not all members in a Windows group have permissions
Was DMN\Group a security group or a distribution group?
Jul
2
awarded  Curious
Jun
23
comment ibdata1 corrupted, recover from ib_logfile?
Or hire Percona to do the work for you. (I'm assuming there's no backup to restore from.)
Jun
3
revised How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
deleted 25 characters in body
Jun
3
comment How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
@stacylaray Thanks. Any insight into why the problem would keep occurring with async=true enabled?
May
29
revised How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
added 3 characters in body
May
29
comment How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
Yes, I think Ladislav's answer to that question highlights why the dev probably can't disable MARS easily. The app is probably coded to execute multiple queries on the same connection in parallel, and disabling MARS in the connection string may just make the error happen more often unless the dev rewrites the app. The only answer may be 'debug your app, or rewrite it and turn MARS off.'
May
29
comment How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”
Yes, I may just suggest they test turning off MARS. I don't know why they are using it and doubt the developer does either as this is a spaghetti code legacy app handed down through many generations of developers. That said, I'm not sure if that will stop this error or make it occur incessantly.
May
29
asked How to troubleshoot “client driver has sent multiple requests while the session is in single-user mode”