Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 19,560 total)

  • RE: On which drive to install SQL and System databases?

    Rem70Rem (11/18/2014)

    Hi,

    I am debating to where to install SQL on a brand new machine. Should I do the install on the C drive or on a different one?

    Half...

    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 18, 2014 at 3:31 pm

    #1759427

  • RE: Today's Random Word!

    dissociative

    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 18, 2014 at 2:54 pm

    #1759416

  • RE: dot notation where all columns are not referenced

    Lynn Pettis (11/18/2014)

    GilaMonster (11/18/2014)

    Lynn Pettis (11/17/2014)

    Even in single table queries I recommend using table aliases in the FROM clause and using that alias on the columns in the select list....

    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 18, 2014 at 10:35 am

    #1759356

  • RE: Trace Flags

    Sadly the question posed can lead to confusion and a low correct answer rate due to the availability of four correct answers.

    The correct answers listed are only for trace flag...

    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 18, 2014 at 7:54 am

    #1759293

  • RE: dot notation where all columns are not referenced

    mcinvalek (11/17/2014)

    I have come across a few tables that are created using dot notation, but not all of the columns are referenced.

    Notice the dummy script below. The first col...

    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 17, 2014 at 12:36 pm

    #1759067

  • RE: Can I attain the space back

    You can use dbcc shrinkfile. I would leave 20GB free space inside of the file to allow for various database activities including growth.

    The problem with shrinking a file is...

    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 17, 2014 at 12:28 pm

    #1759065

  • RE: Database Server and Web Server: Which should get the faster server?

    I'd give it to the database server.

    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 17, 2014 at 10:49 am

    #1759046

  • RE: sp_spacesued output into a table.

    Here is a script that will make it very easy to get the space used and to insert it into a table.

    http://bit.ly/tablespace

    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 17, 2014 at 10:21 am

    #1759036

  • RE: Memory

    Meow Now (11/17/2014)

    Boooo...I want my free set of steak knives!

    I like that idea.:-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 17, 2014 at 10:13 am

    #1759034

  • RE: Today's Random Word!

    tapcon

    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 17, 2014 at 10:09 am

    #1759032

  • RE: Where are the DBA's!?

    schwizla (11/17/2014)

    Hi, thanks for your replies. I agree, certified DBA figures will not really paint the accurate picture for the reason you state. But I'm guessing that's the only tangible...

    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 17, 2014 at 10:06 am

    #1759030

  • RE: SQL dba role with limited access/permissions.

    sKreetz! (11/17/2014)

    Thanks for the quick reply GilaMonster!

    Does this also apply to dba's changing their own or other dba permissions to access this information? I would like the dba's to be...

    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 17, 2014 at 8:59 am

    #1759011

  • RE: Maintenance Plan DB integrity check questions!!!

    FWIW - "no_infomsgs" does not suppress errors and corruption. It just suppresses the informational messages that most people discard anyway.

    As for the agent job, if there is corruption, it...

    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 17, 2014 at 8:20 am

    #1759000

  • RE: Where are the DBA's!?

    Jeff Moden (11/17/2014)

    schwizla (11/17/2014)

    Hey everyone. Does anyone have any idea roughly how many SQL DBA's there are globally or how they are geographically dispersed? I am thinking that really 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 17, 2014 at 7:59 am

    #1758993

  • RE: Today's Random Word!

    Ed Wagner (11/14/2014)

    Stuart Davies (11/14/2014)

    Ed Wagner (11/14/2014)

    Friday

    Crunchie

    Texture

    Putty

    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 14, 2014 at 9:57 am

    #1758669

Viewing 15 posts - 1,816 through 1,830 (of 19,560 total)