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,647 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)
23,487 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)
38,428 reads
2012-01-03
2,503 reads
2011-11-01
1,933 reads
2011-10-27
2,217 reads
2011-09-20
2,329 reads
2011-09-08
2,447 reads
2011-09-01
2,599 reads
2011-08-24
2,737 reads
Blogs
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Mini-Rant: Spoofed Phone Numbers and Trust
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Speaking at SQL Saturday Dallas
Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
SQL Server health check
If I want to do a SQL Server health check, which aspects should be...
CPU?Memory and IO bottleneck check
Which indices will show cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...
Ask SSC