OK, so it looks like in 2008 at least, the Spatial Index only supports STDistance in a WHERE clause - if I put an arbitrary maximum radius around each store...

Hi Grant,

Ok, I've just tried that and no change to the plan or speed. I think changing the densities isn't going to help if it can't produce a plan using...

Hi Grant,

Thanks, I'll have a read through your blog and see if I can find anything that'll help.

Yes, as with the test harness, I have a spatial index on...

Varun R (12/8/2011)

---

Thanks man. we already has a partition. There are 96 columns in the Table A.No triggers are there.DataTypes are not fairly designed.All Statistics are update.Is Merge operator will...

Not sure table partitioning would really be necessary with these volumes, although it's difficult to give any practical advice without more information.

Have a read through this article and provide at...

Bill Hansen (12/2/2011)

---

The only way a view would take up any resources is if it were indexed. In the case of an Indexed View you need enough disk space for...

Unless you're talking about indexed views, then no, they have no measurable effect on resource usage when not being used

Easy enough, Just use something like this to generate the statements:

--generate disable

SELECT 'exec msdb..sp_update_job @job_name = '''+NAME+''', @enabled = 0' FROM msdb..sysjobs

--generate enable

SELECT 'exec msdb..sp_update_job @job_name = '''+NAME+''', @enabled =...

The first reply from Gianluca has just such a template...

Cheers.

What I'm working on is an ERSI shapefile that doesn't contain points for postcodes, but Thiessen polygons, so I can't just do a lookup on point data, I need...

I'm working on a similar project at the moment and have most of the pieces of the puzzle in that there's a free ERSI shapefile for UK postcode boundaries and...

Remember to define a polygon, you must have a set of coordinates in order and in the correct ring orientation (e.g. anti-clockwise for this purpose), so you're going to find...

Sounds reasonable considering you only have 10 disks to play with. If it was me, I'd be asking for a couple more disks for the logs, so you could...

It's exactly the same:

http://msdn.microsoft.com/en-us/library/ms176102.aspx

From your expected results, DENSE_RANK() seems to be what you want to use (the same as RANK, but the rank number doesn't increment after ties):

SELECT DENSE_RANK() OVER

...