Useful tips for everyday
Is clustered index ordered? Clustered Index. A clustered index defines the order in which data is physically stored in a table. Table data can be…
How do I restrict column values in MySQL? MySQL CONSTRAINT is used to define rules to allow or restrict what values can be stored in…
Can we generate snapshot on merge replication for one? You can allow Subscribers to initiate snapshot generation and delivery and/or generate snapshots. Before generating snapshots…
Can we flush shared pool? Flush the Shared Pool ALTER SYSTEM FLUSH SHARED_POOL; It’s a really brutal thing to do as all parsed SQL will…
How do I make two columns in one row? Click in a cell, or select multiple cells that you want to split. Under Table Tools,…
What is mssql always on? The Always On availability groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.…
What is TID in PostgreSQL? A final identifier type used by the system is tid, or tuple identifier (row identifier). This is the data type…
Where do I put sbtest2.ibd in xtrabackup? XtraBackup copies the table file sbtest2.ibd in the backup directory (dbbackup_PS8_table/test) along with other files required to prepare…
How do you check if CDC is enabled on a table in SQL Server? You can verify if the table is enabled for CDC by…
How do you perform a load test in SQL Server? Starting the JMeter Test Download the Microsoft JDBC Driver for SQL Server. Unzip the driver…