The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much. I found out about a concept called lightweight query execution … Continue reading
Tags: SQL Server
Related Articles
SQL Tuning – A close look at the 10053 CBO trace
This trace has been around for quite a while. I’m not sure when it first showed up but easily back to Oracle8i. This is the Cost-based Optimizer trace. This trace really tells you ‘why did the CBO pr...
Automation – Variables (Automation variables using datasets)
In Toad for Data Analysts 2.5 Automation Variables were added which greatly expanded what you could accomplish in an automation script. Variables can be used in almost every activity. This post lightl...
Video Series: Enabling Agile Database Development using Toad for Oracle
In this 10 part video series by John Pocknell, you will learn how to better enable agile database development using Toad for Oracle. Step 1: Setting up Team Coding with VCS integration Step 2:...