Category: SQL Server

SQL Server Logical Query Processing summary

Usually I found some questions on the forums about that topic. For instance:

  1. “WHERE or HAVING?”
  2. “Is the ON clause more efficient than the WHERE clause?”
  3. “Why the field aliases cannot be used with the GROUP BY clause?”
These three questions are syntax oriented. Actually there are a lot of requests about subqueries, temporary objects, sort operations and so on. This kind of questions can be replied reading this logical process document (pdf). I love it and I share it everywhere, also when training in classes/on the job.
It is a LOGICAL workflow used by the Query Processor in order to generate the related PHYSICAL process for retrieving data.

Last Updates for SQL Server family

Just before the end of the 2012 the Microsoft SQL Server Sustained Engineering team released the following updates:

Cumulative Update #10 for SQL Server 2008 R2 Service Pack 1

Cumulative Update #4 for SQL Server 2008 R2 Service Pack 2

Cumulative update #5 for SQL Server 2012

Source: SQL Release Services Blog

 

This is a very short post and maybe not the right one to start with.. however, welcome to my new english blog!

If you want to watch my italian version, feel free to browse it 😉

I use to say..

Stay Tuned! 🙂