SQL Server 2005: INCLUDE argument with Nonclustered Indexes.


There is a new INCLUDE argument available in SQL Server 2005 when creating nonclustered indexes. According to the MSDN documentation, INCLUDE is used to: Specify the nonkey columns to be added to the leaf level of the nonclustered index. In a nutshell, this new clause allows us to better target columns we need in a …

Some New Books – bring on the learning…


I bought two new books today: Inside Microsoft SQL Server 2005: T-SQL Querying and Inside SQL Server 2005: T-SQL Programming, both by Itzik Ben-Gan. I spent a morning in one of his Black Hat SQL sessions a few years ago and have been following his works ever since. I've started with T-SQL Querying as it's …

RC1 of .NET 3 and Windows SDK Available


Hidden behind the Windows Vista RC1 release, we at last have a new release of the development bits. All the information you need is here. Best of all, the number of samples have been increased dramatically over previous releases. Quick Links:Microsoft .NET Framework 3.0 - Release CandidateVS2005 Extensions for Windows® Workflow Foundation Release Candidate 5Windows …

Building your solutions using MSBuild – Part 1


Many people seem to be afraid of the angled brackets that accompany MSBuild and tend to avoid it. This is a pity as MSBuild can be as simple or complex as you want to make it. The beauty of the tool is that it's kinda like Lego; you build it bit by bit, enhance it, …