Tag Info

New answers tagged

1

Based on the BOL article you referenced to, the date is not going to change unless a Service Pack or CU creates new system objects. However the date returned may not necessarily coincide with the date you install that CU or SP. The Resource database makes upgrading to a new version of SQL Server an easier and faster procedure. In earlier versions of ...


1

The main difference compared to the architecture of Data Pump utility exp / imp and expdp / impdp are always run on the DB server and not on a client. Then the files will always on the server where and active an Oracle database. The advantages of the data pump is performance (eg. Parallel) and the presence of new features' (eg. Migration direct SQL * Net, ...


0

I think just -- exporting db and taking out the json file and import in another system. Or You can directly copy the db from one location to another---- http://docs.mongodb.org/manual/reference/method/db.copyDatabase/


0

I Installed SQL Server 2014 Service Pack 1 (SP1) and that resolved the issue.


1

This error code [ORA-01654] means the server has failed to allocate an extent of the required number of blocks for an index segment in the specified tablespace. As you have said you have got 13 datafiles in your tablespace, you are using small file tablespace. In order to get rid of this error you can simply add data file using ALTER TABLESPACE ADD DATAFILE ...


0

If you are using a SQL editor like Toad, this script may help as well. You can copy/paste the results in a new window. SELECT DISTINCT 'GRANT Select ON TABLE ' || rtrim (tabschema) || '.' || rtrim (tabname) || ' TO USER USERNAME;' FROM syscat.tables WHERE tabschema = 'Schema' UNION SELECT 'GRANT Select ON VIEW ' || rtrim ...


1

In addition to someone doing full table locks, there are two other things that I can think of. If you have a table where there are several columns that have a parent child relationship to the same column in a child table and if the child column is not indexed, then indexing it could help. I had a case with an online content management system that had ...


2

Shrinking a log file isn't generally a good idea unless you've had a large amount of unexpected log file growth - otherwise it'll only grow again, and a log file that grows can cause performance problems. You can shrink a log file that's in any of the recovery models, but you won't always see the effect of it, as less of the file will be able to be shrunk - ...


0

The data of a temporary table is only visible for the same session (or transaction, depending on the temp table properties) that wrote the data.


1

My reason why to not to use innodb_file_per_table is performance. I did some tests for our database with 450 tables on mysql 5.5.45 Linux CentOS release 6.7 For unit tests which inserts fixtures into the database before each test (not using all tables everytime) and also tests itself does work with database a lot (inserts, update, deletes, selects) the ...


11

You need to give the database a valid owner. Use the ALTER AUTHORIZATION command to do this: ALTER AUTHORIZATION ON DATABASE::[DatabaseName] TO [A Suitable Login]; Related Knowledge Base article Note the sp_changedbowner system stored procedure has been deprecated in favour of ALTER AUTHORIZATION.


0

For the sake of it I'll describe an approach not mentioned above. It is typically used for temporal data. Not sure it will fit your needs, but here it goes. The idea is to have a copy of your original with two additional attributes, begin_time and end_time: create table ... ( ... , begin_time timestamp default now() not null -- MySQL timestamp deviates from ...


0

Deltas The data you are "snapshotting" -- how often does it change? I suggest looking into storing only the "deltas". When some piece of the snapshot does not change at all, the delta is empty, and you can store nothing. For reconstructing a snapshot at some point in the past, the processing is costly -- you need to walk through the versions, applying ...


0

Create a new table, that has all the columns of the existing table, but also a time column, which is set to the value of the time the snapshot was initiated. You're adding a new fact to store about an existing set of facts (each table should store one kind of fact, ideally). The value of the time column identifies each snapshot. If you need to query across ...


5

PostgreSQL relies on the operating system's disk cache for most caching. This cache is usually reported as "free" RAM by most tools, because modern operating systems use all but a little bit of the currently-free RAM for disk cache. This is normal. To confirm, use a better tool that shows buffers/cache separately from truly free memory. On Linux, free -m ...


1

Use something like SSDT to do a schema comparison on the before and after. Check this out: https://msdn.microsoft.com/en-us/library/hh272690(v=vs.103).aspx Note: This is only for the logins, obviously showing passwords isn't supported


1

