Forum Replies Created

Viewing 15 posts - 721 through 735 (of 3,232 total)

  • RE: Using Schema's with SQL Server Express 2005 and Access ADP 2003

    Sorry, that was the test schema I used. I replaced the E2E text elsewhere with MySchema, but omited doing that for the testing section.

    I've edited my original post to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 19, 2010 at 3:24 pm

    #1105758

  • RE: Using Schema's with SQL Server Express 2005 and Access ADP 2003

    You could create your tables inside a schema and then give them a SYNONYM on that table in DBO. You'll need to watch out for your schema level security...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 19, 2010 at 3:03 pm

    #1105753

  • RE: MULTIPLE DATAFLOW vs. MULTIPLE SOURCE and UNION ALL

    Why can't you write one SQL query to pull all results in one shot? Can you post the table DDL for your staging table and some sample data? ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 19, 2010 at 2:46 pm

    #1105748

  • RE: SSIS performance issue

    gurukiran.bhat (1/18/2010)

    I would like to mention that we are using exicute SQL task to bring data from source

    How much data are you trying to move?

    Is there a...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 19, 2010 at 2:40 pm

    #1105745

  • RE: BIDS Not saving connection manager setting

    Is your package using config files or expressions?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 3:07 pm

    #1103982

  • RE: Enforcing T-SQL Coding Standards

    I've never used software for this. In fact, I was not aware that software existed that had the ability to enforce coding standards.

    We have always handled coding standards enforcement...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 12:51 pm

    #1103868

  • RE: Index

    From BOL on Column Considerations for non-clustered indexes:

    Lots of distinct values, such as a combination of last name and first name, if a clustered index is used for other columns....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 12:26 pm

    #1103853

  • RE: Stored procedure or a trigger to strip html tags in the DB

    Duplicate post, please follow this thread and reply here

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 12:03 pm

    #1103833

  • RE: Make rows columns in sql server 2005

    You're almos there.....

    SELECT MediaBuyer,

    [1/7/2009],

    [1/9/2009],

    [1/11/2009],

    [1/13/2009],

    ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 11:41 am

    #1103823

  • RE: Exporting Data to AS400 from SQL2005 with SSIS is SLOWWWWW

    Rick Bailey-440858 (1/13/2010)I was told that the poor performance was due to a record by record insert vs. a bulk insert.

    OK.... but why can I use the same method to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 8:35 am

    #1103649

  • RE: How to switch data online

    I would not recommend attempting to use the max degree of parallelism setting to micromanage your thread priority.

    xuejianpan,

    These data loads that you're asking about:

    1. how often do you...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 8:27 am

    #1103643

  • RE: How to partition huge data to multiple machines?

    xuejianpan (1/13/2010)

    I'm so sorry to post duplicate messages and cause the confusion. but John's link points to my other topic "How to switch data online". So let's discuss just talk...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 14, 2010 at 8:14 am

    #1103632

  • RE: How to generate master detail xml file in sql 2005 and 2000

    Creating the XML in that format should not be very difficult, but I'll need some more information from you to continue. Can you post the table DDL for the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 12, 2010 at 3:20 pm

    #1102790

  • RE: Where are you?

    Omaha, Nebraska.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 12, 2010 at 2:00 pm

    #1102743

  • RE: How to switch data online

    I would recommend looking into SQL Server Table Partitioning for this solution. You don't need multiple servers, multiple databases, or multiple tables. Just a well-designed partition strategy (possible...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 12, 2010 at 1:54 pm

    #1102739

Viewing 15 posts - 721 through 735 (of 3,232 total)