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,948 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)
25,049 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)
42,001 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,602 reads
2011-08-24
2,740 reads
Blogs
Power BI Monthly Digest – October 2020
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
Daily Coping 26 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Welcome to 3Cloud …
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Forums
Unique value constraint among active records
I have a lookup table that implements a system-generated Id for DRI purposes. The...
Textfield comparator.
A client would like to be able to recognize similar free-texts in a text...
Are there any free resources/ebooks to develop database design and modeling ?
I want to develop my skills in database design and modeling. I found...
Ask SSC