Forum Replies Created

Viewing 15 posts - 6,091 through 6,105 (of 8,731 total)

  • RE: How to get most recent and oldest from the the joins to a child table

    Here are 2 more options that you could test. I'm not sure if they're any better, but at least they read the tables just once. The second one should be...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 4:29 pm

    #1731981

  • RE: Replace a carriage return in SSIS

    What about using "|{CR}{LF}" as a column delimiter?

    Then you can remove the additional carriage return on your last column in another step.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 3:44 pm

    #1731968

  • RE: Get next 2 weeks

    You have 2 options:

    - Normalize your table

    - Use dynamic SQL

    You decide.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 2:57 pm

    #1731952

  • RE: DevOps

    Gary Varga (7/23/2014)

    TomThomson (7/23/2014)

    I rather agree with Patrick's comment above - but I read the rubbish and got steadily more appalled as I went through it. A (Python) Programmer...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 1:37 pm

    #1731936

  • RE: I'm totally new. Need some guide on SQL 2012

    kimmedim (7/23/2014)

    Hey again guys.. I gotta be completely honest. I don't udnerstand a thing now after the data-type chapter.. It's like I'm reading a bunch of codes I don't know...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 12:24 pm

    #1731901

  • RE: Problem with Round

    The problem is that one query is summing the values before rounding and the other one is summing the values after rounding. You need to define which option do you...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 11:23 am

    #1731861

  • RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

    Just to be clear, the file doesn't need to be on the same server as SQL Server. Typically, the files will be stored in a separate location and referenced by...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 9:45 am

    #1731816

  • RE: IN / JOIN / EXISTS giving same performance in a query.

    Seems like you have some stale statistics on worker_custom_field. Also, why are you using all those NOLOCK hints? Are you aware that you might get incorrect results that include duplicate...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 23, 2014 at 8:53 am

    #1731782

  • RE: Please help me debug this SQL

    Lots and lots of tables. It's hard for us because we don't know your schema and we can't test anything.

    Try looking for columns that are defined as strings which are...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 22, 2014 at 3:49 pm

    #1731606

  • RE: Database Designing Related

    You could read the Stairway to Database Design[/url] on this site.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 22, 2014 at 12:41 pm

    #1731555

  • RE: Database Designing Related

    This sounds like homework. Designing a DB is a lot of work and you should go step by step with the design.

    You have a good example with the AdventureWorks...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 22, 2014 at 11:16 am

    #1731513

  • RE: Question about Parsing and Case Statement

    This solution might be slow for large volumes of data but does what you need. Any option will be slow because you have seven values in one column and that's...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 22, 2014 at 10:51 am

    #1731507

  • RE: DevOps

    Steve Jones - SSC Editor (7/21/2014)

    We just thought we were part of the same team.

    That's so important and the path to successful projects. When communication and/or collaboration stops, problems arise.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 22, 2014 at 10:24 am

    #1731492

  • RE: SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

    It's a nice article, short and simple.

    However, I would have liked if you specified one of the main problems I've seen with beginners (including me) which is that the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 22, 2014 at 10:18 am

    #1731489

  • RE: Taking long time for a single table execution

    Are you measuring the time to retrieve the 4 million rows? or are you including the time to show them?

    What are you expecting to get? if you're querying the full...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    July 22, 2014 at 10:04 am

    #1731486

Viewing 15 posts - 6,091 through 6,105 (of 8,731 total)