Useful tips for everyday
Can index be duplicate values? Yes, you can create a clustered index on key columns that contain duplicate values. For example, you might decide to…
How do you add a new article to replication? Open SSMS, connect to the instance that is running the publication (source) that you want to…
Why use bulk-logged recovery model? The advantage of using the “Bulk-logged” recovery model is that your transaction logs will not get that large if you…
Why is Mysqldump so slow? Make sure you’re saving to storage local to the instance you’re running mysqldump on. Don’t save to remote storage. Also…
What is a corpus design? Summary. A corpus is not simply a collection of texts. Rather, a corpus seeks to represent a language or some…
How long does it take to select from sys.dm.index physical stats? When I do a select from sys.dm_db_index_physical_stats (Limited) on this table it takes ages…
What is Oracle memory? The Oracle Database In-Memory (Database In-Memory) feature set includes the In-Memory Column Store (IM column store), advanced query optimizations, and availability…
Can you join two tables without a common column? [&joins&]. Yes, [&you&] [&can&]! The longer answer is yes, there are a few ways to combine…
How does PG restore work in PostgreSQL database? The archive files are designed to be portable across architectures. pg_restore can operate in two modes. If…
Is asynchronous replication more effective than synchronous replication? Asynchronous replication requires substantially less bandwidth than synchronous replication. It is designed to work over long distances.…