Forum Replies Created

Viewing 15 posts - 5,431 through 5,445 (of 19,560 total)

  • RE: Is it possible to create a database with having one .mdf file of another database(resides in diff instance)?

    If that data file is in use, then you can only attach it to the one instance at a time.

    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

    December 20, 2012 at 10:54 pm

    #1570722

  • RE: Today's Random Word!

    bcsims 90437 (12/20/2012)

    crookj (12/20/2012)

    Rob Schripsema (12/19/2012)

    SQLRNNR (12/19/2012)

    Ray K (12/19/2012)

    L' Eomot Inversé (12/19/2012)

    SQLRNNR (12/19/2012)

    Talon

    Hawk(e)

    Hawkeye

    Pierce

    Hot Lips!

    Radar

    M*A*S*H!!!!!

    (We're showing our age)

    Honeycut

    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

    December 20, 2012 at 9:32 pm

    #1570711

  • RE: Add Data files dynamically based no of cpu's

    @SQLFRNDZ (12/20/2012)

    This is what I got so far and I need help with looping script to add files to number of times based on condition cpu_count.

    Here is the script I'm...

    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

    December 20, 2012 at 9:31 pm

    #1570710

  • RE: Sql Server 2005 doesn't connect for windows xp SP3

    Does that mean it is working now?

    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

    December 20, 2012 at 9:29 pm

    #1570709

  • RE: Use of Parallelism.

    Is advanced power management enabled in the bios on either machine?

    Also, please submit actual execution plans for both servers. It will help us to troubleshoot.

    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

    December 20, 2012 at 8:23 pm

    #1570699

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/20/2012)

    I checked the SQL Servers, but everything seemed to be in order there. I suspect the mail servers had some issue.

    Looks like they're working as...

    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

    December 20, 2012 at 8:22 pm

    #1570698

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (12/20/2012)

    Spam! Spam! Spam! Spam!

    Spammity Spam! Wonderful Spam!

    http://www.youtube.com/watch?v=anwy2MPT5RE

    Awesome

    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

    December 20, 2012 at 8:20 pm

    #1570697

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (12/20/2012)

    SQLRNNR (12/20/2012)

    Anybody else not receiving the topic notifications from SSC?

    I have not received any since early this morning (1am-ish).

    Last notification I got about thread messages was between...

    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

    December 20, 2012 at 7:01 pm

    #1570689

  • RE: What are you planning to do in 2013 in the database domain?

    I have some writing to do (maybe a book), and some projects that have been started that need to be finished or enhanced.

    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

    December 20, 2012 at 4:35 pm

    #1570676

  • RE: Add Data files dynamically based no of cpu's

    Well, what have you got for your script so far?

    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

    December 20, 2012 at 4:33 pm

    #1570675

  • RE: Are the posted questions getting worse?

    Anybody else not receiving the topic notifications from SSC?

    I have not received any since early this morning (1am-ish).

    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

    December 20, 2012 at 3:46 pm

    #1570671

  • RE: UNIQUE constraint

    (Bob Brown) (12/20/2012)

    I knew there might be a controversy over this question but I took a stab at YES because of the Itsik Ben-Gan article I read on...

    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

    December 20, 2012 at 9:36 am

    #1570595

  • RE: UNIQUE constraint

    Koen Verbeeck (12/20/2012)

    Gopi S (12/20/2012)

    So far Jason is following me 😛

    Yes, by saying your explanation is insufficient...

    True dat!

    I would like to see a better explanation that is more on-point with...

    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

    December 20, 2012 at 12:56 am

    #1570435

  • RE: UNIQUE constraint

    Koen Verbeeck (12/20/2012)

    Gopi S (12/20/2012)

    Technically there is no difference between Unique Index and Unique Constraint. Even though syntax are different the effect is the same.

    Unique Constraint creates Unique Index...

    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

    December 20, 2012 at 12:54 am

    #1570434

  • RE: UNIQUE constraint

    dawryn (12/20/2012)

    SQLRNNR (12/20/2012)

    I don't disagree with the correct answer. I disagree with the explanation. I also do disagree with many of the complaints thus far about 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

    December 20, 2012 at 12:47 am

    #1570430

Viewing 15 posts - 5,431 through 5,445 (of 19,560 total)