Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server
Search options not deleted
user 266135
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
-4
votes
To INCLUDE or Not INCLUDE in an Index
A filtered index with the 4 column needed, should avoid the "concatenation", the "key Lookup" and the "sort" steps shown in the Plan, improving query performance.
CREATE NONCLUSTERE INDEX CoverTest1 O …
- 13
2
votes
Large table with inactive records. Better performance to move inactive records?
If all the queries includes the active flag and your indexes support this filter, removing old records should not impact queries performance.
I've some DBs that work the same and removing some milion …
- 13
0
votes
Why would deleting a redundant index cause an application to perform unexpectedly?
I guess that @DanGuzman suggestions are the right path to follow:
resume the original indexes and validate correct behavior
remove duplicated/redoundant indexes and validate again
introduce new inde …
- 13