I got my email about noon EST 🙂 l

Thanks!

Thanks

The data i have for City is: Long decimal(9,6), Lat decimal(9,6), Zipcode, Areacode.

Thanks

I copied what you provided in the above post.

Thanks

WOW, what an improvement !

From 3.2 seconds to 0.3 seconds 🙂

Many Thanks!

Plan as requested.

Thanks.

I have tried both ways.

Thanks

I added an image from the DB.

The same as last time.

Msg 15151, Level 16, State 1, Line 3

Cannot drop the partition function 'ifts_comp_fragment_partition_function_159848CA', because it does not exist or you do not have permission.

Msg 15151,...

SELECT

t.name AS TableName,

c.name AS FTCatalogName ,

i.name AS UniqueIdxName,

cl.name AS ColumnName

FROM

...

To delete a partition scheme

Click the plus sign to expand the database where you want to delete the partition scheme.

Click the plus sign to expand the Storage folder.

Click the plus...

SELECT t.name AS TableName, ps.name AS PartitionScheme,

ps.data_space_id, pf.name AS PartitionFunction, pf.function_id

FROM sys.TABLES t

JOIN sys.indexes i ON t.object_id = i.object_id

...

I partitioned a table some time ago to see if i could get any performance gains.

Since i did not, i deleted the table from the DB and the partitions from...

set statistics time on;

DECLARE @StartOfRange VARCHAR(MAX)

DECLARE @EndOfRange VARCHAR(MAX)

DECLARE @s-2 INT = '1';

DECLARE @e INT = '9';

DECLARE @OrderType VARCHAR(10) = 'asc';

DECLARE @OrderBy VARCHAR(50) = 'postalcode + cast(e.id as varchar(50))';

--DECLARE...