Forum Replies Created

Viewing 15 posts - 1 through 15 (of 28 total)

  • RE: Getting index columns

    Would be a good April Fool's question...:-D

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: SELECT INTO vs INSERT INTO on Columnstore

    SELECT INTO does place locks on system metadata, which can cause issues for users, until the SELECT INTO completes. INSERT INTO can be minimally logged by using a TABLOCK....

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: How Virtualized?

    100% over couple hundred servers, for DR, maintenance, continuity. SQL 2012 mostly. Data warehouse is all solid state with Kaminario All-Flash Array. 😎

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: SSMS object explorer lock timeout when running compression script

    Thanks, it doesn't bother me but I don't want to affect other users! Good to hear someone else has seen this. Thought about creating a job to run...

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Calculate Table Size and row count

    These don't work with partitioned tables or indexes. It lists everything on separate rows.

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Get record count for a specific database

    COMPUTE isn't supported in SQL 2012, just FYI... 😀

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Do Interviews Work?

    I think a good test would be to see how many people reading this article do not know what a 'Borg' is? Does a techie have to know scifi?...

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Everyone Wants to Win (Raw Materials Comic Strip)

    A nod to the new Bobby Fischer documentary? Enjoyable cartoon, none the less. 😀

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: SQL Server Port Number Identifier

    Rudy Panigas (1/21/2011)


    The code will not work on a cluster unless you run it from the node(s) and not from the virtual SQL server.

    Give it a try and let...

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: How can i recover my table

    Grant Fritchey (1/14/2011)


    homebrew01 (1/14/2011)


    The 3rd party backup tools "object recovery" would only work if the current backup was taken by them. You can't use them after-the-fact. I know Idera's...

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Date Calendar

    Gitmo, cool! Sean did a great job on that table. I have programmers I show it to that still use SQL date functions against the table. :w00t:...

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Date Calendar

    This is mentioned in my post Calculate U.S. Holidays at [/url]. I just added a column is_workday to Sean's existing script, then made my holiday script. Hope that...

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: NoSQL Basics

    Isn't Voldemort evil? J.K. Rowling must be freelancing...and the MulletDB is hilarious!

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Merry Christmas 2010

    Call free weekend is a good Christmas wish! Thanks for your informative website and hard work. 😎

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

  • RE: Date Calendar

    Hey Sean, I still use this wonderful program at work! Last year I added a is_workday column to flag for holidays. And created a script to generate the...

    [font="Courier New"]____________________________________________________________________________________________
    Remember as you walk down lifes road, don't forget to stop and pee on the bushes - Thordog
    [/font]

Viewing 15 posts - 1 through 15 (of 28 total)