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,746 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,041 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)
39,830 reads
2012-01-03
2,503 reads
2011-11-01
1,934 reads
2011-10-27
2,226 reads
2011-09-20
2,337 reads
2011-09-08
2,449 reads
2011-09-01
2,601 reads
2011-08-24
2,740 reads
Blogs
Getting Started with SQL Prompt 10
By Steve Jones
This week we released SQL Prompt 10, which is an exciting milestone for us....
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Learn from the Troubles of Others
Comments posted to this topic are about the item Learn from the Troubles of...
Diskallignment questions ?
In the old days blocksize and disk allignment was important for the performance. For...
Ask SSC