Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 6,041 total)

  • RE: DB compression testing in SQL 2014

    GilaMonster (11/3/2016)


    Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going to estimate savings...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: DB compression testing in SQL 2014

    SQL Server 2008 supports row and page compression. I havn't heard anything about improvements to the compression algorithm in 2014.

    You can estimate the compression savings on a table using the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Generating Our Own Bad Data

    Rod at work (11/2/2016)


    David.Poole (11/2/2016)


    Terry Pratchett described how the city of Ankh Morpork dealt with a plague of rats by paying a bounty on dead rats delivered. Despite this...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Server Hardware or Coffee?

    Sean Redmond (11/3/2016)


    The horrifying thought is that Microsoft will start to include the coffee-factor into their licensing calculations. Enterprise Edition users are allowed unlimited cups of coffee and a better...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Generating Our Own Bad Data

    Rod at work (11/3/2016)


    Eric M Russell (11/2/2016)


    kiwood (11/2/2016)


    Eric M Russell (11/2/2016)If IT was providing executive management with reports indicating an unusual spike in the number of new accounts opened and...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Server Hardware or Coffee?

    Iwas Bornready (11/3/2016)


    ...and the coffee tastes good.

    That depends on how much budget our company has allocated to coffee.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Server Hardware or Coffee?

    So instead of the traditional Scope Triangle of Time / Cost / Quality, we may need to now add Coffee.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Suspect data in SQL tables

    Rather than SQL Injection (embedding SQL into the URL), it appears that a user is simply pasting javascript fragments into a text field, so it gets saved to your varchar...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: is anything using the sa account?

    There is a lot to be said for simply disabling the 'SA' account just to see if someone outside the DBA team is crass enough to actually complain.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Generating Our Own Bad Data

    kiwood (11/2/2016)


    Eric M Russell (11/2/2016)If IT was providing executive management with reports indicating an unusual spike in the number of new accounts opened and fees generated, then they have done...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Generating Our Own Bad Data

    In the case of WellsFargo Bank, what's notable is how many people were involved and pervasive it was across practically all it's regional locations. I'm not sure that putting the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Query to find all procedures that uses functions in the where clause(left operand)

    To help (but not prevent) false positives, you can start by joining SYSTEM_SQL_MODULES.DEFINITION on a set of actual function names rather than attempting to parse the WHERE clause for what...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: The Forever Technology War

    Rod at work (11/2/2016)


    David.Poole (11/1/2016)


    I read a blog post about a bloke in a coffee shop who was approached by an old man who turned out to have been one...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Generating Our Own Bad Data

    One big problem I have with conventional society is that we have way too many people in suits trying to hustle for money and not enough engineers, laborers, and teachers...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Generating Our Own Bad Data

    kiwood (11/2/2016)


    I think to even suggest that the IT department could/should have prevented the mess at Well's Fargo is dangerous and perhaps unethical. Consider the news: people who pointed out...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 2,086 through 2,100 (of 6,041 total)