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)
28,090 reads
An introduction to database design for those people that might not understand what is involved.
2013-01-11 (first published: 2011-01-18)
28,090 reads
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)
28,429 reads
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)
50,481 reads
The final part in a series by Paul White exploring the internals of query optimization. Learn how
2010-09-16
5,515 reads
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,428 reads
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,803 reads
Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.
2010-09-07
12,821 reads
The second part of this series compares four methods of obtaining the total number of rows in a paged data set.
2010-05-24
18,573 reads
This article by Paul White presents an optimisation for paging through a wide data set.
2010-04-26
27,348 reads
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
By Steve Jones
I had a suggestion from somone on a place where AI helps them and...
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Comments posted to this topic are about the item Does Version Control Scare You
Comments posted to this topic are about the item Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers