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
Tags » SQL Index
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
Question: What is the difference between unique index and unique constraint?
Add Unique Constraint
ALTER TABLE dbo.<tablename> ADD CONSTRAINT 103 more words
<namingconventionconstraint> UNIQUE NONCLUSTERED
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
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 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