Cross Join
The CROSS JOIN joined every row from the first table (T1) with every row from the second table (T2). In other words, the cross join returns a Cartesian product of rows from both tables. In general, if the first table has n rows and the second table has m rows, the cross join will result in n... » read more
SQL to Open XML file
SQL to retrieve content of xml file.
TRUNCATE vs DELETE
Use TRUNCATE instead of DELETE If you need to clear the data in a table, use TRUNCATE instead of DELETE. TRUNCATE lock the table instead of at each row. No triggers are activated and no logs are generated resulting in faster performance. Note: TRUNCATE TABLE will reset your identity to the initial seed, whereas DELETE... » read more
Sql Not Exist
The following SQL Server Not Exists query will find the Employees whose Occupation is neither Skilled Manual nor Clerical. Sources: https://www.tutorialgateway.org/sql-not-exists-operator/
Stop Using PRINT to Track Query Progress
Stop using PRINT. Start using RAISERROR. PRINT PRINT with GO RAISEERROR with NOWAIT Source:
SQL Server: Lead vs Lag
The LAG function has the ability to fetch data from a previous row, while LEAD fetches data from a subsequent row. Sources: