Doing a dump and restore in the manner described will mean MySQL has to completely rebuild indexes as the data is imported. It also has to parse the data each time. It would be much more efficient if you could copy data files in a format MySQL already understands. A good way of doing this … Read more
select v.SQL_TEXT, v.PARSING_SCHEMA_NAME, v.FIRST_LOAD_TIME, v.DISK_READS, v.ROWS_PROCESSED, v.ELAPSED_TIME, v.service from v$sql v where to_date(v.FIRST_LOAD_TIME,’YYYY-MM-DD hh24:mi:ss’)>ADD_MONTHS(trunc(sysdate,’MM’),-2) where clause is optional. You can sort the results according to FIRST_LOAD_TIME and find the records up to 2 months ago.
I like SQuirreL SQL Client, and NetBeans is very useful; but more often, I just fire up the built-in org.h2.tools.Server and browse port 8082: $ java -cp /opt/h2/bin/h2.jar org.h2.tools.Server -help Starts the H2 Console (web-) server, TCP, and PG server. Usage: java org.h2.tools.Server When running without options, -tcp, -web, -browser and -pg are started. Options … Read more
DROP USER (or DROP ROLE, same thing) cannot proceed while the role still owns anything or has any granted privileges on other objects. Get rid of all privileges with DROP OWNED (which isn’t too obvious from the wording). The manual: […] Any privileges granted to the given roles on objects in the current database and … Read more
Try DBvisualizer from Minq Software … http://www.minq.se/products/dbvis/ It’s universal. It is Java based, and uses JDBC drivers to access just about any DB platform. It’s a very mature product, and has commercial and freebie. I liked it so much, I splurged for the licensed copy!
alter authorization on schema::[db_datareader] to [dbo] alter authorization on schema::[db_datareader] to [db_datareader] alter authorization on schema::[db_datawriter] to [dbo] alter authorization on schema::[db_datawriter] to [db_datawriter]
Here’s my top 10 interview questions for senior database administrators, and here’s Tom LaRock’s top 10 questions for junior DBAs. I’ve noticed other people suggest that the candidate should troubleshoot a server. If you take that approach, use a virtual machine with a snapshot. Set up a server a specific way with certain config or … Read more
The Fine Manual (which is well worth Reading) suggests that the effect of that statement lasts until a corresponding ALTER TABLE … ENABLE KEYS statement is executed.
Change the recovery mode of the database named “model”. From this MSDN doc: A new database inherits its recovery model from the model database. The default recovery model of the model database depends on the edition of SQL Server. But this can be changed by anyone that has ALTER permission on the database.
First, please read our canonical question on Capacity Planning. The specific advice you’re asking for is capacity planning advice, and you’re going to have to work that out on your own, for your particular environment. Second, You are looking at this wrong. The amount of memory (or any other resource) you have doesn’t dictate the … Read more