The Basics of INCLUDE
Learn how the INCLUDE phrase of an index can change the performance of a query.
2019-10-10
7,670 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
6,493 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,553 reads
Blogs
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Running SQL Server in Google Cloud Platform
By Daniel Janik
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...
More ADLS Gen2 enhancements
By James-Serra
On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...
Forums
Copy Azure SQL DB App data to Azure Synapse
Hello, I am looking for the best way to copy change data from my...
Enable normal user to execute a sys stored procedure
I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the...
Enable user to execute a sys stored procedure
I am struggling to enable a user to be able to execute a system...
Ask SSC