Forum Replies Created

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

  • RE: Why do they not listen?

    Koen Verbeeck (9/29/2014)

    Hire an overpriced consultant. Chances are they'll listen to him/her...

    The problem is these overpriced consultants are also full of overpriced crappy code. These are the people who consultants...

    September 29, 2014 at 3:34 pm

    #1748954

  • RE: Row Size Limitation

    I know that this is not neccesarily your design but starting all your table names with tbl_ and storing the datatype used in the column name is a seriously poor...

    September 29, 2014 at 1:05 pm

    #1748917

  • RE: Is there any alternate way for pivot

    Did you actually read the comments I posted about performance I posted on your thread on this exact same topic from yesterday? Here is the link in case you forgot....

    September 26, 2014 at 2:05 pm

    #1748605

  • RE: Hiding my work with encryption

    drew.georgopulos (9/26/2014)

    Yes, it was a dopey way to conceptualize the implementation and the product needs to be a web service.

    Thank you both very much for the advice.

    Drew

    Happy to help. Sometimes...

    September 26, 2014 at 12:49 pm

    #1748585

  • RE: sys.sql_modules truncating definition

    rxm119528 (9/26/2014)

    I have a procedure around 2500 lines. When i try to get the definition of the procedure using sys.sql_modules , it is getting truncated.

    I was of the asassumptionhe sys.sql_modules...

    September 26, 2014 at 12:47 pm

    #1748583

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/26/2014)

    In terms of spammers, the devs are testing askimet, which looks to prevent some posts from spammers. I also spent some time writing a job...

    September 26, 2014 at 12:33 pm

    #1748581

  • RE: Order by numeric doesn't work

    Shelley Allen (9/26/2014)

    the select statement in the join orders the numbers asc and if you run everything below the case statement it works, but as you run the whole thing...

    September 26, 2014 at 10:06 am

    #1748559

  • RE: Order by numeric doesn't work

    Let's start with some formatting. You can use the IFCode shortcuts (on the left side when posting) for code windows and such.

    UPDATE tblObjectType3_14

    SET [FldNumeric23764] = CASE

    WHEN tID = 1

    AND...

    September 26, 2014 at 9:26 am

    #1748543

  • RE: Help avoiding temp table with string of IDs passed into stored procedure

    The bigger issue is the way you are doing this it is now wide open to sql injection. Do you need to use varchar(max)? Can you fit your list inside...

    September 26, 2014 at 9:23 am

    #1748541

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/25/2014)

    Alvin Ramard (9/25/2014)

    Eirikur Eiriksson (9/25/2014)

    Alvin Ramard (9/25/2014)

    Eirikur Eiriksson (9/25/2014)

    Alvin Ramard (9/25/2014)

    Eirikur Eiriksson (9/25/2014)

    SQLRNNR (9/25/2014)

    Lynn Pettis (9/25/2014)

    Sean Lange (9/25/2014)

    Between the spammers and crussell commenting on every single QOTD from...

    September 25, 2014 at 4:10 pm

    #1748349

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/25/2014)

    Alvin Ramard (9/25/2014)

    Question: Explain what DBCC TimeWarp is. 😀

    I have used that question during an interview. It is a fun one.

    That is hilarious!!! Hopefully the response was...

    September 25, 2014 at 3:41 pm

    #1748336

  • RE: Are the posted questions getting worse?

    Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I am concerned that many...

    September 25, 2014 at 2:20 pm

    #1748307

  • RE: Like and Pivot is slowing down the stored procedure results.

    mcfarlandparkway (9/25/2014)

    Thank you for helping me champion,I am very new to optimization techniques.

    Will you please format my view code into CTE please?

    btw, my name is Sean. Just as your is...

    September 25, 2014 at 2:16 pm

    #1748305

  • RE: Like and Pivot is slowing down the stored procedure results.

    mcfarlandparkway (9/25/2014)

    Hi champion,

    Do you prefer to use temporary tables,like...

    September 25, 2014 at 1:47 pm

    #1748298

  • RE: Like and Pivot is slowing down the stored procedure results.

    mcfarlandparkway (9/25/2014)

    Hi champion,

    Thanks for replying,ya its popping a lot...

    September 25, 2014 at 1:45 pm

    #1748297

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