Tags » SQL Index

SQL SERVER - 2016 - Creating Additional Indexes with Clustered ColumnStore Indexes

Every version of SQL Server brings new capabilities that enhance the features that were introduced in the previous versions. I am sure the team is working based on the feedbacks given by customers as they starting using the new capability. 402 more words

SQL Authority

SQL SERVER - Basics ColumnStore FAQ - Part II

I wrote the first part of FAQ in here. This is not a typical blog post but more of a process oriented topic when working with ColumnStore Indexes. 797 more words

SQL Authority

SQL SERVER - ColumnStore Frequently Asked Queries

This blog talks about troubleshooting scenarios in FAQ format when dealing with ColumnStore Indexes inside SQL Server. Use a combination of trace flags, query hints, performance counters, extended events discussed in various blogs to gather relevant data and troubleshoot the problem. 770 more words

SQL Authority

Interview Question of the Week #040 - Difference Between Unique Index vs Unique Constraint

Question: What is the difference between unique index and unique constraint?

Answer:

Add Unique Constraint
ALTER TABLE dbo.<tablename> ADD CONSTRAINT
<namingconventionconstraint> UNIQUE NONCLUSTERED
(
103 more words

SQL Authority

Interview Question of the Week #039 - What is Included Column Index in SQL Server 2005 and Onwards?

You may find it interesting that not many people still know what is Included Index in SQL Server. I have seen it personally around me and also have seen at… 397 more words

SQL Authority

Interview Question of the Week #021 - Difference Between Index Seek and Index Scan (Table Scan)

Question: What is the difference between Index Seek and Index Scan?

Answer: Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. 244 more words

SQL Authority

Create a SQL index

Issue.

SQL Timeouts on ORDER BY in a SQL query.

A very simple query I was working on kept timing, the query had an ORDER BY on one of the columns, after a short while of googling I ended up having to create an index on the table I  was running the query against. 78 more words

SQL Inserts