Useful tips for everyday
How do you stop phantom reads? PHANTOM reads can be prevented by using SERIALIZABLE isolation level, the highest level. This level acquires RANGE locks thus…
What is contained database? A contained database is a database that is isolated from other databases and from the instance of SQL Server/ SQL Database…
How do I sum date criteria in Sumifs? Steps Type =SUMIFS( Select or type range reference that includes cells to add $H$3:$H$10. Select or type…
How do I create a database using sqlite3 in Python? Steps to Create a Database in Python using sqlite3 Step 1: Create the Database and…
What is nightly backup? Weekend and nightly backups are used to restore files that have been accidentally deleted or have become corrupted. Most organizations maintain…
What is partition wise join? A full partition-wise join divides a large join into smaller joins between a pair of partitions from the two joined…
How Save table after join in SQL? How do I save result of a join to another table? SELECT id INTO new_record_ids FROM new_table EXCEPT…
Can Excel import SQL Server? Import data directly into SQL Server from Excel files by using the Transact-SQL OPENROWSET or OPENDATASOURCE function. This usage is…
How do I display monthly salary in SQL? Step2 : After this We need to fetch only 2 columns from the Employee table.So following is…
How do you failover log shipping in SQL Server? To fail over to a secondary database: Copy any uncopied backup files from the backup share…