Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    GilaMonster (4/11/2011)

    Ok, had enough complaints about the lizard. Let's see if this is better.

    People complained about the lizard?

    Yes, I have a bunch of PMs on the topic....

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 12:30 pm

    #1310023

  • RE: Are the posted questions getting worse?

    GilaMonster (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    I'm likely using the wrong word. the metrics that are gathered by SQL Server to improve performance on subsequent runnings of a query. I knew the word...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 12:29 pm

    #1310021

  • RE: Are the posted questions getting worse?

    GilaMonster (4/11/2011)

    Ok, had enough complaints about the lizard. Let's see if this is better.

    People complained about the lizard?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 12:15 pm

    #1310015

  • RE: Are the posted questions getting worse?

    GilaMonster (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    I just don't want to wipe all statistics on the machine because other queries use them to improve performance.

    Errr, what statistics are you talking about and why...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 12:15 pm

    #1310014

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    GilaMonster (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 11:59 am

    #1310002

  • RE: Are the posted questions getting worse?

    GilaMonster (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing it to set based...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 11:40 am

    #1309994

  • RE: Are the posted questions getting worse?

    WayneS (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    CirquedeSQLeil (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    WayneS (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 11:30 am

    #1309986

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    WayneS (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible are listed? I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 11:10 am

    #1309969

  • RE: Are the posted questions getting worse?

    WayneS (4/11/2011)

    Stefan Krzywicki (4/11/2011)

    Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible are listed? I searched, but couldn't...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 11:01 am

    #1309961

  • RE: Are the posted questions getting worse?

    Can someone point me to one of the posts where the keywords to make a cursor run as fast as possible are listed? I searched, but couldn't find what I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 11, 2011 at 10:44 am

    #1309953

  • RE: Help with filling missing sequence numbering

    This article might help.

    Solving the Running Total and Ordinal Rank Problems[/url]

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 9, 2011 at 7:03 am

    #1309536

  • RE: Are the posted questions getting worse?

    It was very nice to meet you. Did you want my agency contacts so you can call them?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 8, 2011 at 7:55 pm

    #1309499

  • RE: Get storedProc result with parameters from a linked server

    One way is to create the query as a string, put it in a variable and execute the variable

    DECLARE @LinkedQuery varchar(500)

    DECLARE @NoDossier varchar(10)

    SET @NoDossier = '1315-21738'

    SET @LinkedQuery = 'SELECT RowID,...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 8, 2011 at 10:35 am

    #1309291

  • RE: Logged Operations

    GSquared (4/8/2011)

    SanDroid also sent me some inane private messages. Somehow, me not quoting "who guards the guards" in Latin (I wrote it in English) was wrong, referencing Plato in...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 8, 2011 at 10:09 am

    #1309278

  • RE: Are the posted questions getting worse?

    WayneS (4/8/2011)

    Kiara (4/8/2011)

    Frankly, I learn more when I get a QotD wrong than when I get it right. The points are meaningless - the knowledge, on the other hand, is...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 8, 2011 at 7:06 am

    #1309124

Viewing 15 posts - 1,921 through 1,935 (of 2,838 total)