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 - FORCESEEK hint is extended to specify columns used to seek in the specified index

Dec 20 2011 3:15AM by Ramireddy   

When SQL Server chooses seek over scan while retrieving record details, it will compare key value with search input, based on comparison result, Query engine will move to appropriate page. Suppose, index has multiple columns, if we don't want all key columns to consider, in SQL Server 2012, we can mention the index columns to consider when the index has multiple key columns. .

SELECT CompanyID,CompanyName,Amount
FROM COMPANIES 
WITH (FORCESEEK(Idx_Company(CompanyID)))
WHERE CompanyID = 1

Read More Have you written a blog post or article related to this feature and want to get them added here? Read More...
Category : TSQL Enhancements
Release : All
Tags : SQL Server 2012,Denali,Query Hints,ForceSeek


Ramireddy
2 · 41% · 12972
4



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server 2012 - FORCESEEK hint is extended to specify columns used to seek in the specified index" rated 5 out of 5 by 4 readers
SQL Server 2012 - FORCESEEK hint is extended to specify columns used to seek in the specified index , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]