Forum Replies Created

Viewing 15 posts - 5,791 through 5,805 (of 8,731 total)

  • RE: Testing in Production

    It wouldn't be the first time it seems that Apple tests in production. Most iPhone releases had problems. Antennagate[/url]? Apple Maps (1, 2[/url])? Every time a new iOS is released,...

    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

    September 23, 2014 at 9:37 am

    #1747550

  • RE: Insert rows into a table without dropping it

    Just to be clear on what Phil is commenting.

    There's a big difference between SELECT...INTO... and INSERT INTO...SELECT...

    The first option will create a table, the second one will just insert rows....

    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

    September 23, 2014 at 8:58 am

    #1747521

  • RE: Help Needed to Convert Numeric Value to CHAR(7)

    Am I missing something here? Wouldn't a simple LEFT() do the job?

    WITH SampleData AS(

    SELECT RAND(object_id) * 1000 N

    FROM sys.all_columns

    )

    SELECT N, LEFT( N,...

    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

    September 22, 2014 at 2:58 pm

    #1747244

  • RE: How can I run this query for the current days business?

    Without knowing how to identify the Current Day's business, I just can help by leaving this article:

    http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

    That way you don't need to hardcode the date.

    To transfer directly to quickbooks, 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

    September 22, 2014 at 8:48 am

    #1747117

  • RE: Where's the Thread?

    Maybe The Thread just took some days off to enjoy some BBQ. 😀

    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

    September 22, 2014 at 8:45 am

    #1747114

  • RE: Nvarchar Time Calculation

    You shouldn't be storing times as nvarchar. SQL Server has a time datatype (and plenty others datetime types).

    We also have the function DATEDIFF available so we don't have to reinvent...

    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

    September 19, 2014 at 3:31 pm

    #1746834

  • RE: Long running MERGE

    I need to wait for some maintenance tasks to complete (including moving the instance to a not-shared node). After everything completes, I'll give it a try. That was exactly my...

    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

    September 19, 2014 at 12:22 pm

    #1746807

  • RE: Long running MERGE

    The row counts are normal, the normal run should be in under 20 minutes but sometimes it takes really long time to complete.

    The column is not needed, but it doesn't...

    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

    September 19, 2014 at 10:58 am

    #1746792

  • RE: Long running MERGE

    I'm not sure if this is enough:

    Memory 524278 MB

    Processors 80

    cost threshold for parallelism5

    max degree of parallelism4

    Version Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012...

    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

    September 19, 2014 at 10:28 am

    #1746780

  • RE: Issue with CTE

    You're not referencing your CTE on your UPDATE statement. Additionally, you don't have anything to make a relationship (and that's caused by the previous reason).

    You don't actually need a CTE,...

    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

    September 19, 2014 at 10:02 am

    #1746773

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/19/2014)

    HanShi (9/19/2014)

    GilaMonster (9/19/2014)

    Someone's either having the worst day, or is asking interview questions.

    Database goes into Restoring mode

    Performance tuning it so critical can any one plz figure it...

    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

    September 19, 2014 at 8:06 am

    #1746725

  • RE: Find weekdays between 2 dates

    The "Lazy N" was really a mistake on my part. I was going to change it into something descriptive, but I forgot to do it before copying the code.:blush:

    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

    September 18, 2014 at 4:47 pm

    #1746569

  • RE: Find weekdays between 2 dates

    N stands for "Nothing in particular" 😀

    I support your code if it's accompanied by the proper comments describing what it does. I'm not trying to be pedantic, this is more...

    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

    September 18, 2014 at 4:30 pm

    #1746565

  • RE: Pivoting Question

    I haven't tested the following code but it should give you an idea.

    With Rownums AS(

    SELECT *,

    ...

    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

    September 18, 2014 at 3:47 pm

    #1746556

  • RE: Find weekdays between 2 dates

    It's easy when you have the code to generate the Tally Table available.

    Do you know what is a tally table? How is it built here?

    To know more about it, read...

    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

    September 18, 2014 at 2:37 pm

    #1746546

Viewing 15 posts - 5,791 through 5,805 (of 8,731 total)