Forum Replies Created

Viewing 15 posts - 16,966 through 16,980 (of 19,560 total)

  • RE: Today's Random Word!

    extraneous

    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

    February 26, 2010 at 5:26 pm

    #1125874

  • RE: 9 Things to Do When You Inherit a Database

    murph_32952 (2/26/2010)

    Rename potentially obsolete objects by appending a "z" or "zzz" to the front of the object name. If the object is required, someone will get an error. ...

    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

    February 26, 2010 at 3:30 pm

    #1125856

  • RE: Today's Random Word!

    hypochondriac

    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

    February 26, 2010 at 1:18 pm

    #1125801

  • RE: Are the posted questions getting worse?

    Kit G (2/26/2010)

    lmu92 (2/26/2010)

    I'm not sure if it's because of my lacking language skills... but all I understood was CLOUDS ...

    Is anybody able to tell me what he was...

    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

    February 26, 2010 at 1:17 pm

    #1125799

  • RE: Roles of development DBA

    jswong05 (2/26/2010)

    Query tuning, indexing should be done at least once at dev, at QA before pushing to production environment. The execution plan should be evaluated. If you are serious, you...

    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

    February 26, 2010 at 11:09 am

    #1125731

  • RE: Are the posted questions getting worse?

    Alvin Ramard (2/26/2010)

    Execute DBCC TimeWarp @Param137 = 'Post #873495', @Action = 'Erase for all eternity'

    😎

    Thanks - i needed that wiped clean 😉

    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

    February 26, 2010 at 9:28 am

    #1125668

  • RE: Today's Random Word!

    Hygienical

    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

    February 26, 2010 at 9:20 am

    #1125664

  • RE: Back up into new database

    RaviShankar1234 (2/26/2010)

    Appreciate you all for your response ..

    but can any one tell me how to overwrite a already created database with a backup file.

    Thanks & Regards,

    Ravi Shankar

    Here's an article...

    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

    February 26, 2010 at 9:15 am

    #1125658

  • RE: Cant shrink log file

    Bhuvnesh (2/26/2010)

    If we are backing up the TLog.

    Will it reclaim the space ?

    cant we use DBCC shrinkfile option to regain the space ?

    Reclaim the space within the file. Backing...

    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

    February 26, 2010 at 9:14 am

    #1125657

  • RE: Identity field on each table

    I've seen it a few times. And now you can say that you have heard 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

    February 26, 2010 at 1:33 am

    #1125418

  • RE: Back up into new database

    Sarab. (2/26/2010)

    You can restore the backup of pub DB with another name (can be myDB)

    but if you have a DB already created, it is not at all possible to restore...

    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

    February 26, 2010 at 1:12 am

    #1125411

  • RE: Identity field on each table

    You're welcome.

    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

    February 26, 2010 at 12:55 am

    #1125407

  • RE: Identity field on each table

    Jeff Moden (2/26/2010)

    To add to what Gail has already identified, are you worried that a table will have over 2 billion rows in it? If so, you could always...

    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

    February 26, 2010 at 12:48 am

    #1125401

  • RE: Identity field on each table

    1. The use of Int is a common practice.

    2. You will receive errors. If using an Int, you may want to change that to BigInt.

    Otherwise, the comments...

    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

    February 26, 2010 at 12:45 am

    #1125399

  • RE: two databases...same name...same instance...is it psbl?

    winslet (2/25/2010)

    Different instance names with same database name on same machine is possible with different database file locations.

    - Win.

    Or different instances with same file location but same database file names.;-)

    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

    February 26, 2010 at 12:39 am

    #1125394

Viewing 15 posts - 16,966 through 16,980 (of 19,560 total)