Forum Replies Created

Viewing 15 posts - 5,956 through 5,970 (of 8,761 total)

  • RE: Virtualizing SQL Server 2008R2

    Quick thought, if the license was bought under the Processor (SQL Server 2008 R2 and earlier) then the core count is (almost) irrelevant. Theoretically you could have as many cores...

    March 24, 2015 at 3:29 pm

    #1786131

  • RE: sp_MSForEachDB

    Quick thought, I reject any code using either sp_MSforeachdb or sp_MSforeach_worker as these do not meet the standards I'm enforcing, for fun, have a look at the code

    😎

    /*

    * The...

    March 24, 2015 at 3:17 pm

    #1786124

  • RE: The Worst Comments

    Eric M Russell (3/24/2015)

    The worst comments are where someone has /* commented */ out blocks of code, sometimes pages and pages, with no explanation for when or why.

    Makes one think...

    March 24, 2015 at 3:09 pm

    #1786122

  • RE: The Worst Comments

    Wayne West (3/23/2015)

    Jeff Moden (3/22/2015)

    Steve Jones - SSC Editor (3/16/2015)

    Eirikur Eiriksson (3/13/2015)

    Digressing slightly, how would the threadizens describe the optimal code comments? Obviously the opposite of that would be the...

    March 24, 2015 at 2:45 pm

    #1786114

  • RE: Today's Random Word!

    TomThomson (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    djj (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    Revenant (3/24/2015)

    whereisSQL? (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Cat

    Caterpillar

    Butterfly

    Effect

    Hurricane

    storm

    teapot

    Boil

    Steam

    Ship

    Deadline

    Lifeline

    Backup

    March 24, 2015 at 2:40 pm

    #1786109

  • RE: Identifying Start Dates not Aligned with End Dates on a Prior Row

    Good article as always Dwain, thank you very much.

    Some thoughts, first of all the 1M test code only produced 100 rows until I adjusted the top clauses. The second thing...

    March 24, 2015 at 2:10 pm

    #1786101

  • RE: Today's Random Word!

    djj (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    Revenant (3/24/2015)

    whereisSQL? (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Cat

    Caterpillar

    Butterfly

    Effect

    Hurricane

    storm

    teapot

    Boil

    Steam

    Ship

    Deadline

    March 24, 2015 at 1:25 pm

    #1786087

  • RE: Restore Database from GUI takes long or never pop up

    dallas13 (3/24/2015)

    Thanks but we can not add diff backup in our environment. thats how this environment is since sql 2005, 2008 and now 2014 is the only one that started...

    March 24, 2015 at 1:23 pm

    #1786084

  • RE: Restore Database from GUI takes long or never pop up

    dallas13 (3/24/2015)

    I have SQL 2014. When I try to restore a user database using SSMS GUI, the Restore Database Pop up box never pops up. This happens for any database...

    March 24, 2015 at 12:49 pm

    #1786075

  • RE: Today's Random Word!

    Ed Wagner (3/24/2015)

    Revenant (3/24/2015)

    whereisSQL? (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Cat

    Caterpillar

    Butterfly

    Effect

    Hurricane

    storm

    teapot

    Boil

    Steam

    March 24, 2015 at 12:06 pm

    #1786068

  • RE: Today's Random Word!

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Ed Wagner (3/24/2015)

    djj (3/24/2015)

    Cat

    Caterpillar

    Butterfly

    Effect

    Hurricane

    March 24, 2015 at 9:07 am

    #1786010

  • RE: Today's Random Word!

    Ed Wagner (3/24/2015)

    Revenant (3/23/2015)

    TomThomson (3/23/2015)

    Eirikur Eiriksson (3/23/2015)

    Ed Wagner (3/23/2015)

    Eirikur Eiriksson (3/23/2015)

    djj (3/23/2015)

    Ed Wagner (3/23/2015)

    Revenant (3/23/2015)

    Ed Wagner (3/23/2015)

    djj (3/23/2015)

    whereisSQL? (3/20/2015)

    Revenant (3/20/2015)

    BWFC (3/20/2015)

    Ed Wagner (3/20/2015)

    BWFC (3/20/2015)

    Ed Wagner (3/20/2015)

    crookj (3/20/2015)

    Ed Wagner (3/20/2015)

    djj (3/20/2015)

    Refinement

    Oil

    fracking

    Drill

    Sergeant

    Arms

    The...

    March 24, 2015 at 5:14 am

    #1785915

  • RE: Unable to read the encrypted password.

    SQL-DBA-01 (3/23/2015)

    Hi

    I used the below command to accept password. But unable to print the password entered.

    Please help me with the correct format to decrypt the password? I don't want to...

    March 23, 2015 at 10:25 pm

    #1785870

  • RE: Error running Stored procedure from SSIS runs fine in SSMS

    RantaSanta (3/23/2015)

    ERROR :: 615 :: Could not find database ID 20, name '20'. The database may be offline. Wait a few minutes and try again. ---------------------------------------------------------------------------------------------------- SPID: 111 Origin: SQL...

    March 23, 2015 at 9:46 pm

    #1785865

  • RE: Today's Random Word!

    Ed Wagner (3/23/2015)

    Eirikur Eiriksson (3/23/2015)

    djj (3/23/2015)

    Ed Wagner (3/23/2015)

    Revenant (3/23/2015)

    Ed Wagner (3/23/2015)

    djj (3/23/2015)

    whereisSQL? (3/20/2015)

    Revenant (3/20/2015)

    BWFC (3/20/2015)

    Ed Wagner (3/20/2015)

    BWFC (3/20/2015)

    Ed Wagner (3/20/2015)

    crookj (3/20/2015)

    Ed Wagner (3/20/2015)

    djj (3/20/2015)

    Refinement

    Oil

    fracking

    Drill

    Sergeant

    Arms

    The Man

    Patriarch

    Matriarch

    Mama

    Father

    Time

    Warp

    Again

    Repeat

    First

    WHILE

    March 23, 2015 at 12:36 pm

    #1785798

Viewing 15 posts - 5,956 through 5,970 (of 8,761 total)