Forum Replies Created

Viewing 15 posts - 15,931 through 15,945 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (3/25/2010)

    Trey, it's possible they are relying on DBCC TIMEWARP to provide point-in-time recovery.

    What is your ARID??

    umm... Extra Dry?

    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

    March 25, 2010 at 11:37 am

    #1139867

  • RE: The Missing Certification

    Steve Thompson-454462 (3/25/2010)

    I would also make the claim that any certification test proffered by any vendor would be open to "only people who could afford the time and resources" so...

    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

    March 25, 2010 at 11:33 am

    #1139861

  • RE: The Missing Certification

    Gift Peddie (3/25/2010)

    I disagree with that assertion. I studied for the CCNA exam and wrote it. I passed the exam and there was much more than octet counting involved.

    When 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

    March 25, 2010 at 11:26 am

    #1139852

  • RE: Are the posted questions getting worse?

    Trey Staker (3/25/2010)

    Anyone have anything light or funny to move this thread back into the right direction?:-D

    What is your favorite color?

    Blue. No yel-- auuuuuuuugh!

    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

    March 25, 2010 at 11:24 am

    #1139848

  • RE: Bad Practice

    Trey Staker (3/25/2010)

    Level 1 support won't but if I can get past them and speak to their engineers, then yes they can. I've spoken with them before and they...

    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

    March 25, 2010 at 11:20 am

    #1139844

  • RE: Are the posted questions getting worse?

    Trey Staker (3/25/2010)

    EDIT: I did pose this as a question outside the "Thread" after I posted it here because this probably isn't the proper place. I appologize for...

    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

    March 25, 2010 at 11:15 am

    #1139837

  • RE: The Missing Certification

    Gift Peddie (3/25/2010)

    This again is something I know Cisco exams are not much better than Microsoft I had participated in CCNA user group in Houston a while back to help...

    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

    March 25, 2010 at 11:13 am

    #1139835

  • RE: Bad Practice

    Lowell (3/25/2010)

    the DUMP word was deprecated in favor of BACKUP; you cannot even use it in SQL 2008.

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

    the statement was trying to truncate the transaction logs;

    in SQL 2008, the equivilent...

    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

    March 25, 2010 at 11:06 am

    #1139827

  • RE: What will be output?

    john.arnott (3/25/2010)

    Hugo Kornelis (3/25/2010)

    Good question, but unfortunately the explanation is not entirely correct. Especially this part is very misleading:

    Also the preceding space is not considered while performing the operation.

    . ....

    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

    March 25, 2010 at 11:01 am

    #1139822

  • RE: Bad Practice

    Give them the explanation that you have already done that and then don't do it. Or you could run the command and then perform a full backup immediately.

    Then demand...

    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

    March 25, 2010 at 10:58 am

    #1139817

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/25/2010)

    Trey Staker (3/25/2010)

    I've got a 3rd party companies support that uses sql server as their DB for their database that is insisting I add this command to my...

    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

    March 25, 2010 at 10:53 am

    #1139814

  • RE: Begin transaction ........... commit transaction

    Look up Try Catch in BOL. That will help you with being able to rollback the transaction.

    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

    March 25, 2010 at 10:43 am

    #1139807

  • RE: Shrinking a Database

    Tom West (3/25/2010)

    Hi,

    Apologies now, but I'm not a DBA, I'm a developer and we don't have any of the former here (budgetary constraints :ermm: )

    Basically the question 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

    March 25, 2010 at 10:40 am

    #1139803

  • RE: migratation from sql server 2000 to sql server 2005

    You verify that the migration is successful by testing your applications, jobs, logins, etc.

    As for migrating the jobs, You could try using REDGate SQL Data COmpare against the msdb database...

    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

    March 25, 2010 at 10:38 am

    #1139796

  • RE: Setting up security to a view

    Yes there is.

    Since it is two different databases, I would recommend using a certificate and a signed stored procedure. The certificate would be associated to a user in 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

    March 25, 2010 at 10:33 am

    #1139794

Viewing 15 posts - 15,931 through 15,945 (of 19,560 total)