Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (1/23/2013)

    wolfkillj (1/22/2013)

    When I was doing a lot of SSRS development, I wasted so much time closing BIDS and reopening it because often that was the only way to...

    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

    January 23, 2013 at 9:10 am

    #1580158

  • RE: Adding a Named instance to an existing sql server 2008 R2 Cluster

    ericwenger1 (1/22/2013)

    Yes the named instance will be on my cluster active/passive box

    I am going to take that to mean you want it clustered.

    The setup is the same as you did...

    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

    January 22, 2013 at 3:37 pm

    #1579850

  • RE: SQL Job

    Why not just create a schedule for the job that can only ran after 7am?

    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

    January 22, 2013 at 12:26 pm

    #1579792

  • RE: Adding a Named instance to an existing sql server 2008 R2 Cluster

    Do you want this new instance to also be clustered? Or will it be a stand alone instance on one of the boxes?

    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

    January 22, 2013 at 12:24 pm

    #1579789

  • RE: tempdb files on SSD

    Tara-1044200 (1/22/2013)

    I just confirmed that its a RAMSAN drives and though the 5TB i have is memory not disk.

    Now you are just making us jealous.

    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

    January 22, 2013 at 10:09 am

    #1579736

  • RE: tempdb files on SSD

    Tara-1044200 (1/22/2013)

    when you say proportional manner do i have to restrict each file to certain size and then when total size uses more than max of all files then 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

    January 22, 2013 at 9:32 am

    #1579705

  • RE: tempdb files on SSD

    Tara-1044200 (1/22/2013)

    I see 40 CPU's (2 nodes) when i check properties of sql server under "Processors". I think creating 40 tempdbdata files may be too much.

    I do have 5 TB...

    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

    January 22, 2013 at 8:43 am

    #1579671

  • RE: BIT data type

    Thanks for the 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

    January 21, 2013 at 10:53 pm

    #1579437

  • RE: Synch two SQL databases

    Here are a couple options:

    Change Data Capture

    Service Broker

    You can also use replication if you configure it very carefully.

    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

    January 21, 2013 at 10:50 pm

    #1579436

  • RE: SQL Index Help..

    Since indexes are Left Based, the second index is a duplicate.

    The only reason to not remove it is if somebody is using an index hint with the name of this...

    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

    January 21, 2013 at 5:14 pm

    #1579417

  • RE: The Growth of Storage

    I think 1tb ram in a laptop is <= 10 yrs away. Can't wait buahahaha.

    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

    January 21, 2013 at 5:07 pm

    #1579414

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/21/2013)

    SQLRNNR (1/21/2013)

    Gianluca Sartori (1/21/2013)

    On a totally unrelated note, what do you think of this person?

    He's coming to Italy and my UserGroup is thinking about organising an event.

    Would...

    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

    January 21, 2013 at 3:10 pm

    #1579394

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/21/2013)

    On a totally unrelated note, what do you think of this person?

    He's coming to Italy and my UserGroup is thinking about organising an event.

    Would you pay to...

    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

    January 21, 2013 at 2:43 pm

    #1579387

  • RE: Today's Random Word!

    EL Jerry (1/21/2013)

    SQLRNNR (1/18/2013)

    Ken Leeeeeeeeeeeeee

    Too liboo liboo dow choo?

    Great video

    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

    January 21, 2013 at 1:07 pm

    #1579363

  • RE: MSSQLSYTEMRESOURCE NOT IN DATA DIRECTORY LIST

    george sibbald (1/21/2013)

    Hey! 5000 points! Maybe enough to be listened to now! 🙂

    Congrats

    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

    January 21, 2013 at 9:36 am

    #1579302

Viewing 15 posts - 5,116 through 5,130 (of 19,560 total)