Forum Replies Created

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

  • RE: Performance issue with tally solution

    Adam Machanic (9/5/2012)


    Ah, and there is the rub: You're over the 4k threshold, which means that you're stuck with the larger definition or you're hoping that the query optimizer gives...

  • RE: Performance issue with tally solution

    Adam Machanic (9/5/2012)


    Well the only logical way to respond to that is to ask you why you're storing these strings in a table. Dare I ask?

    I'm not storing them that...

  • RE: Performance issue with tally solution

    Adam Machanic (9/5/2012)


    How are you seeing string splits used where such a difference would matter? (Again, I am *only* talking about string split operations.)

    Generally when I see string splitters used...

  • RE: Potential Foreign Key Bug

    Ninja's_RGR'us (8/26/2011)


    The only weight it needs is to blow up when they run it. That breaks their sla so they have to fix it.

    That may be true, but when...

  • RE: The OVER Clause enhancements in SQL Server code named “Denali”, CTP3

    Thanks for the article, I have been looking forward to this functionality. Thanks also for the blog post about the performance. (It would have been good if that was...

  • RE: Looking for a no-cost issue tracker

    shew (8/24/2011)


    Perry Whittle (8/24/2011)


    its a very popular\stable forum, you just need a webserver with support for active server pages 😉

    I think I may have access to a server that will...

  • RE: SQL 2008 R2 Cumulative update

    bg520 (8/24/2011)


    Bit of a silly query...

    I have a server thats a reel pain in the back side where SSAS is concerned. Its SQL 2008 R2 x64, SP1 was applied...

  • RE: SQL Server 2008 Compression

    Tom.Thomson (7/26/2011)


    Good article.

    On the compressed backup of a compressed table question: no, the compression algorithms/formats are different, so backing up a compressed table/index involves decompressing and then recompressing; so the...

  • RE: Linked server joins

    carsten.jorgensen (6/10/2011)


    I would believe that remote join operations will only be possible if the remote db is also a SQL server db. In this case where the remote db is...

  • RE: Enabling TDE

    Nice question, thanks!

  • RE: Parameterization Settings

    Another good question on something that probably isn't used that often, thanks!

  • RE: Plans

    Thanks for the question!

  • RE: Page Compression

    Thanks for another good question!

  • RE: Filestream

    Nice question, you almost had me with the 8.3 option.

  • RE: Logshipping

    Nice question, good to re-enforce some of the options that we don't all use on a regular basis, thanks!

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