- Dynamic Management Views - SQL Server Information at SQLTeam.com
The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. This article provides an introduction to DMVs and covers a few of the basic views and functions.
- SQL Server 2005 - SQL Server Integration Services - Loop Containers
Among features introduced in the SQL Server 2005 Integration Services are the For and ForEach loops, implemented in the form of containers that can be incorporated into the Control Flow part of a package design. Join Marcin Policht to learn about the For and ForEach loops.
2005 from all users