New answers tagged

0

A possibly simple way is replacing all MS-Access tables with links to views in your SQL Server with the exact same structure as the old Access tables. If the views are simple enough (e.g. a select statement from a single table with a primary key and unmodified columns -other than renaming them-) they'll be directly updatable, otherwise you can use updatable ...


0

SQL doesn't support database files on SMB prior to 2012. Otherwise it would be possible but not recommended. Your priority should be regular backups of system and user databases, which can be done to an SMB share (best way to do it actually!)


0

To be honest, I wouldn't want my database on a NAS as it is most likely accessed throughout the office and it is also very vulnerable as everyone connects to it. Ideally, your SQL database should be hidden in the deepest parts of your network. However, I seeing how this doesn't sound like a high end operation, I would see if they can give you the money to ...


1

The question comment guess by jerichorivera was absolutely right: log-slaves-updates on node1 enabled? ..but you seem to have misunderstood. log_bin=/var/log/mysql/mysql-bin (or whatever file basename) to enable writing the binary logs a slave can read from. However, this alone lets the node write empty binary logs (a size of a few hundred bytes) if ...


1

See this example query for getting these execution plans. Now it's ordered by CPU consumption: SELECT qs.execution_count, qs.total_worker_time/1000 total_worker_time_msec, ((qs.total_worker_time/1000)/qs.execution_count) AVGtotal_worker_time_msec, qs.max_worker_time/1000 max_worker_time_msec, qs.total_elapsed_time/1000 ...


4

You would just pull the execution plans for the most relevant queries from the plan cache. I would query sys.dm_exec_query_stats, and join to sys.dm_exec_query_plan and sys.dm_exec_sql_text to get the plan and query text, respectively. Within sys.dm_exec_query_stats you can pull queries with the highest IO, CPU, execution count, etc. - whatever is most ...


3

Pay attention that the correct time zone (UTC in your case) is applied during the conversion. If are not explicit about this, the time zone of the current session is assumed - typically not UTC. ALTER TABLE tbl ALTER ts_column TYPE timestamptz USING ts_column AT TIME ZONE 'UTC'; Check a possible column default for sanity. Any explicit timestamp expression ...


0

PostgreSQL's MVCC is used over-writing mechanism, which is roughly mentioned to this document , so all updated rows are inserted into the table. Thus, you cannot get free space. On the contrary, the table size is temporarily increased. (Even though autovacuum feature works very efficiently,) I think you have to do VACUUM FULL in order to certainly remove ...


0

So I found there is a better way: you go through the API. I got the idea from this answer: http://stackoverflow.com/a/35182348/2933397 You need to access the keyspace metadata directly. So an example of how to access the schema metadata is here: Cassandra CPP driver: UDF Metadata The idea is to obtain a pointer to a CassSchemaMeta object, then you have ...



Top 50 recent answers are included