The number of new features and functionality coming into SQL Server exceeds those that are being removed and deprecated. This increases the need for database administrators (DBAs) to continually learn new features and eventually manage them in a production environment. The makers of SQL Server realize this imbalance, and with each new release of SQL Server, they supply a bevy of new Transact-SQL (T-SQL) commands to make the jobs (and lives) of DBAs easier and working with the database system more efficient.
KeywordsPartition Function Query Optimizer Partition Scheme Current Database Query Plan
Unable to display preview. Download preview PDF.