This article presents an easy method to get YTD data grouped by months in T-SQL.

Raw Materials - Four Nines

by Larry Gonick

SQLServerCentral.com

Raw Materials

Jill's cloud looks like a winner.

Physical Database Design Consideration

by Additional Articles

Database Journal

Database Design

There are lots of things to think about when you design a physical database. What data types should I use? What column is appropriate for the primary key? Are there particular indexes that I should use to improve performance? How should I implement data integrity rules? This list goes on and on. In this article Greg Larsen will be exploring different physical database design elements.

Jiggly Code

by Steve Jones

SQLServerCentral.com

Editorial

There should be some method to your madness when fixing code. At least, that's what Linus Torvalds thinks and Steve Jones agrees.

Testing times

by Tony Davis

SQLServerCentral.com

Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.

TSQL Challenge 74 - Find the expiring quantity of material

by Jacob Sebastian

SQLServerCentral.com

T-SQL Challenges

The challenge is to create a query for a report that show expiring material

Using the MERGE Statement in SSIS Via a Stored Procedure

by Nicholas C. Smith

SQLServerCentral.com

Step-by-step instructions how to build a stored procedure that dynamically constructs and executes a merge statement within SSIS.

Tom LaRock's SQL Server Howlers

by Additional Articles

SimpleTalk

Howlers

In this next article in our series where well-known SQL Server people write about their favorite SQL Server Howlers, we asked Tom Larock for his top five common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions.