<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
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,541 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,124 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,072 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,394 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,176 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
|
7,948 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
|
19,205 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
|
32,493 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
|
14,959 reads
Items 1 to 9 of 9
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
