Forum Replies Created

Viewing 15 posts - 5,851 through 5,865 (of 9,399 total)

  • RE: Get database context from @@SPID() using DMV?

    graham.day 53003 (6/8/2015)

    Hi, the old way of obtaining database context from a session id (e.g. the code inside sp_who2) was to use something like

    SELECT dbid FROM master..sysprocesses WHERE spid =...

    June 8, 2015 at 6:13 am

    #1803629

  • RE: Disabling Indexes

    Good question. The answer made sense and seemed obvious to me, but I've had to restructure a few poorly-designed tables before.

    June 8, 2015 at 5:42 am

    #1803624

  • RE: Are the posted questions getting worse?

    TomThomson (6/5/2015)

    Alan.B (6/3/2015)

    TomThomson (6/3/2015)

    Luis Cazares (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    Lynn Pettis (6/2/2015)

    SMH...

    Why would the person who wrote the procedure ask on a public forum why his procedure is returning a value...

    June 8, 2015 at 5:34 am

    #1803622

  • RE: Today's Random Word!

    DonlSimpson (6/5/2015)

    Eirikur Eiriksson (6/5/2015)

    Monarchy

    Empire

    Republic

    June 8, 2015 at 5:22 am

    #1803619

  • RE: Should Salary Information Be Confidential?

    Lynn Pettis (6/5/2015)

    Eric M Russell (6/5/2015)

    Andy Warren (6/5/2015)

    Eric, I'd agree with that. But suppose there were two of you doing that. Same job, same skills. Virtual twins. Should they get...

    June 5, 2015 at 12:12 pm

    #1803435

  • RE: Today's Random Word!

    jasona.work (6/5/2015)

    ZZartin (6/5/2015)

    Ed Wagner (6/5/2015)

    jasona.work (6/5/2015)

    Ed Wagner (6/5/2015)

    Revenant (6/5/2015)

    SQLRNNR (6/5/2015)

    Ed Wagner (6/5/2015)

    BL0B_EATER (6/5/2015)

    SQLRNNR (6/5/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    tube

    subway

    Traffic

    Cone

    Ice Cream

    Float

    Pennywise

    :w00t:

    Stephen King (It)

    June 5, 2015 at 11:37 am

    #1803426

  • RE: Should Salary Information Be Confidential?

    What I make is between my employer and I. It's nobody's business except for the company, myself and (unfortunately) the IRS.

    June 5, 2015 at 11:36 am

    #1803425

  • RE: Unable to change a column from DATETIME to INT

    krismaly (6/5/2015)

    :-):-)

    You are fine

    You are helping

    :-):-)

    I hope you aren't changing your datetime to an integer so you can store your dates as MMDDYYYY instead of strong them as dates.

    I don't...

    June 5, 2015 at 11:34 am

    #1803423

  • RE: Today's Random Word!

    jasona.work (6/5/2015)

    Ed Wagner (6/5/2015)

    Revenant (6/5/2015)

    SQLRNNR (6/5/2015)

    Ed Wagner (6/5/2015)

    BL0B_EATER (6/5/2015)

    SQLRNNR (6/5/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    tube

    subway

    Traffic

    Cone

    Ice Cream

    June 5, 2015 at 11:17 am

    #1803413

  • RE: Help with date table

    ScottPletcher (6/5/2015)

    If they're always Mondays, why waste resources with table I/O at all? Very simple date arithmetic can tell you what the starting and ending dates are.

    You mean like...

    June 5, 2015 at 11:13 am

    #1803410

  • RE: Unable to change a column from DATETIME to INT

    krismaly (6/5/2015)

    My SSIS package has a Months column with 2 digit values but my table has Months column in Date datatype I want to convert

    That's the wrong data type. ...

    June 5, 2015 at 10:58 am

    #1803402

  • RE: Today's Random Word!

    Revenant (6/5/2015)

    SQLRNNR (6/5/2015)

    Ed Wagner (6/5/2015)

    BL0B_EATER (6/5/2015)

    SQLRNNR (6/5/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    tube

    subway

    Traffic

    June 5, 2015 at 10:51 am

    #1803400

  • RE: Today's Random Word!

    Eirikur Eiriksson (6/5/2015)

    Ed Wagner (6/5/2015)

    BL0B_EATER (6/5/2015)

    SQLRNNR (6/5/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    Donor

    Dasher

    June 5, 2015 at 9:38 am

    #1803362

  • RE: Today's Random Word!

    BL0B_EATER (6/5/2015)

    SQLRNNR (6/5/2015)

    Eirikur Eiriksson (6/3/2015)

    Ed Wagner (6/3/2015)

    Eirikur Eiriksson (6/3/2015)

    SQLRNNR (6/3/2015)

    while

    Loop

    Eliminate

    Kawasaki

    Yamaha

    piano

    Organ

    June 5, 2015 at 8:50 am

    #1803328

  • RE: Today's Random Word!

    BWFC (6/5/2015)

    crookj (6/5/2015)

    ChrisM@Work (6/5/2015)

    crookj (6/5/2015)

    Ed Wagner (6/5/2015)

    djj (6/5/2015)

    DonlSimpson (6/4/2015)

    Ed Wagner (6/4/2015)

    Revenant (6/4/2015)

    Ed Wagner (6/4/2015)

    djj (6/4/2015)

    Woolly

    Worm

    Hole

    Security

    Clearance

    Headroom

    Max

    Min

    nie mouse

    (Min) otaur

    Crete

    Island

    June 5, 2015 at 7:08 am

    #1803284

Viewing 15 posts - 5,851 through 5,865 (of 9,399 total)