John Deardurff MCT
Classes Taught in 2018 Name Students Date 10987 Performance Tuning and Optimizing SQL Databases 15 2018-11-27 20768 Developing SQL Data Models 2 2018-11-19 20345-1 Administering…
Deardurff
Past SQL Posts
- December 13, 2016 | Restore vs Recovery
- April 2, 2016 | XML on SQL Tutorial
- December 5, 2015 | What are Locks?
- December 2, 2015 | Transactions and Errors
- December 1, 2015 | What are Transactions?
- November 30, 2015 | Working with Batches
- November 27, 2015 | Working with Schemas
- November 16, 2015 | SQL Four Part Names
- October 27, 2015 | SQL Query Processing
- August 24, 2015 | SQL COALESCE Function
- July 28, 2015 | The Output Clause
- July 23, 2015 | Delete vs Truncate vs Drop
- July 21, 2015 | IDENTITY Columns
- July 18, 2015 | Using the INSERT statement
- July 14, 2015 | Data Manipulation Language (DML)
- June 15, 2015 | SQL Join Types
- June 14, 2015 | DML Triggers
- June 10, 2015 | SQL Table Constraints
- June 7, 2015 | Working with SQL Tables
- June 4, 2015 | SQL Server Categories