Useful tips for everyday
What is hash match in SQL Server execution plan? SQL Server Hash Match Aggregate operator is used to process the large tables that are not…
What is a data mirroring? Data mirroring is the process of replicating the contents of files that have been transferred into or modified within USB…
Can unique column have multiple NULL values in SQL Server? As per the ANSI, UNIQUE constraint allows multiple NULLs. But in the SQL Server, it…
How to delete data from partition table in oracle? It is easy to delete data from a specific partition: this statement clears down all the…
Can you install SQL Server 2012 on Windows 10? Install the .NET Framework 3.5 on Windows 10, Windows 8.1, and Windows 8. Some SQL Server…
How do I backup a SQL Server 2014 database? Expand Databases, right-click SQLTestDB , point to Tasks, and then select Back Up…. On the General…
Can you use an alias in a Case statement? The Case statement in SQL is mostly used in a case with equality expressions. The SQL…
What is latency in replication? Replication latency is the amount of time it takes for a transaction that occurs in the primary database to be…
What is index is the index performed on a column or table? An index contains keys built from one or more columns in the table…
How do I convert a table to CSV? You can also export a single table by: Right-click the table name in the object tree view.…