By Microsoft's SQL Server Development Team, 08/23/2006
Microsoft’s Patrick Conlan explains a design philosophy in SQL Server 2005.
By Microsoft's SQL Server Development Team, 08/23/2006
Microsoft’s Richard Waymire helps a reader locate an instance of SQL Server 2005 Express.
By Microsoft's SQL Server Development Team, 08/23/2006
Microsoft’s Richard Waymire gives a method for moving server registration information between client machines.
By Microsoft's SQL Server Development Team, 07/20/2006
Microsoft’s Gert Drapers provides a script that creates backup filenames that display the date and time of the backup, complete with leading zeros for easy reading.
By Microsoft's SQL Server Development Team, 07/20/2006
Microsoft’s Patrick Conlan gives tips on how to maintain good performance when executing distributed queries between SQL Server instances.
By Microsoft's SQL Server Development Team, 06/22/2006
Microsoft’s Gert Drapers explains techniques for getting valuable information from SQL Server’s msdb backup tables.
By Microsoft's SQL Server Development Team, 05/23/2006
Microsoft’s Vaquar Pirzada explains how to use the sp_scriptdynamicupdproc stored procedure to include Identity field values in transactional replication.
By Microsoft's SQL Server Development Team, 05/23/2006
Microsoft’s Vaquar Pirzada gives you options for performing very large set updates in SQL Server 2000.
By Microsoft's SQL Server Development Team, 03/22/2006
Microsoft’s Gert Drapers explains how to execute statements in the context of a user database.
By Microsoft's SQL Server Development Team, 02/22/2006
Microsoft’s Patrick Conlan explains how C# DLLs will work with the CLR in SQL Server 2005.
By Microsoft's SQL Server Development Team, 02/22/2006
Microsoft’s Patrick Conlan gives a brief explanation of database snapshots.
By Microsoft's SQL Server Development Team, 02/22/2006
Microsoft’s Gert Drapers provides a script for retrieving table information.
By Microsoft's SQL Server Development Team, 01/25/2006
Microsoft's Richard Waymire explains a truncating feature in SQL Server 2000.
By Microsoft's SQL Server Development Team, 01/25/2006
Microsoft's Gert Drapers and Patrick Conlan provide a couple of ways you can use SQL-DMO to check code syntax.
By Microsoft's SQL Server Development Team, 01/25/2006
Microsoft's Gert Drapers provides statements for finding an individual database log file.
By Microsoft's SQL Server Development Team, 12/20/2005
Microsoft's Patrick Conlan explains how to make an Oracle trigger work in SQL Server 2000.
By Microsoft's SQL Server Development Team, 11/02/2005
Microsoft's Patrick Conlan offers two ways to rotate a table in SQL Server.
By Microsoft's SQL Server Development Team, 11/02/2005
Microsoft’s Gert Drapers shows how to use T-SQL to check a database’s memory usage.
By Microsoft's SQL Server Development Team, 09/20/2005
Microsoft's Patrick Conlan comes up with a hatful of tricks to performance-tune a simple query that won't perform.
By Microsoft's SQL Server Development Team, 06/22/2005
Microsoft's Thierry D'hers describes the steps for getting a string to show up in analysis cubes.