Archive

Posts Tagged ‘T-SQL’

Database Splitting into different File-Groups


During the process of database optimization database administrators quite often face with optimization of low-level I/O system. As a result, they try to split a database between different Disks, RAID-s, LUN-s, etc., in order to scale I/O workload out. This process is known also as “Database Splitting” between several logical I/O units. Read more…

Advertisements

New T-SQL Features in SQL Server 2011


SQL Server 2011 (or Denali) CTP is now available and can be downloaded at http://www.microsoft.com

SQL Server 2011 has several major enhancements including a new look for SSMS. SSMS is now   similar to Visual Studio   with greatly improved Intellisense support.

This article we will focus on the T-SQL Enhancements in SQL Server 2011.

The main new TSQL features in SQL Server 2011 are: Read more…