You can start with the automatic reports: Right click your DB, go to Reports and Standard Reports https://technet.microsoft.com/en-us/library/cc280385%28v=sql.105%29.aspx You can also use perfmon https://msdn.microsoft.com/fr-fr/library/Aa645516%28v=VS.71%29.aspx


1

Yes there are DMV's for this like sys.dm_db_index_usage_stats, but that alone will not help in analyzing the unused databases. Here you can analyse on unused databases with help of SQL Server Audit as explained here by Aaron Bertrand When was my database / table last accessed? In addition you may need various other methods to track the database usage like: ...


0

You can send rs.stepDown(300) to the replicas on the SSD disks that you want as Secondary. Then they won't get chosen for the next 5 minutes. The replica on the HDD should be Primary when all the others step down. Also make sure that you can read from your secondaries with rs.slaveOK(). In case that your primary has problems, one of your secondaries will ...


11

If you create a database without specifying a file size, the size is mapped from model. You can see what this is by running: EXEC model.sys.sp_helpfile; -- on my system, size of primary data file -> 3264 KB Now, if I create a database just using CREATE DATABASE, I get an exact replica of those files. CREATE DATABASE [floob1]; GO EXEC ...


1

New databases are based on the Model db. It is possible to reduce the size of database and log files by shrinking, but this will likely severely fragment any existing indexes.


0

Your best bet to get some well researched guidance on this topic is to look up "Extract, Transform, and Load" processing, abbreviated ETL. ETL processing has been extensively studied, especially as it relates to data warehouses and data marts. Your reporting database is a little like a data mart. There are tools for this that you can buy and use off the ...


0

You can replicate Transaction to Reporting without any issues are it's "independent" but Reporting to Transactional may cause issues depending on your foreign-key settings. You can easily replicate single table with the help of replication filters (in your case replicate-do-table or replicate-wild-do-table). There are plenty of blogs for replication setup ...


2

Reasons for unexpected data growth of data files. "Data fragmentation" and data file preallocation When a document is deleted, it's space is used right away if the new document fits into that space. Let's say you delete a document which takes 1kb of disk space and a new document requiring 0.9 Kb of disk space is synced to disk, then the first free space ...


0

Database Administrators and Database Architects are similar. In crude terms, I would say that a database administrator approaches problems from a systems level (bottom up), while a relational data architect thinks from the perspective of the application and even user interface (top down). Both of of them share major responsibilities, including but not ...


3

The MCM videos are still available here: https://www.sqlskills.com/sql-server-resources/sql-server-mcm-training-videos/


1

That's not the fault of the history files. Quoting from the documentation link you referenced: Normally, recovery will proceed through all available WAL segments, thereby restoring the database to the current point in time (or as close as possible given the available WAL segments). Therefore, a normal recovery will end with a "file not found" message, ...


0

The best approach is to use a 3 member replica set. Periodically you will stop one of the secondaries, wipe the data directory and start it. The secondary will begin an initial sync which will remove all fragmentation since it will re-write all datafiles from scratch. Then do the same for the other secondary and perform a stepdown. The stepdown will ...


0

Not a performance gain, but multi-tenant architecture reduces hardware costs. http://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CEGJGEJH


0

If you wrote the query statically with all the passed values in the WHERE, and added OPTION (RECOMPILE), this will cause the optimiser to do parameter embedding. The redundant predicates will be stripped. Only the needed query operators will be in the plan. You are probably suffering the cost of a statement compilation with each invocation anyway. The ...


3

I would re-write the whole proc something like this..... ALTER PROCEDURE Member_WS @Program int = NULL, @Card nvarchar(30) = '', @Account nvarchar(128) ='', @Member bigint = NULL, @Email nvarchar(256) ='', @Phone nvarchar(20) ='', @ResponseType ...


0

Just delete ib_logfileX files and restart mysql service. You changed the innodb-log-file-size var to size more bigger than already set it in your mysql daemon.


3

There was a bug with commit_delay in PostgreSQL 9.4.X. It was just fixed, and the fix will appear in version 9.4.5. See the thread on the PostgreSQL mailing list: http://www.postgresql.org/message-id/CACKh8C-tDjQUceMQeG3BUSHS5AA35SjvCD6HgRm-Vj7x5rXmeQ@mail.gmail.com



Top 50 recent answers are included