Using CTEs Instead of Derived Tables
Steve dives into using CTEs instead of derived tables. What the benefit of CTEs Do CTEs over derived tables benefit performance? And a quick demo… Read More »Using CTEs Instead of Derived Tables
Derived Tables
Today’s Training: SQL Queries Section 1 Review
As part of our weekly free SQL Query Training, we have split the 70-461 curriculum into 4 sections to prepare everyone to take the certification… Read More »Today’s Training: SQL Queries Section 1 Review
Next Weekly Free SQL Training: A Review
We are currently about 25% of the way through the SQL Server 70-461 exam preparation class, which has been available through Google On Air Broadcasts… Read More »Next Weekly Free SQL Training: A Review
Weekly SQL Training – OUTPUT Clause and Derived Tables
The free SQL Server Queries weekly training is being presented by Steve Stedman and Aaron Buma. The name of the presentation started out as “OUTPUT Clause and… Read More »Weekly SQL Training – OUTPUT Clause and Derived Tables
Next Free SQL Query Training – OUTPUT Clause and Derived Tables
On Thursday Feb 19th at 9:00am pacific time, Aaron Buma and I will be doing another FREE SQL query training session. This is a free training… Read More »Next Free SQL Query Training – OUTPUT Clause and Derived Tables
Set Operators, Derived Tables and CTEs – Presentation downloads
Here is the agenda for this weeks free SQL training covering Set Operators, Derived Tables and CTEs – Presentation to prepare for the 70-461 exam: Set… Read More »Set Operators, Derived Tables and CTEs – Presentation downloads
SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next… Read More »SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs