Top Contributors

SQL Articles

Hi All

Below is a list of all the SQL Articles I've regularly used in questions.  If you are particularly proud of an article, please post it here.

Beware of Between - PortletPaul

In case it helps, SQL expert PortletPaul addresses this in his article Beware of Between.  An excellent read, and if it helped you click on the green 'Was this article helped you?' button at the end.

Table Joins Explained - chapmandew

For more reading on JOINs check out Tim Chapman's article SQL Server: Table Joins Explained!

Also to get your head wrapped around the different JOINS I recommend going to and search for 'SQL TABLE JOINS', and check out all the pretty cartoons on joins.

Comma-separate list as a parameter - angelIII

Here's an article called Delimited list as parameter: what are the options? that shows how to deal with comma-separated multiple values passed in a variable.
Rank: Genius

Expert Comment

Steve Wales2014-11-19 08:22 AMID: 134659

How to Shrink a Bloated Log File

This question appears 1 or 2 times a month - How to Shrink a Bloated Log File that explains why a transaction log file is growing out of control, steps you can take to reduce size and links to a few other articles talking about how to properly grow your log file to meet your transaction volume while keeping the correct number of Virtual Log Files in place.
Rank: Prodigy

Expert Comment

PortletPaul2014-11-19 11:17 PMID: 134850

SQL Server Date Styles (formats) using CONVERT()

I use this often: SQL Server Date Styles (formats) using CONVERT()