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)
27,021 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)
26,249 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)
45,038 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,370 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,344 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,671 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,625 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
14,170 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
22,237 reads
Blogs
Updates from Coping Tips
By Steve Jones
I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...
What I’ve learned in my first 100 days with a consulting group
By DesertDBA
In case you don’t follow me on LinkedIn or Twitter, your humble host joined...
Power BI as a enterprise data warehouse solution?
By James Serra
With Power BI continuing to get many great new features, including the latest in...
Forums
Server related questions
Hi, could someone answer the following questions please? I've googled of course but I'm...
MS SQL Server 2012 question regarding SSIS
OK so I have a customer with a hosted website with eCommerce options. Essentially...
What's your opinion about Google Cloud SQL?
Hi, I wonder what your opinion about Google Cloud SQL is! We are a...
Ask SSC