An Introduction to Database Design
An introduction to database design for those people that might not understand what is involved.
2013-01-11 (first published: 2011-01-18)
25,980 reads
Paul White
- Website: https://sql.kiwi
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.
2012-01-13 (first published: 2010-04-19)
25,142 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.
2012-01-06 (first published: 2010-04-12)
42,193 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
2010-09-16
5,285 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.
2010-09-14
6,281 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.
2010-09-09
7,655 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.
2010-09-07
12,561 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.
2010-05-24
11,410 reads
Optimising Server-Side Paging - Part I
This article by Paul White presents an optimisation for paging through a wide data set.
2010-04-26
19,543 reads
Blogs
Daily Coping 26 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Greatest and Least TSQL
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
T-SQL Tuesday Retrospective #005: Reporting
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....
Forums
Large Database Files
Comments posted to this topic are about the item Large Database Files
Black Friday Wishes
Comments posted to this topic are about the item Black Friday Wishes
Reporting Services Subscription: Special character in email address
Hi How can an email address containing a special character (in this case, an...
Ask SSC