Tag Info

Hot answers tagged

4

Add a second column which will hold a hash of the text value. Create the index on the hash. Even if there is a hash collision there will be only a few rows to read and perform a full comparison on the text vlaues.


3

Since your problem is a conflict between constant updates and being able to run reports without facing deadlocks, I would recommend you consider using READ_COMMITTED_SNAPSHOT isolation set ON. This also has overhead, but usually prevents most deadlocking situations. (Nothing is magic, of course.) You should read the details at: ...


3

Apparently, you want to see constraint exclusion at doing its work. As in similar setups the parent table has no constraint (and, just to mention it, usually no rows), it will be always visited by queries on the parent table. Using your example schema, see the output: test=# EXPLAIN SELECT count(1) FROM p; QUERY PLAN ...


2

Let me start by mentioning that these 4 boundaries result in following 5 partitions. Partitions 1 and 5 are unbounded one one side and partitions 2, 3, and 4 are constrained to quarterly data: partition 1: values less than '2014-04-01' partition 2: values >= '2014-04-01' and < '2014-07-01' partition 3: values >= '2014-07-01' and < '2014-10-01' ...


1

I think you might be a bit confused about virtualization. Which virtualization platform are you using? I havent come across one yet that doesnt allow you to map the drives however you choose. There are default configs and settings that allow the hypervisor to decide how to best make use of the available host's resources, but I have never seen an offering ...


1

For very large Databases you can always use the compression method in SQL server 2012. That will help a lot in reducing down the backup size of the database: For how to use and more on this refer to below link: http://www.sqlservergeeks.com/sql-server-database-backup-compression-faster-disaster-recovery/ To avail the space, make sure you're backup ...



Only top voted, non community-wiki answers of a minimum length are eligible