Forum Replies Created

Viewing 15 posts - 2,461 through 2,475 (of 7,164 total)

  • RE: disable a specific job

    timscronin (1/9/2013)

    I have an OLTP system which has a monitor job which needs to be run during the day. WHen the closing is run by 2 different sites the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 8:55 pm

    #1575560

  • RE: Users, Groups, and Schemas

    michaelkinlb (1/9/2013)

    opc.three. Would you be so kind as to implement your statement, ' In SQL 2012 we have the ability to define a default schema for a Database User...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 7:22 pm

    #1575545

  • RE: Restore database from SQL Server 2012 to SQL Server 2008 R2

    David Webb-200187 (1/9/2013)

    As far as I know, there is no way to do a backward restore, even if the database was in a compatibility mode that matched the lower version....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 4:13 pm

    #1575497

  • RE: Need to export excel sheet with SPECIAL formats

    manibad (1/9/2013)

    I mean if i choose special format under that home phone number means the data will be like this (XXX) YYY-TTTT...or if i am going to choose social security...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 4:08 pm

    #1575494

  • RE: Using Openrowset to query Excel spreadsheet

    Import/Export wizard runs in 32-bit mode if you launch it using SSMS while your server is probably a 64-bit process per the bitness of the SQL Server.

    IIRC you can only...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 3:01 pm

    #1575470

  • RE: SSIS Package Won't Stop Running and Locking Files

    DFS is another added layer that can complicate matters when manipulating files on the file system, or it could be a red herring. It could be tons of things unique...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 2:58 pm

    #1575467

  • RE: Need to export excel sheet with SPECIAL formats

    When I am talking about formatting I am talking about bolding the text in a column header, or setting the background color or a column of cells. What kind of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 2:55 pm

    #1575466

  • RE: Today's Random Word!

    Ray K (1/9/2013)

    SQLRNNR (1/9/2013)

    Cliff Jones (1/9/2013)

    SQLRNNR (1/9/2013)

    JAZZ Master (1/9/2013)

    SQLRNNR (1/9/2013)

    spasm

    muscle

    atrophy

    The Stanley Cup

    Grey Cup

    World Cup

    Cup of soup

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 2:42 pm

    #1575460

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    rocks (1/9/2013)

    So i need to change all my SP's and Views to avoid nolock hint.

    By all means, absolutely. If the use of NOLOCK is that pervasive then consider this your...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 2:41 pm

    #1575459

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    You would enable READ_COMMITTED_SNAPSHOT on the database and remove all NOLOCK hints from your queries. See the article I linked to in my initial post on how to enable the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 2:29 pm

    #1575451

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    GilaMonster (1/9/2013)

    opc.three (1/9/2013)

    GilaMonster (1/9/2013)

    opc.three (1/9/2013)

    The nice thing is that no queries need to change, not even the ones with the NOLOCK hint applied, and you'll automatically get transactionally consistent reads....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 2:03 pm

    #1575439

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    GilaMonster (1/9/2013)

    opc.three (1/9/2013)

    The nice thing is that no queries need to change, not even the ones with the NOLOCK hint applied, and you'll automatically get transactionally consistent reads.

    Queries with...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 1:55 pm

    #1575434

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    rocks (1/8/2013)

    yes users understand these type of dirty read might happen.

    I doubt they fully understand what dirty read really means otherwise they would not be alright with it. It means...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 1:20 pm

    #1575411

  • RE: How to load data to target tables (only if no dataflow task is fail in ssis package)

    I agree that permanent staging tables would be a better option than true temp tables (# tables).

    One option to consider:

    1. create 25 staging tables with the exact schema (including constraints,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 10:27 am

    #1575343

  • RE: ADO.NET Destination Custom Propertiees?

    Please post all error messages.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 9, 2013 at 10:01 am

    #1575334

Viewing 15 posts - 2,461 through 2,475 (of 7,164 total)