Thank you guys for Your replies

I can't imagine a scenario where any person is doing an analysis and needs to look at a million records at a time

Each row from...

Hello richykong ,

Thanks a lot for your reply

I have looked up on ASSP you were talking about and It has Solved my problem in obtaining detail level information for the...

Am trying to capture the result sets from stored procedures that are being used by the front end

All i can do is run the SP and store the result to...

Thanks a lot for ur replies.

1. I have tried Partitions on Table based on date and had an Non clustered index on UID column the performance was high when compared...

Thanks a lot Lowell

Its working and Now i have something to play around

Is there any way we can use Geometry instead of geography

My work around is Planar and geography...

Lowell,

Thanks for ur reply

Instead of using Insert statements.

I Need to insert the values from another Table

Something like

Declare @sql Varchar(max)

Set @sql = 'INSERT INTO SpatialDemo (SpatialData)

VALUES(''POINT('+Latitude+'+'...

Thanks alot WayneS n Gsquared

I will convert this as a function for my issue.