Useful tips for everyday
How do you display non matching records from two tables? The second way to find non-matching records between tables is to use NOT in conjunction…
What happens during index rebuild in SQL Server? Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the…
How do I enable read committed snapshot isolation? You need to enable snapshot isolation by setting the ALLOW_SNAPSHOT_ISOLATION database option in order to use it.…
Can a clustered index also be an unique index? Clustering index is unique. Because clustered index puts data and index structure together, a table has…
How do I select in PostgreSQL? PostgreSQL SELECT statement syntax If you specify a list of columns, you need to place a comma ( ,…
Does SQL statements run sequentially? SQL Server can split singe query into multiple treads, but it will not run consecutive commands from one session in…
Does AlwaysOn require cluster? Introduction. SQL Server Always On is a flexible design solution to provide high availability (HA) and disaster recovery (DR). It is…
How does a full text search work in SQL Server? The SQL Server process uses the following components for full-text search: User tables. These tables…
How do I extract only the date from a string in Python? Given a string, the task is to write a Python program to extract…
How long does simple update take in MySQL? We are having trouble with simple updates on a single table taking a long time. The table…