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

SQL Server DBA/developer


1d
comment Replace relational database with “poor” design in software product with non-relational DB?
+1 Especially for the comments about moving on. I'd add that on NoSQL someone will also have the headaches and expenses of trying to back up, restore, scale, tune, shard, cluster, and fix what is likely to be a far less stable technology with much less instrumentation compared to a decades-old RDBMS. These things obviously aren't always trivial on SQL Server or Oracle, but are often even worse on emerging platforms in my experience.
Sep
14
comment How to configure my.cnf for Mysql 5.1, which is using too much CPU?
@Aarmir "I am having trouble in my server which is using too much CPU on database query(simple count statement)." If you post 1) the query, 2) the EXPLAIN output for the query, 3) SHOW TABLE definitions, and 4) some information about the CPUs in the server, someone can probably advise you on whether it's possible to reduce CPU usage from the query.
Sep
9
comment How do I tactfully bring up database shortcomings?
You're probably more experienced and better at dealing with this type of situation than almost anyone, but still I'm confused. Are you saying that in this situation you'd say that it used to be a best practice to shrink files weekly and give the app account the db_owner role? Maybe I'm taking you too literally.
Sep
9
comment MYOB ODBC crashes SQL Server
Your SQL Server is totally unpatched, though (2009.100.1600.1 is 2008 R2 with no service pack or cumulative update).
Sep
9
comment MYOB ODBC crashes SQL Server
I would just contact the vendor and tell them you're getting an access violation from their DLL, or try using the ODBC drivers that ship with Windows and see if those work.
Sep
8
comment MYOB ODBC crashes SQL Server
You can access a 64-bit server from a 32-bit client. They don't need to both be 32-bit. About the crash, I'm assuming you mean that the SQL Server service stops with an error, and then you have to start it again. What error messages do the logs show? Is it patched to the most recent service pack and cumulative update?
Sep
6
comment How to JOIN more than two tables?
Because it's an inner join, only rows that matched all the join conditions would be returned. Sorry, but I think you really need to study SQL for a while. You'll get a better understanding that way.
Sep
6
comment Importing Data with Single .ibd file
You can't copy the ibd files to another MySQL instance without some hackery because the metadata in the ibd file won't match what's in the global InnoDB data dictionary. Instead you can use one of the methods that Vérace describes.
Sep
6
comment How to JOIN more than two tables?
Based on your schema, the last join condition can be ON [Marks_Table].TypeId = [Types_Table].TypeID. You can use the same table reference multiple times. Unless I've misunderstood you, this is a basic join that will be described in any introductory text or tutorial about SQL.
Sep
6
revised How to JOIN more than two tables?
formatted query to make it readable
Sep
6
suggested suggested edit on How to JOIN more than two tables?
Sep
5
answered How Does Max Server Memory Affect PLE on a Host That Is Not Memory Bound?
Sep
5
comment How to prohibit MongoDB primary node become secondery?
See dba.stackexchange.com/questions/41707/…, which has accurate (though not yet accepted) answers.
Sep
4
answered SQL Server Restore Database Error
Sep
3
comment Performance difference between two MariaDB slaves
Also, is the EXPLAIN output the same on both machines?
Sep
3
comment MySQL instance stalling “doing SYNC index”
@syneticon-dj How about writes to the same filesystem from outside of MySQL -- are those stalling as well?
Sep
3
comment Configuration to stop mysql sleep
The wait_timeout is also in the wrong section of my.cnf. It will get ignored in [mysqld_safe].
Sep
3
comment MySQL instance stalling “doing SYNC index”
@MorganTocker @RolandoMySQLDBA One thing that stood out to me in the sar -d output is that await is going up almost tenfold during one of the stalls while throughput drops. Do you think it is likely there are problems outside of MySQL here, for example with the I/O scheduler or filesystem journaling?
Sep
3
comment Performance difference between two MariaDB slaves
Some questions that might be relevant: Is there any power management or CPU frequency scaling (Intel Speedstep) enabled in the BIOS on the slow machine? Is the memory operating at the same frequency on both machines? Does the output of sysctl -a match?
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?