By Bill McEvoy, 04/28/2009
The final lesson in the T-SQL 101 series shows you how to create and execute stored procedures that get data into and out of databases.
By Michael Otey, 04/25/2009
In the Community Technology Preview (CTP) for SQL Server 2008 SP1 you’ll find a couple of important changes in the way that service packs are applied and used as well as some ...
By Itzik Ben-Gan, 04/22/2009
Both the subquery and join solutions perform reasonably well for calculating running aggregates when you have very small partitions, but the join approach is best for calculating ...
By Anup Kafle, 04/22/2009
SharePoint can become an isolated data island--unless you use SQL Server Integration Services to integrate that data into SQL Server databases.
By Andrew J. Kelly, 04/16/2009
Most SQL Server DBAs wonder how many data files or filegroups they should have when they create a new user database. But they should be focusing on how to better utilize ...
By Shaunt Khaldtiance, 04/09/2009
Looking for an object in a SQL Server instance without knowing the object's exact name and the database in which it resides can be time-consuming. Here's a T-SQL stored procedure ...
By Michael K. Campbell, 04/02/2009
Here's an option if you're not satisfied with SQL Server Management Studio. With more features and smoother performance, it's a solid choice.
By Dino Esposito, 04/01/2009
Explore the workings of LINQ to SQL queries, then walk through examples of using LINQ to SQL to join and group data in .NET Framework applications.
By Denny Cherry, 03/10/2009
What you need to know about properly configuring your storage resources, and the storage solutions that work best with SQL Server.
By Michael Otey, 03/02/2009
Make the right SQL Server choice by checking out this list of SQL Server 2008 Express editions before you buy.
By Readers, 01/22/2009
Here's a utility that you can use to quickly find which columns have mismatched data types across tables in a SQL Server 2008 or SQL Server 2005 database. Correcting these columns ...