Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 6,041 total)

  • RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

    I use tool on my personal PC to keep tabs on disk space allocation by folder. It would help in your case too.
    https://jam-software.com/treesize_free/

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

  • RE: Disk Encryption and The Impact to DBAs

    Where I work, we've started implementing SQL Server TDE, which I believe has many advantages over FDE (Full Disk Encryption) solutions.

    TDE:
    - Is free with the SQL Server...

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

  • RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

    1. Easy 5 minute fix to get you out of the red: Run a tool to identify temp files, recycle folder, download folder, and other stuff that can be deleted...

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

  • RE: Learning DW

    JaybeeSQL - Friday, January 12, 2018 10:19 AM

    Hi all, been going through the MS tutorial for Analysis Services, but it's as dull...

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

  • RE: CREATE RULE

    Steve Jones - SSC Editor - Friday, January 12, 2018 8:43 AM

    No idea, but I suspect that someone liked constraints better and...

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

  • RE: Ola's maintenance solution taking too long on VLDB's

    TheSQLGuru - Thursday, January 11, 2018 4:13 PM

    Eric M Russell - Thursday, January 11, 2018 7:23 AM

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

  • RE: CREATE RULE

    Trick question. Don't do it; use a constraint instead.
    I've worked in a dozen IT shops over the years, and I don't think I've encountered usage of RULE based...

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

  • RE: Job Interviews: What is Normalization?

    Normalization, and data modeling in general, are good questions for intermediate level and higher database developers, because it's hard for a candidate to talk about without having actually having hands...

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

  • RE: Ola's maintenance solution taking too long on VLDB's

    Does anyone here besides me implement partitioning on indexes just for taking advantage of incremental reorgs and re-indexing? It depends on the access patterns and chosen partitioning key, but at...

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

  • RE: Is This Data Science?

    xsevensinzx - Tuesday, January 9, 2018 9:14 AM

    Eric M Russell - Tuesday, January 9, 2018 7:00 AM

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

  • RE: Is This Data Science?

    To answer the question "Is what we're doing with this data really data science?", we first must ask the question "What is science?". Technology and process aside, science is first...

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

  • RE: It's Time to Patch and Upgrade

    North Carolina and other like minded states would be interested to know that this technology could be easily employed to enforce gender based bathroom segregation laws. This is a $10...

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

  • RE: It's Time to Patch and Upgrade

    Jeff Moden - Friday, January 5, 2018 7:11 PM

    Things like this scare me to death.  Consider how dependent we've become on computers...

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

  • RE: Ola's maintenance solution taking too long on VLDB's

    ALTER INDEX { index_name | ALL } ON <object>
    {
      REBUILD {
        [ PARTITION = ALL ] [ WITH ( <rebuild_index_option> [ ,...n ]...

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

  • RE: Ola's maintenance solution taking too long on VLDB's

    ffarouqi - Tuesday, December 19, 2017 10:10 AM

    All,
    I am looking into optimizing Ola's maintenance solution by tweaking around some parameters that is...

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

Viewing 15 posts - 1,111 through 1,125 (of 6,041 total)