Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 149, comments - 1922, trackbacks - 64

My Links

Home Contact RSS 2.0 Feed Login

SQLTeam.com Links

SQLTeam.com Articles SQLTeam.com Weblog SQLTeam.com Forums

News

Welcome to my weblog. My name is Jeff Smith, and I am a software developer in Boston, MA. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe

Archives

August, 2008 (3) July, 2008 (3) June, 2008 (3) May, 2008 (4) April, 2008 (2) March, 2008 (2) February, 2008 (9) January, 2008 (3) December, 2007 (3) November, 2007 (2) October, 2007 (8) September, 2007 (4) August, 2007 (5) July, 2007 (11) June, 2007 (8) May, 2007 (10) April, 2007 (12) March, 2007 (7) January, 2007 (1) July, 2006 (4) June, 2006 (2) April, 2006 (3) March, 2006 (2) February, 2006 (1) December, 2005 (2) November, 2005 (3) September, 2005 (1) May, 2005 (5) April, 2005 (1) December, 2004 (2) November, 2004 (4) October, 2004 (2) September, 2004 (1) July, 2004 (1) June, 2004 (1) May, 2004 (1) March, 2004 (1) January, 2004 (1) December, 2003 (3) November, 2003 (4) October, 2003 (2) September, 2003 (2)

Post Categories

.NET (C# / VB) (rss) ASP (rss) ASP.NET (rss) Code Library - ASP.NET (rss) Code Library - C# / VB.NET (rss) Code Library - SQL (rss) CrossTabs / Pivoting Data (rss) Database Design (rss) DateTime Data (rss) Efficiency (rss) GROUP BY (rss) Humor (rss) Imports/Exports (rss) Joins/Relations (rss) Links (rss) Miscellaneous (rss) MS Access (rss) Paging Data (rss) Report Writing (rss) Reporting Services (rss) Security (rss) Sports (rss) SQL Server 2005 (rss) SQL Server 2008 (rss) Techniques (rss) T-SQL (rss)

Programming

MSDN - .NET Framework The DailyWTF

Sports

Baseball Reference.com Baseball Stats Database Red Sox Foundation

SQL

Microsoft SQL Server Microsoft TechNet - SQL SQL Server Express WebLog SQLBog.com

December 2007 Entries

Simplify Your SQL with Variables and Derived Tables (or Common Table Expressions)

As with any programming language, it is important in SQL to keep your code short, clear and concise. Here are two quick tips that I find are very helpful in obtaining this goal.

posted @ Thursday, December 20, 2007 12:20 PM | Feedback (6)

SELECT DISTINCT and ORDER BY

posted @ Thursday, December 13, 2007 2:58 PM | Feedback (14)

SQL Server Express Automated Backups

posted @ Thursday, December 06, 2007 3:10 PM | Feedback (1)

Powered by:
[image] [image]

Copyright © Jeff Smith

You are viewing a mobilized version of this site...
View original page here

Mobilized by Mowser Mowser