Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"

Moderators

Top Categories · View All
TSQL Enhancements 28
Discontinued Features 16
SSIS Enhancements 10
SSMS Enhancements 10
Database Engine 10
Database Administration 8
Security 3
Full Text Search 2
DataTime 1
Breaking Changes 1

Browse by Tags · View All
Denali 82
SQL Server 2012 79
SSIS 9
SSMS Enhancements 9
Analytic Functions 8
Usability Enhancements 5
SQL11 4
TSQL 4
Security 3
Database Engine 3
Datetime 3
Query Hints 2
OVER Clause 2
DMV 2
Groups 2
Dynamic Management Functions 2
DMF 2
System stored procedures 2
DBA 2
FTS 2

Browse by Release · View All
All 58
RC0 20
SQL Server 2012 Denali 2
CTP3 2
SQL Server Denali 1

What is new in SQL Server 2012 - Denali

SQL Server 2012 Denali allows ONLINE index operations that involves Large Value Types

Dec 5 2011 1:02AM by Fazal Vahora   

The previous versions of SQL Server never allowed index operations (CREATE, DROP, REBUILD) on ONLINE mode, if the index includes a Large Value Type column (VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) etc).

Try running the following code in SQL Server 2008

-- Create a Table
CREATE TABLE Items (
    ItemID INT IDENTITY,
    ItemName VARCHAR(100),
    VarcharData VARCHAR(MAX)
)
GO

-- Create an Index
CREATE NONCLUSTERED INDEX [IDX_ItemIdxTest] ON [dbo].[Items] 
(
    [ItemID] ASC,
    [ItemName] ASC
)
INCLUDE ( 
    [VarcharData]
) WITH ( ONLINE = ON )
GO

The above code will produce the following error.

An online operation cannot be performed for index 'IDXItemIdxTest' because the index contains column 'VarcharData' of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml, or large CLR type. For a non-clustered index, the column could be an include column of the index. For a clustered index, the column could be any column of the table. If DROPEXISTING is used, the column could be part of a new or old index. The operation must be performed offline.

This limitation has been removed in SQL Server 2012 (Denali). The above code runs without an error in a SQL Server 2012 instance.

Read More Have you written a blog post or article related to this feature and want to get them added here? Read More...
Category : Database Engine
Release : SQL Server Denali
Tags : INDEX, ONLINE, Large Value Types, Performance, Scalability, SQL Server 2012, Denali


Fazal Vahora
21 · 9% · 2807
5



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server 2012 Denali allows ONLINE index operations that involves Large Value Types" rated 5 out of 5 by 5 readers
SQL Server 2012 Denali allows ONLINE index operations that involves Large Value Types , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]