This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…

This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…

This is part of a four part post series on SQL Joins and Applies. If you want to follow the examples given, you can get the T-SQL to create the tables, function and test data from my earlier…

Understanding INNER JOIN. The other posts in this series are: SQL Joins and Applies – Understanding CROSS JOIN SQL Joins and Applies – Understanding OUTER JOIN SQL Joins and Applies – Understanding APPLY This is part of a…

I’m writing a four part series on Joins and Applies in SQL. Below is the T-SQL to create the two tables and a function used to explain SQL Joins and Applies. –CREATE A TABLE VALUED FUNCTION –FUNCTION IS…

Did you know that simply setting the Database Recovery Model to BULK_LOGGED does not guarantee minimal logging when inserting? At the very least, for performance: Recovery Model should be set to BULK_LOGGED. Destination table should not be replicated….

After a few queries regarding my recent post on Covering Indexes, I decided to do a couple of tests to show you the results. Below are the actual execution plan results using the table structure and SQL query from…

Use WAITFOR to pause scripts while using minimal CPU overhead. WAITFOR TIME ’09:15′; –Wait until 9:15am   WAITFOR DELAY ’00:00:05′ –Wait for 5 secondsWAITFOR TIME ’09:15′; –Wait until 9:15am WAITFOR DELAY ’00:00:05′ –Wait for 5 seconds It is…