Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 8,731 total)

  • RE: A SQL Server Date Handling Issue

    Ken Hiatt (6/21/2016)

    dhaveedh (6/21/2016)

    Ken Hiatt (6/20/2016)

    This was definitely wrong on many levels, but what strikes me is that they are expecting to extract a time from the first 8 characters...

    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

    June 21, 2016 at 1:09 pm

    #1886107

  • RE: Tables, Primary Keys and Clustered Indexes

    andymay-496937 (6/20/2016)

    While I agree that a well designed transactional DB needs referential integrity, I question the logic of doing it in a data warehouse situation

    Check this out. Be sure to...

    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

    June 21, 2016 at 12:32 pm

    #1886102

  • RE: Daily redresh of a small table from Oracle to SQL Server - Options/Best approach

    It depends on the Oracle driver used by SSIS. I had the bad experience on having a very slow one.

    A faster option was to export to a flat file and...

    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

    June 21, 2016 at 10:39 am

    #1886076

  • RE: Today's Random Word!

    Revenant (6/21/2016)

    Ray K (6/21/2016)

    djj (6/21/2016)

    Roller

    Derby

    Hat

    Sombrero

    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

    June 21, 2016 at 10:30 am

    #1886074

  • RE: is there any over head of begin try cahce ?

    rajemessage 14195 (6/21/2016)

    i thought like transaction blocks , so it will also block

    yours sincerely

    Blocking is not a bad thing. It's used to keep data integrity.

    Excessive blocking is a problem and...

    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

    June 21, 2016 at 10:14 am

    #1886073

  • RE: How do I import text file delimited with three Pipes |||

    Remove the braces and just leave the pipes. Then click refresh.

    If it doesn't work, copy the delimiter from the file and paste it in the column delimiter field.

    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

    June 21, 2016 at 9:24 am

    #1886062

  • RE: Help me in adding dynamic pivot dates

    J Livingston SQL (6/21/2016)

    Luis Cazares (6/21/2016)

    GA_SQL (6/21/2016)

    Working has Expected

    Do you understand how it works? Remember that you'll be the one supporting it.

    Hi Luis

    have you seen this other thread from OP?

    http://www.sqlservercentral.com/Forums/FindPost1796115.aspx

    this...

    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

    June 21, 2016 at 9:01 am

    #1886057

  • RE: Help me in adding dynamic pivot dates

    GA_SQL (6/21/2016)

    Working has Expected

    Do you understand how it works? Remember that you'll be the one supporting 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

    June 21, 2016 at 8:44 am

    #1886046

  • RE: DATEPART / DATENAME

    Adding to Phil's comment. Your second example is using an integer. This integer is being converted to a datetime before applying the datename function. The number 2 is converted to...

    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

    June 21, 2016 at 6:53 am

    #1886010

  • RE: A SQL Server Date Handling Issue

    Mad Myche (6/20/2016)

    Luis Cazares (6/20/2016)

    The code mentioned here isn't the problem. The problem comes from the database design. Dates shouldn't be stored as strings or integers. We also need to...

    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

    June 20, 2016 at 12:40 pm

    #1885906

  • RE: is there any over head of begin try cahce ?

    rajemessage 14195 (6/20/2016)

    hi,

    i wanted to know , is there any overhead of begin try cache,

    like is there any situation it takes more resources , so i will use it causesly.

    yours...

    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

    June 20, 2016 at 9:53 am

    #1885884

  • RE: Today's Random Word!

    Revenant (6/20/2016)

    Ed Wagner (6/20/2016)

    Grumpy DBA (6/20/2016)

    Ray K (6/20/2016)

    Rogue

    Ales & Spirits

    Bar

    Tender

    Chicken

    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

    June 20, 2016 at 9:45 am

    #1885882

  • RE: Help me in adding dynamic pivot dates

    This is what I got from your code, you might need to tweak it.

    To understand how it works, you can read the following articles:

    http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    http://www.sqlservercentral.com/articles/Crosstab/65048/

    DECLARE @fromdate datetime = '2014-08-01',

    ...

    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

    June 20, 2016 at 9:20 am

    #1885878

  • RE: A SQL Server Date Handling Issue

    The code mentioned here isn't the problem. The problem comes from the database design. Dates shouldn't be stored as strings or integers. We also need to know if the time...

    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

    June 20, 2016 at 8:34 am

    #1885862

  • RE: Today's Random Word!

    Ed Wagner (6/20/2016)

    djj (6/20/2016)

    ThomasRushton (6/20/2016)

    Ed Wagner (6/20/2016)

    TomThomson (6/18/2016)

    Hugo Kornelis (6/18/2016)

    mjagadeeswari (6/17/2016)

    Ray K (6/17/2016)

    Murphy's Law ("If anything can go wrong, it will") 😛

    Law of Selective Gravity ("An object will fall so...

    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

    June 20, 2016 at 8:13 am

    #1885856

Viewing 15 posts - 2,641 through 2,655 (of 8,731 total)