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,848 reads
Paul White
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)
24,660 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)
41,189 reads
2012-01-03
2,504 reads
2011-11-01
1,935 reads
2011-10-27
2,233 reads
2011-09-20
2,344 reads
2011-09-08
2,452 reads
2011-09-01
2,601 reads
2011-08-24
2,740 reads
Blogs
Creating a New Sequence–#SQLNewBlogger
By Steve Jones
I wrote about sequences in an editorial recently and decided to start using them....
An All Star Lineup for EightKB
By Steve Jones
An online conference is coming on June 17, 2020 that is full of high...
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...
Forums
Explanation of Page Splits
Q1 -- I have read quite a few articles on page splits and am...
Script error
I am trying to monitor the sql services on couple of instances and found...
Ask SSC