Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 9,399 total)

  • RE: Your Cloud Held Hostage – Could It Happen?

    djackson 22568 (4/6/2015)


    GoofyGuy (4/6/2015)


    If you host my data, and your building burns down, including all backups, I don't have any data. Therefore I don't own anything, you do, even if...

  • RE: Incorrect Syntax error. But the generated query is good

    Luis Cazares (4/6/2015)


    I'd completely remove the table variable (unless you use it somewhere else). And I would use the sys.databases view.

    SET NOCOUNT ON

    SELECT NAME,

    recovery_model_desc...

  • RE: Your Cloud Held Hostage – Could It Happen?

    GoofyGuy (4/6/2015)


    If you host my data, and your building burns down, including all backups, I don't have any data. Therefore I don't own anything, you do, even if you only...

  • RE: Today's Random Word!

    Eirikur Eiriksson (4/6/2015)


    Ed Wagner (4/6/2015)


    Eirikur Eiriksson (4/6/2015)


    Ed Wagner (4/6/2015)


    Revenant (4/6/2015)


    djj (4/6/2015)


    crookj (4/6/2015)


    djj (4/6/2015)


    Ed Wagner (4/6/2015)


    djj (4/6/2015)


    TomThomson (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    Revenant (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    TomThomson (4/4/2015)


    crookj (4/3/2015)


    djj (4/3/2015)


    House

    Cards

    pontoon

    Catamaran

    Sail

    Mast

    Pole

    Flag

    Wave

    WAC

    1978 (Disbanded)

    Grease

    Musical

    Broadway

    Night

    Opening

    Act

    Intermission

  • RE: Incorrect Syntax error. But the generated query is good

    Is this what you're after?

    SELECT name, state_desc

    FROM sys.databases

    ORDER BY name;

  • RE: Today's Random Word!

    Eirikur Eiriksson (4/6/2015)


    Ed Wagner (4/6/2015)


    Revenant (4/6/2015)


    djj (4/6/2015)


    crookj (4/6/2015)


    djj (4/6/2015)


    Ed Wagner (4/6/2015)


    djj (4/6/2015)


    TomThomson (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    Revenant (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    TomThomson (4/4/2015)


    crookj (4/3/2015)


    djj (4/3/2015)


    House

    Cards

    pontoon

    Catamaran

    Sail

    Mast

    Pole

    Flag

    Wave

    WAC

    1978 (Disbanded)

    Grease

    Musical

    Broadway

    Night

    Opening

  • RE: Question of the Day for 04 Jan 2007

    patricklambin (4/5/2015)


    Thanks for this question I faced unsuccessfully during an interview. The interviewer has taken time to explain the good answer.

    Only 3015 days old. I guess this is better...

  • RE: Question of the Day for 01 Dec 2006

    Eirikur Eiriksson (4/6/2015)


    patricklambin (4/5/2015)


    Thanks for this easy question because , to help a friend , I had to read both books from Kalen Delaney about the storage engine 2005...

  • RE: How to eliminate OR condition

    I would guess that the best solution is to create an index to cover the query. If you can't create them, who's in charge of the database? Someone...

  • RE: Today's Random Word!

    Revenant (4/6/2015)


    djj (4/6/2015)


    crookj (4/6/2015)


    djj (4/6/2015)


    Ed Wagner (4/6/2015)


    djj (4/6/2015)


    TomThomson (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    Revenant (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    TomThomson (4/4/2015)


    crookj (4/3/2015)


    djj (4/3/2015)


    House

    Cards

    pontoon

    Catamaran

    Sail

    Mast

    Pole

    Flag

    Wave

    WAC

    1978 (Disbanded)

    Grease

    Musical

    Broadway

  • RE: Hiding columns with all zero values in dynamic pivot query

    Sean Lange (4/6/2015)


    sunitkrishna (4/6/2015)


    Hi..

    Is there a way to hide all those columns with all zero values(zero value for all rows) in a dynamic pivot query?

    Sunitha

    Sure with a WHERE predicate? Or...

  • RE: update from oracle db

    Eirikur Eiriksson (4/6/2015)


    Cannot remember any issues although I've always "Staged and Explicit Convert" instead of relying on implicit conversions.

    It's been quite a while since I've had to convert data between...

  • RE: Your Cloud Held Hostage – Could It Happen?

    Andy, you raise some excellent points. While I don't know, my guess would also be that the facilities are not ready for a military-style attack. As we've seen...

  • RE: Today's Random Word!

    djj (4/6/2015)


    TomThomson (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    Revenant (4/4/2015)


    Eirikur Eiriksson (4/4/2015)


    TomThomson (4/4/2015)


    crookj (4/3/2015)


    djj (4/3/2015)


    House

    Cards

    pontoon

    Catamaran

    Sail

    Mast

    Pole

    Flag

    Wave

  • RE: Running Total Performance

    Jeff Moden (4/5/2015)


    Eirikur Eiriksson (4/5/2015)


    Jeff Moden (4/5/2015)


    Eirikur Eiriksson (4/5/2015)


    here is a partial testing code which strongly indicates that the original testing is somewhat flawed.

    Sorry... I don't have the time to...

Viewing 15 posts - 6,286 through 6,300 (of 9,399 total)