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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 Search options user 6311

A database structure that can improve the speed of queries at the cost of disk space and slower inserts/updates. It stores a copy of one or more columns sorted but structures the data differently to allow faster access.

1
vote
1answer
GroupID UserID UserID Notes Amount GroupID IsComplete Foo has a unique index on Date+GroupID FooChild has a FK … to Foo, and a unique index on FooID+UserID, which includes Amount Bar has a unique index on Date+UserID+GroupID, which includes IsComplete Now I need to create a report showing the sum of all …
asked Dec 8 '14 by Shaul Behr
6
votes
2answers
I'm maintaining Somebody Else's Code. There's a stored procedure that's run once a day or week (depending on config), that migrates a bunch of records from an active table to an archive. But it's no …
asked Mar 14 '12 by Shaul Behr
8
votes
2answers
enough, the active table is actually using the correct index (plus a RID lookup?) but the archive table is doing a table scan! …
asked Apr 4 '12 by Shaul Behr
2
votes
1answer
profiler and found that 50.5% of the processing time is happening in a "Nested Loops (Inner Join)" step, which is joining a clustered index seek on a2_AssessmentQuestion (0.3%) and a clustered index … scan on the same table (13.1%). I confess I don't truly understand what this "nested loops join" is doing, but why would the query be doing a scan on the table right after doing an index seek, when the …
asked Jun 1 '14 by Shaul Behr
3
votes
I think the clue to the answer is in the remark in my question: But it's not a true archive, since there are several live processes that include the archive table in SQL queries. If the archiv …
answered Mar 15 '12 by Shaul Behr
22
votes
3answers
20 million-plus records without a clustered index. Now I want to create a clustered index on that table - but in my test environment my create index command has been running for an hour and it's … still not done. The customer site is a shop floor that works 24/7, and cannot afford an hour of down time while I create an index. Is there some less brute-force method of creating the index that will …
asked Jan 31 '12 by Shaul Behr
18
votes
4answers
to go through this rigmarole every time you so much as add a field to the INCLUDE list of an index. Moreover, it appears that you have to shut users out of the system in order to make any schema …
asked Sep 1 '14 by Shaul Behr
2
votes
1answer
have an index on their date field. Now, I want to create a view that has a full outer join between the two tables on the Date field, to show me the Foo value for that date (if there is one) along …
asked Dec 1 '14 by Shaul Behr