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 »