Forum Replies Created

Viewing 15 posts - 4,066 through 4,080 (of 19,560 total)

  • RE: Today's Random Word!

    Jeff Moden (11/13/2013)

    Divine Flame (11/13/2013)

    I don't understand the significance of this thread:cool:

    Heh.... good. It must be ready to ship. 😛

    Good enough

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 13, 2013 at 9:02 am

    #1666124

  • RE: Data Compression

    Forgot to add the link for the msdn reference showing that Vardecimal is a read_only attribute in 2008 and above with it being enabled on all "user" databases by default

    http://msdn.microsoft.com/en-us/library/ms188124.aspx

    The...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 13, 2013 at 6:40 am

    #1666041

  • RE: Data Compression

    Gary Varga (11/13/2013)

    SQLRNNR (11/12/2013)

    Vardecimal existed only in SQL 2005. SQL 2008 introduced compression (row and page). While vardecimal is a form of compression, the fact that it only...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 13, 2013 at 6:34 am

    #1666039

  • RE: Data Compression

    Though i understood what the OP was trying to achieve I don't like this particular question and I don't like the supporting documentation.

    Vardecimal existed only in SQL 2005. SQL...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 12, 2013 at 10:57 pm

    #1665929

  • RE: Automatic Page Repair

    Thanks. Straight forward enough of a question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 11, 2013 at 9:06 pm

    #1665630

  • RE: Today's Random Word!

    buzz

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 11, 2013 at 7:56 am

    #1665488

  • RE: Help for Windows Server 2008 R2 and SQL Server Memory conflicts

    Here is a pretty good resource for that.

    http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/

    2GB for the OS is too low when you have 32GB of memory. The OS will use more than 2GB.

    And this one

    http://www.sqlskills.com/blogs/jonathan/wow-an-online-calculator-to-misconfigure-your-sql-server-memory/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 8, 2013 at 3:55 pm

    #1665245

  • RE: MAXDOP setting ??

    Grant Fritchey (11/7/2013)

    The other recommendations for MAXDOP are good. You can also leave it at zero if you're not experiencing any particular CPU pressure.

    But, the one thing I would suggest...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 8, 2013 at 3:49 pm

    #1665243

  • RE: Using Max()

    r.stebbens 78867 (11/8/2013)

    Mighty (11/8/2013)

    paul.knibbs (11/8/2013)

    I kind of agree with waxingsatirical...it never occurred to me anyone would think this works otherwise, and I spent a good few minutes trying to figure...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 8, 2013 at 10:28 am

    #1665186

  • RE: Effectiveness

    Jeff Moden (11/7/2013)

    If you want it real bad, that's the way you'll get it.

    Rework costs at least 8 times more than doing it right the first time.

    Your customers are the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 7, 2013 at 3:50 pm

    #1664950

  • RE: Effectiveness

    Tom John-342103 (11/7/2013)

    If "a little clunky" means that the application is good enough, then by all means roll it out. Because "good enough" delivered today beats perfection delivered tomorrow...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 7, 2013 at 1:47 pm

    #1664916

  • RE: Today's Random Word!

    erroneous

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 7, 2013 at 1:35 pm

    #1664913

  • RE: Project Hekaton

    swwg69 (11/6/2013)

    Everything old is new again. Back in the day, I packed a machine with RAM, created a VDisk and assigned tempdb to the VDisk. The machine's performance...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 6, 2013 at 10:30 am

    #1664521

  • RE: SQLCMD

    Jeff Moden (11/5/2013)

    SQLRNNR (11/5/2013)

    Jeff Moden (11/5/2013)

    Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀

    not sp_configure??

    :w00t::-D

    Heck no. I leave...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 5, 2013 at 2:12 pm

    #1664255

  • RE: SQLCMD

    Jeff Moden (11/5/2013)

    Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀

    not sp_configure??

    :w00t::-D

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 5, 2013 at 2:05 pm

    #1664250

Viewing 15 posts - 4,066 through 4,080 (of 19,560 total)