Home » SQL Tips

SQL Joins and Applies – Understanding APPLY

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…

Read More »

SQL Joins and Applies – Understanding OUTER JOIN

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…

Read More »

SQL Joins and Applies – Understanding CROSS JOIN

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…

Read More »

SQL Joins and Applies – Understanding INNER JOIN

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…

Read More »

SQL Joins and Applies – Test Data

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…

Read More »

High Performance Bulk Inserts into SQL – Considerations

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….

Read More »

Covering Indexes in SQL 2005 – Results

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…

Read More »

Low CPU Load Delays with SQL

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…

Read More »

Covering Indexes in SQL 2005

For some strange reason, covering indexes are not used or understood as much as they should. To quote Microsoft… “A Covering Index is a nonclustered index built upon all of the columns required to satisfy a SQL Server…

Read More »