Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Paul White

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

An Introduction to Database Design

An introduction to database design for those people that might not understand what is involved.  Read more...
By Paul White 2013/01/11 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 24,968 reads

Inside the Optimizer: Constructing a Plan - Part 4

The final part in a series by Paul White exploring the internals of query optimization. Learn how   Read more...
By Paul White 2010/09/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,186 reads

Inside the Optimizer: Constructing a Plan - Part 3

Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.  Read more...
By Paul White 2010/09/14 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,156 reads

Inside the Optimizer: Constructing a Plan - Part 2

How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.   Read more...
By Paul White 2010/09/09 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 7,515 reads

Inside the Optimizer: Constructing a Plan - Part 1

Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.  Read more...
By Paul White 2010/09/07 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 12,319 reads

Optimising Server-Side Paging - Part II

The second part of this series compares four methods of obtaining the total number of rows in a paged data set.  Read more...
By Paul White 2010/05/24 | Source: SQLServerCentral.com | Category: paging
Rating: |  Discuss |   Briefcase | 8,202 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 20,773 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 34,845 reads

Optimising Server-Side Paging - Part I

This article by Paul White presents an optimisation for paging through a wide data set.  Read more...
By Paul White 2010/04/26 | Source: SQLServerCentral.com | Category: paging
Rating: |  Discuss |   Briefcase | 15,473 reads
   Items 1 to 9 of 9