Forum Replies Created

Viewing 15 posts - 511 through 525 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Thom A - Tuesday, June 5, 2018 11:01 AM

    I know this particular user is a repeat offender for, but I feel they're...

    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 5, 2018 at 12:14 pm

    #1992993

  • RE: FK Limits

    Sean Lange - Tuesday, June 5, 2018 9:29 AM

    The only truly correct answer here would be "way more than you should ever...

    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 5, 2018 at 12:09 pm

    #1992991

  • RE: create table from select

    ScottPletcher - Monday, June 4, 2018 12:26 PM

    SELECT * INTO Title2 FROM Title;

    Not a good idea.  A direct SELECT ... INTO...

    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 4, 2018 at 1:01 pm

    #1992872

  • RE: Can someone lead me to an example for an inline function please

    mw_sql_developer - Friday, June 1, 2018 8:59 AM

    I have checked the internet and here and their people are talking about SCALAR functions...

    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 1, 2018 at 9:53 am

    #1992659

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Wednesday, May 30, 2018 9:09 AM

    Anyone in Nashville this week for Music City Tech?

    If only I...

    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

    May 31, 2018 at 12:01 pm

    #1992528

  • RE: Same stored procedure 5 times vs 5 different procedures

    Naveen PK - Thursday, May 31, 2018 8:50 AM

    Hi, 
    I have ONE report and it has 5 sections. I wrote a stored procedure...

    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

    May 31, 2018 at 8:55 am

    #1992492

  • RE: Why Normalization is not good

    xsevensinzx - Thursday, May 31, 2018 7:39 AM

    It really depends on usage of the database. The often saying is if you want...

    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

    May 31, 2018 at 8:49 am

    #1992490

  • RE: Aggregate Performance Question

    There shouldn't be any performance difference, but the second method might reduce the length of the code by not having to repeat 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

    May 30, 2018 at 11:50 am

    #1992364

  • RE: Inner loop join and Left outer loop join

    Steve Jones - SSC Editor - Wednesday, May 30, 2018 8:35 AM

    Luis Cazares - Wednesday, May 30,...

    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

    May 30, 2018 at 8:47 am

    #1992322

  • RE: Dynamic SQL with Inner Join

    frederico_fonseca - Wednesday, May 30, 2018 5:29 AM

    OP seems to be gone.

    I didn't post any idea or sugestion as I believe that...

    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

    May 30, 2018 at 8:44 am

    #1992320

  • RE: Inner loop join and Left outer loop join

    LOOP, HASH & MERGE are JOIN hints to tell the SQL Server engine what physical operation should use for that specific JOIN. Usually, the engine will choose the best operation...

    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

    May 30, 2018 at 8:31 am

    #1992317

  • RE: Stored procedure running in loop is taking time to load . Is there any alternate way to run in a single execution ?

    amy26 - Wednesday, May 30, 2018 5:53 AM

    I do a lot of DB redesigns, reverse engineering and process reengineering.  I'm amazed at...

    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

    May 30, 2018 at 6:11 am

    #1992282

  • RE: Cursor - loops but doesn't insert into table.

    That's because it wasn't running anything inside the cursor to reference all the databases. With the changes, it tried to read from the databases and the permissions came into effect.

    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

    May 24, 2018 at 1:33 pm

    #1991893

  • RE: Using FORMAT() for Dates

    patrickmcginnis59 10839 - Thursday, May 24, 2018 9:47 AM

    Yeah if you are spending several hours a week because of format then...

    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

    May 24, 2018 at 10:01 am

    #1991835

  • RE: Getting an average UPDATED

    The current description seems to be a basic aggregate query using AVG(). We just want to know if something else is missing.

    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

    May 24, 2018 at 9:54 am

    #1991832

Viewing 15 posts - 511 through 525 (of 8,731 total)