Forum Replies Created

Viewing 15 posts - 31 through 45 (of 567 total)

  • RE: RAISERROR Nulls?

    danielfountain (5/29/2014)

    Hey all,

    I have a try catch block.

    <snipped>

    What am i doing wrong to make the raiserror do this?

    Many thanks

    Dan

    Unfortunately, RAISERROR in a CATCH block doesn't work like you...

    May 30, 2014 at 1:55 pm

    #1717941

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/30/2014)

    wolfkillj (5/30/2014)

    jcrawf02 (5/30/2014)

    jasona.work (5/30/2014)

    The impression I've gotten is that they already have a contract with NASA to ferry crew, it's just been waiting for the man-rated capsule to be...

    May 30, 2014 at 8:58 am

    #1717813

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/30/2014)

    jasona.work (5/30/2014)

    The impression I've gotten is that they already have a contract with NASA to ferry crew, it's just been waiting for the man-rated capsule to be completed and...

    May 30, 2014 at 8:32 am

    #1717800

  • RE: STintersect with buff

    Eirikur Eiriksson (5/29/2014)

    wolfkillj (5/29/2014)

    Eirikur Eiriksson (5/28/2014)

    Quick thought, if the "signs" are points then I would have thought that the STContains function would be more appropriate.

    😎

    Except that the requirement was to...

    May 29, 2014 at 8:44 am

    #1717373

  • RE: STintersect with buff

    mickyT (5/28/2014)

    Johnny H (5/28/2014)

    Thank Jason this increased the speed 10 fold

    SELECT s.ID

    FROM v_sign s

    WHERE EXISTS (SELECT 1 FROM dbo.water w WHERE (geography::STGeomFromText(s.geometry.STAsText(), 4326).STBuffer(100).STIntersects(w.geography) = 1)

    Are you able to post up...

    May 29, 2014 at 8:29 am

    #1717367

  • RE: STintersect with buff

    Johnny H (5/28/2014)

    Thank Jason this increased the speed 10 fold

    SELECT s.ID

    FROM v_sign s

    WHERE EXISTS (SELECT 1 FROM dbo.water w WHERE (geography::STGeomFromText(s.geometry.STAsText(), 4326).STBuffer(100).STIntersects(w.geography) = 1)

    The speed increase most likely comes from...

    May 29, 2014 at 8:16 am

    #1717363

  • RE: STintersect with buff

    Eirikur Eiriksson (5/28/2014)

    Quick thought, if the "signs" are points then I would have thought that the STContains function would be more appropriate.

    😎

    Except that the requirement was to determine which signs...

    May 29, 2014 at 8:09 am

    #1717360

  • RE: Catch Block: Variables vs System Functions?

    autoexcrement (5/27/2014)

    I am creating a single stored procedure to log errors from within the CATCH blocks in my code.

    I notice that in most of the code examples I've seen,...

    May 28, 2014 at 11:43 am

    #1717104

  • RE: Advice sought....populating a DEV copy of the database

    RedBirdOBX (5/28/2014)

    Thanks everyone. After some trail an error, I was able to create a SP that does most of what I want it to. It's a whopper as...

    May 28, 2014 at 11:13 am

    #1717100

  • RE: STintersect with buff

    Johnny H (5/27/2014)

    Here is what I have tried. Setting GEOMETRY to GEOGRAPHY, then a inner join, I have also tried with a union with the same error results.

    DECLARE @sign...

    May 28, 2014 at 10:27 am

    #1717083

  • RE: Are the posted questions getting worse?

    J Livingston SQL (5/24/2014)

    Jo Pattyn (5/24/2014)

    Welkom back wolfkillj, could you fix the link to your blog? It points to the thread.

    http://sqlsouth.wordpress.com/2014/05/23/export-xml-from-sql-server-using-bcp/

    Thanks for the temporary fix - I fixed the link...

    May 27, 2014 at 10:33 am

    #1716760

  • RE: Are the posted questions getting worse?

    Wow - I have been away from the thread for a long time. I've been busy at work with an avalanche of new projects and improvements to existing process. One...

    May 23, 2014 at 3:57 pm

    #1716273

  • RE: Are the posted questions getting worse?

    GilaMonster (3/14/2014)

    wolfkillj (3/14/2014)

    wolfkillj (3/13/2014)

    GilaMonster (3/11/2014)

    Koen Verbeeck (3/11/2014)

    Grant Fritchey (3/11/2014)

    By the gods, people get hung up on the weirdest darned things. They can focus like a laser on stuff that's just...

    March 14, 2014 at 2:43 pm

    #1697327

  • RE: Assistance with Partition-level locking and X lock on UPDSTATS

    I wonder whether this might have something to do with a read-ahead or prefetch operation. I'm testing some theories and will post results later.

    March 14, 2014 at 2:42 pm

    #1697324

  • RE: Really need help with query taking longer after backup!

    william.rees.howells (3/13/2014)

    Hi again,

    I have found out what the problem was. Basically it boils down to me now using CHECKPOINT. I think that the following is what was happening:

    1) INSERT DATA

    2)...

    March 14, 2014 at 10:03 am

    #1697201

Viewing 15 posts - 31 through 45 (of 567 total)