Viewing 15 posts - 991 through 1,005 (of 1,468 total)
With no indexes to help it, SQL has to do a full table scan.
Add an index to B
Without the full query and table DDL, it is almost...
September 3, 2017 at 10:21 pm
August 30, 2017 at 6:27 pm
August 27, 2017 at 11:56 pm
August 25, 2017 at 7:14 am
As a wild stab ...
You could create a CLR that takes the data and creates a mail object. Then save that to a file ....
August 22, 2017 at 4:46 am
August 22, 2017 at 3:09 am
I stand to be corrected on the following statements. However, the 1 time that I have used partitions, I have found the same issue.
Partitions are not a GO...
August 20, 2017 at 10:25 pm
Ray K - Tuesday, August 15, 2017 2:16 PMSentence
Paragraph
August 15, 2017 at 10:05 pm
August 13, 2017 at 1:35 am
You could also create a schema per city, and create views that filter the data accordingly. Then grant the users access to the appropriate views.
August 8, 2017 at 6:21 pm
Viewing 15 posts - 991 through 1,005 (of 1,468 total)