Forum Replies Created

Viewing 15 posts - 5,941 through 5,955 (of 8,753 total)

  • RE: any way to return from script instead of drop existing for ddl scripts?

    sqlguy-736318 (3/25/2015)

    Hello,

    Let's say I have a function named MyCustomFunction and I want to ensure that it exists in the database. Let's say I have a create script for the...

    March 26, 2015 at 12:13 am

    #1786461

  • RE: SQL server 2000 not visible

    Quick question, if you run "net start" from a command window, what does it return?

    😎

    March 26, 2015 at 12:04 am

    #1786460

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

    Eirikur Eiriksson (3/25/2015)

    dwain.c (3/24/2015)

    Hi Eirikur - Thanks for taking a look!

    I'm a little confused by your examples though. You're using DATEDIFF in one bit of code and then CONVERT...

    March 25, 2015 at 10:57 pm

    #1786459

  • RE: Split function that allows multiple character delimitter

    Quick thought, the most efficient way is probably splitting on one of the two delimiter characters and remove the other delimiter character from the output. Manipulating the input is very...

    March 25, 2015 at 10:29 pm

    #1786457

  • RE: Today's Random Word!

    Ed Wagner (3/25/2015)

    eccentricDBA (3/25/2015)

    crookj (3/25/2015)

    Ed Wagner (3/25/2015)

    Eirikur Eiriksson (3/24/2015)

    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

    Restore

    Refurbish

    Reinvent

    Tune

    Sharp

    March 25, 2015 at 12:40 pm

    #1786404

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

    dwain.c (3/24/2015)

    Hi Eirikur - Thanks for taking a look!

    I'm a little confused by your examples though. You're using DATEDIFF in one bit of code and then CONVERT in the...

    March 25, 2015 at 2:38 am

    #1786191

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/24/2015)

    Ed Wagner (3/24/2015)

    SQLRNNR (3/24/2015)

    Brandie Tarvin (3/23/2015)

    Eirikur Eiriksson (3/23/2015)

    GilaMonster (3/23/2015)

    Eirikur Eiriksson (3/22/2015)

    Now where is the Crystal Ball?

    😎

    If you find it, I think this query can only be done if the...

    March 24, 2015 at 3:58 pm

    #1786139

  • 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

Viewing 15 posts - 5,941 through 5,955 (of 8,753 total)