Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 2,838 total)

  • RE: What columns should be chosen when partitioning a table?

    kwoznica (4/13/2011)

    If I do add a column as you suggest can I put a contstraint on the table to update new records? I'm basically trying to avoid having to...

    --------------------------------------
    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 13, 2011 at 10:32 am

    #1311169

  • RE: What columns should be chosen when partitioning a table?

    kwoznica (4/13/2011)

    A Primary Key is a type of index, that's fine. You will have to change it so it uses both the column you want as your primary index and...

    --------------------------------------
    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 13, 2011 at 10:15 am

    #1311159

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/13/2011)

    Leave the contract early without notice and prior to completing the stated work.

    I've only left early if all the work is done and they're keeping me around "just 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 13, 2011 at 9:54 am

    #1311136

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/13/2011)

    How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?

    What do you mean by "walk out on"...

    --------------------------------------
    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 13, 2011 at 9:31 am

    #1311099

  • RE: Are the posted questions getting worse?

    Tom.Thomson (4/12/2011)

    Stefan Krzywicki (4/12/2011)

    I see SanDroid has started digging again...

    How deep can he dig before the heat makes him stop? Or do we have a new version of the...

    --------------------------------------
    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 12, 2011 at 12:24 pm

    #1310600

  • RE: Are the posted questions getting worse?

    WayneS (4/12/2011)

    Steve Jones - SSC Editor (4/12/2011)

    Stefan Krzywicki (4/12/2011)

    WayneS (4/12/2011)

    Stefan Krzywicki (4/12/2011)

    I see SanDroid has started digging again...

    Where?

    Still on your QOTD. bottom of the page and then on the next...

    --------------------------------------
    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 12, 2011 at 10:21 am

    #1310500

  • RE: Are the posted questions getting worse?

    Steve Thompson-454462 (4/12/2011)

    Stefan Krzywicki (4/11/2011)

    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....

    --------------------------------------
    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 12, 2011 at 8:48 am

    #1310435

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/12/2011)

    Stefan Krzywicki (4/12/2011)

    WayneS (4/12/2011)

    Stefan Krzywicki (4/12/2011)

    I see SanDroid has started digging again...

    Where?

    Still on your QOTD. bottom of the page and then on the next page.

    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 12, 2011 at 8:40 am

    #1310426

  • RE: Are the posted questions getting worse?

    WayneS (4/12/2011)

    Stefan Krzywicki (4/12/2011)

    I see SanDroid has started digging again...

    Where?

    Still on your QOTD. bottom of the page and then on the next page.

    I love when Gail is correcting someone about...

    --------------------------------------
    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 12, 2011 at 8:03 am

    #1310404

  • RE: Are the posted questions getting worse?

    I see SanDroid has started digging again...

    --------------------------------------
    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 12, 2011 at 7:27 am

    #1310377

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/12/2011)

    I think this cursor suits Stefan's needs best.

    DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING

    STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN

    FOR

    SELECT Superpower

    FROM dbo.JusticeLeague

    WHERE SupType = 'Lightning'

    OPEN OMG_NotAnotherCursor

    FETCH LAST FROM OMG_NotAnotherCursor

    ...

    --------------------------------------
    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 12, 2011 at 7:21 am

    #1310369

  • RE: Are the posted questions getting worse?

    Craig Farrell (4/11/2011)

    <-- I'd like everyone to meet Henry, a cute little feller with a penchant for petting mice with his tonsils. He's actually rather friendly when his owner...

    --------------------------------------
    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 1:36 pm

    #1310076

  • RE: Are the posted questions getting worse?

    GSquared (4/11/2011)

    Tom.Thomson (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...

    --------------------------------------
    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 1:14 pm

    #1310055

  • RE: Are the posted questions getting worse?

    Tom.Thomson (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 1:06 pm

    #1310049

  • RE: Are the posted questions getting worse?

    GilaMonster (4/11/2011)

    Executions of the query after the first are faster because the pages are in memory and the plan is in cache. I generally just run queries more than once...

    --------------------------------------
    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:35 pm

    #1310027

Viewing 15 posts - 1,906 through 1,920 (of 2,838 total)