Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 1,493 total)

  • RE: Defrag MASTER and MSDB

    GilaMonster (10/13/2014)

    Master has no user tables (or shouldn't have any)

    Thanks! I had forgotten that I did a big no-no in June on the production instance and created a table in...

    October 13, 2014 at 1:15 pm

    #1752076

  • RE: Today's Random Word!

    Ed Wagner (10/13/2014)

    SQLRNNR (10/13/2014)

    djj (10/13/2014)

    SQLRNNR (10/13/2014)

    Danish

    Pastry

    creme

    Brulee

    Fire

    October 13, 2014 at 1:09 pm

    #1752072

  • RE: Today's Random Word!

    SQLRNNR (10/13/2014)

    Danish

    Pastry

    October 13, 2014 at 10:55 am

    #1752044

  • RE: Today's Random Word!

    Ed Wagner (10/8/2014)

    djj (10/8/2014)

    SQLRNNR (10/8/2014)

    Tang

    Space

    Star Trek

    Frontier

    October 8, 2014 at 12:57 pm

    #1751087

  • RE: Today's Random Word!

    SQLRNNR (10/8/2014)

    Tang

    Space

    (I cannot post my first thought):ermm:

    October 8, 2014 at 12:02 pm

    #1751073

  • RE: Today's Random Word!

    Ed Wagner (10/8/2014)

    crookj (10/8/2014)

    Sean Lange (10/7/2014)

    SQLRNNR (10/7/2014)

    sprite

    gremlin

    Pixie

    Dust

    Devil

    October 8, 2014 at 8:47 am

    #1751004

  • RE: Today's Random Word!

    Ed Wagner (10/7/2014)

    Daniel Bowlin (10/7/2014)

    djj (10/7/2014)

    Stuart Davies (10/7/2014)

    SQLRNNR (10/7/2014)

    Ed Wagner (10/7/2014)

    TomThomson (10/7/2014)

    whereisSQL? (10/7/2014)

    Ed Wagner (10/7/2014)

    crookj (10/7/2014)

    Ed Wagner (10/7/2014)

    BWFC (10/7/2014)

    Ed Wagner (10/7/2014)

    djj (10/7/2014)

    Ed Wagner (10/6/2014)

    whereisSQL? (10/6/2014)

    Sean Lange (10/6/2014)

    SQLRNNR (10/6/2014)

    geoduck

    Yummy!!!

    Delicious

    Taste

    Bud

    Spring

    Pogo

    Jump

    Rope

    Hang

    Tight

    Wad

    Shot

    bird

    flu

    Virus

    worm

    Wormhole

    black hole

    October 7, 2014 at 12:02 pm

    #1750730

  • RE: Conditionally select table names from sys.tables

    Sorry missed page 2.

    October 7, 2014 at 11:58 am

    #1750729

  • RE: Updating a table based on another table while avoiding null updates

    SQLTestUser (10/7/2014)

    I have a table that has be updated based on another table. To accomplish this I am updating the tables as below, which is fine when it finds a...

    October 7, 2014 at 11:48 am

    #1750726

  • RE: Why do they not listen?

    Finally someone listened. We had a meeting today and we are looking to revamp the entire phone number storage.

    Not because I suggested it, but a need for the client...

    October 7, 2014 at 11:44 am

    #1750724

  • RE: Today's Random Word!

    Stuart Davies (10/7/2014)

    SQLRNNR (10/7/2014)

    Ed Wagner (10/7/2014)

    TomThomson (10/7/2014)

    whereisSQL? (10/7/2014)

    Ed Wagner (10/7/2014)

    crookj (10/7/2014)

    Ed Wagner (10/7/2014)

    BWFC (10/7/2014)

    Ed Wagner (10/7/2014)

    djj (10/7/2014)

    Ed Wagner (10/6/2014)

    whereisSQL? (10/6/2014)

    Sean Lange (10/6/2014)

    SQLRNNR (10/6/2014)

    geoduck

    Yummy!!!

    Delicious

    Taste

    Bud

    Spring

    Pogo

    Jump

    Rope

    Hang

    Tight

    Wad

    Shot

    bird

    flu

    Virus

    October 7, 2014 at 9:32 am

    #1750630

  • RE: Today's Random Word!

    Ed Wagner (10/6/2014)

    whereisSQL? (10/6/2014)

    Sean Lange (10/6/2014)

    SQLRNNR (10/6/2014)

    geoduck

    Yummy!!!

    Delicious

    Taste

    Bud

    October 7, 2014 at 5:12 am

    #1750521

  • RE: Today's Random Word!

    Ed Wagner (10/5/2014)

    SQLRNNR (10/5/2014)

    piggery

    Gluttony

    Sloth

    October 6, 2014 at 6:04 am

    #1750275

  • RE: Today's Random Word!

    SQLRNNR (10/3/2014)

    Ed Wagner (10/3/2014)

    Pain

    Gain

    Grain

    October 3, 2014 at 8:42 am

    #1749995

  • RE: Return specific data from table

    How about something like

    WITH cte AS (

    select [name],

    [server],

    [speed],

    ROW_NUMBER () OVER(PARTITION by [NAME] order by [speed]) AS cnt...

    October 3, 2014 at 8:38 am

    #1749994

Viewing 15 posts - 1,216 through 1,230 (of 1,493 total)