Forum Replies Created

Viewing 15 posts - 18,136 through 18,150 (of 19,560 total)

  • RE: Script out database schema

    Right click database, tasks --> generate scripts. Follow the wizard.

    That will allow you to script out the database schema. Unless you are talking about the user schema, and...

    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 14, 2010 at 1:20 pm

    #1103896

  • RE: Copy table with index and statistics

    Do you need to copy data too?

    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 14, 2010 at 1:05 pm

    #1103881

  • RE: CAN ANY ONE WRITE QUERY FOR BELOW DESCRIPTION!

    Lowell (1/14/2010)

    my mind reading hat is better than yours today...

    actually he put in a description along with the subject, which you can only read at the topic listing level, and...

    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 14, 2010 at 1:02 pm

    #1103879

  • RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

    Ifila, thanks for posting the information that was being requested. This topic has shown that SSC can help and will help when challenged. I hope the results of...

    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 14, 2010 at 12:10 pm

    #1103839

  • RE: CAN ANY ONE WRITE QUERY FOR BELOW DESCRIPTION!

    I see data and no description. Please provide a description of what you are trying to accomplish with that data. Also, please provide table scripts where applicable.

    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 14, 2010 at 12:05 pm

    #1103835

  • RE: Dodge, Dip, Dive, Duck, and Dodge

    GSquared (1/14/2010)

    jferrel-1093506 (1/14/2010)

    True Lynn, I have not read much else on SSC.... but as disgusted as he is about customer support, I can equate that to me having to wade...

    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 14, 2010 at 11:11 am

    #1103799

  • RE: Indexed view or Flat table

    Ather M (1/14/2010)

    Thanks for your suggestions....

    Can you people provide me some refernce...

    http://msdn.microsoft.com/en-us/library/cc719165.aspx

    It is also great if somebody give lights on cube

    http://technet.microsoft.com/en-us/library/cc966399.aspx

    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 14, 2010 at 11:10 am

    #1103798

  • RE: Dodge, Dip, Dive, Duck, and Dodge

    Steve Jones - Editor (1/14/2010)

    I hope I haven't come across as a fruitcake here.

    Nope - no fruitcakes this time of year. Except maybe in the eyes of that...

    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 14, 2010 at 11:06 am

    #1103794

  • RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

    Lynn Pettis (1/14/2010)

    ifila (1/14/2010)

    A few months ago, a forum member suggested reducing the size of the email fields from 1000 to something more reasonable.

    So i created a TestDB that 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

    January 14, 2010 at 11:03 am

    #1103792

  • RE: SQL Server Login

    It's a matter of timing.

    You're welcome. Good to see that you also found an answer to your 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 14, 2010 at 10:11 am

    #1103764

  • RE: Dodge, Dip, Dive, Duck, and Dodge

    Dom Horton (1/14/2010)

    jferrel-1093506 (1/14/2010)

    True Lynn, I have not read much else on SSC.... but as disgusted as he is about customer support, I can equate that to me having 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 14, 2010 at 10:08 am

    #1103761

  • RE: Dodge, Dip, Dive, Duck, and Dodge

    jferrel-1093506 (1/14/2010)

    Ahhh yes.. A well tuned database does give you some free time, Tom.

    ...

    Good point - the very reason many of us are able to contribute to the SSC community...

    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 14, 2010 at 10:06 am

    #1103760

  • RE: How do you limit records using Distinct and Count - TOP and Rowcount dont work ?

    Lynn Pettis (1/14/2010)

    CirquedeSQLeil (1/14/2010)

    Not being certain that I have the same FTI and catalog as yours, I was able to gain substantial improvement just by adding a Non-Clustered index 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 14, 2010 at 9:44 am

    #1103736

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (1/14/2010)

    It is special treatment, which is why I asked for 24 hours. I appreciate the gesture, though even if this is resolved I am likely going...

    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 14, 2010 at 9:39 am

    #1103728

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/14/2010)

    Hmm, Impressed a lurker we did.

    Yes indeed. Surprised am I not though that she was impressed by the good people here. Surprised I am that she...

    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 14, 2010 at 9:29 am

    #1103717

Viewing 15 posts - 18,136 through 18,150 (of 19,560 total)