Database Administrators Weekly Newsletter
Database Administrators Weekly Newsletter

Top new questions this week:

Why are mysql password hashes internally saved with a star (asterisk)?

I was reading upon some mysql internals, when going through the mysql.user table in the my mysql shell, I get mysql> select * from mysql.user limit 1 \G *************************** 1. row ...

mysql mysql-5.5 password  
asked by mu 無 5 votes
answered by RolandoMySQLDBA 4 votes

Select all records, join with table A if join exists, table B if not

So here's my scenario: I'm working on Localization for a project of mine, and typically I would go about doing this in the C# code, however I want to do this in SQL a bit more since I am trying to ...

sql-server t-sql sql-server-2014  
asked by EBrown 5 votes
answered by Aaron Bertrand 4 votes

Check if any of the values is in a subquery result

I have a complicated subquery that returns a list of order IDs. I need to get a list of customers who have these orders. The problem is that there are two ways of assigning a customer to an order (one ...

sql-server sql sql-server-2008-r2 subquery cte  
asked by user63844 5 votes
answered by Rob Farley 7 votes

Minimal grants for readonly single-table access on PostgreSQL

Following is a list of commands that seems to work to create new user (login) and grant readonly access for one specified table on PostgreSQL. Let's assume that these commands are executed on login ...

postgresql grants  
asked by WildWezyr 4 votes
answered by Daniel Vérité 1 vote

Auditing database administrator actions with SQL Server 2014 Standard

We have a requirement to audit database administrator access to customer databases - at a minimum, knowing which customer database they were accessing (and ideally why). Without upgrading to SQL ...

sql-server security audit  
asked by James Crowley 4 votes
answered by spaghettidba 2 votes

MySQL overhead of calling a Stored Procedure

Within Java, we access MySQL (v5.5.40) via JDBC -- a prepare statement, setting parameters then calling the stored procedure. It appears that every execute() has the overhead of 4 meta-calls (per ...

mysql mysql-5.5 stored-procedures jdbc  
asked by Debriter 4 votes
answered by RolandoMySQLDBA 1 vote

How to track DML events ocurred in the current day

I have the following query to track what tables are modified in the current date: SELECT TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, TIMESTAMP AS ...

oracle database-administration monitoring  
asked by Guillermo Nahuel Varelli 3 votes

Greatest hits from previous weeks:

How large should be mysql innodb_buffer_pool_size?

I have a busy database with solely InnoDB tables which is about 5GB in size. The database runs on a Debian server using SSD disks and I've set max connections = 800 which sometimes saturate and grind ...

mysql innodb  
asked by alfish 33 votes
answered by RolandoMySQLDBA 64 votes

What's the difference between a temp table and table variable in SQL Server?

This seems to be an area with quite a few myths and conflicting views. So what is the difference between a table variable and a local temporary table in SQL Server?

sql-server sql t-sql temp-tables  
asked by Martin Smith 232 votes
answered by Martin Smith 382 votes

Can you answer these?

Transactional Replication in SQL server 2014

We need to set up transactional replication in SQL server 2014, Enterprise edition so that: Database to be replicated from Publisher is approx. 2 TB in size. This would be used 24*6. Here we also ...

sql-server replication sql-server-2014 transactional-replication  
asked by KASQLDBA 2 votes

MS SQL Server IO read increase appear randomly

The number of read (IOPS) in my MS SQL Server database increased randomly even during the night (low activities) from 0.3 MB/SEC (normal) to 25-30 MB/SEC. After like 30 minutes, it's capped to 6 ...

sql-server sql-server-2012 performance  
asked by Julien 3 votes

MS SQL Parsing with XPath Performance

I have a UI that allows a user to select certain data points they want to filter the results by. There are things such as location, department etc. Once they have selected all of the options, I ...

sql-server sql-server-2008 t-sql stored-procedures execution-plan  
asked by SBB 2 votes
Subscribe to more Stack Exchange newsletters


Unsubscribe from this newsletter or change your email preferences by visiting your subscriptions page on stackexchange.com.

Questions? Comments? Let us know on our feedback site. If you no longer want to receive mail from Stack Exchange, unsubscribe from all stackexchange.com emails.

Stack Exchange, Inc. 110 William St, 28th Floor, NY NY 10038 <3