none
SQL Azure Not completing commands. RRS feed

  • Question

  •  For some reason I had to break this down into small pieces or it never completed. The table had 7M records.  It could handle a selection of 2M at a time but somewhere above 2.5M it would choke. Is it creating a giant transaction and running out of buffer?

    UPDATE dbo.location
    SET geoPoint = geography::Point(RooftopLatitude,RooftopLongitude, 4326)
    WHERE geoPoint is null

    The following also never returns.  Is there any way to break the creation of an index down into bite sized chunks SQL Azure can handle?

    CREATE SPATIAL INDEX idxGeometryIndex ON dbo.location ( geoPoint )
    USING GEOGRAPHY_GRID
    WITH (GRIDS =(LEVEL_1 = MEDIUM,LEVEL_2 = MEDIUM,LEVEL_3 = MEDIUM,LEVEL_4 = MEDIUM), CELLS_PER_OBJECT = 16, DROP_EXISTING = OFF)

    • Moved by Brad Calder Saturday, March 26, 2011 6:23 PM SQL question (From:Windows Azure Storage)
    Wednesday, December 1, 2010 2:31 PM

All replies

  • Is there any error message? Could you try to use a simple select query to test the tabel, for example returning the whole table. You may also need to check the locks on this table.

    Thursday, December 2, 2010 7:00 AM