The Basics of INCLUDE
Learn how the INCLUDE phrase of an index can change the performance of a query.
2019-10-10
6,513 reads
included columns
“Included columns” for non-clustered indexes explained
Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]
2019-09-17
5,040 reads
Covering Index using Included Columns
This article from Josef Richberg details the benefits of included columns for use in creating a covering index to improve performance.
2010-02-11
12,538 reads
Blogs
Improving TweetDeck with Better TweetDeck
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
Interview with Bob Ward
By damianwidera
This is the eight interview we have done. This time our guest is the...
SQL in the City Comes Back to Seattle
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
Forums
Refresh data warehouse with production data
Hello SSC, I want to create a package that refreshes the tables in my...
SSIS Deployment w params
<!--more-->Hi I have a simple package that exports data via ftp using a dynamic...
From cluster to single node
Hi all, We currently have a 2 node dev cluster which I need...
Ask SSC