Forum Replies Created

Viewing 15 posts - 5,776 through 5,790 (of 8,761 total)

  • RE: Update / Insert statement

    .Netter (4/5/2015)

    Can someone help me with this please

    Quick thought, you cannot mix dynamic and static sql in this way, better do a full dynamic statement. Also you should work through...

    April 6, 2015 at 12:32 am

    #1788841

  • RE: CTE Syntax

    xsevensinzx (4/5/2015)

    GilaMonster (4/5/2015)

    Grant Fritchey (3/31/2015)

    Steve Jones - SSC Editor (3/31/2015)

    Grant Fritchey (3/31/2015)

    I use semicolons on terminators for all my statements. Everyone should.

    You do or Prompt does it for you?

    Well, Prompt...

    April 5, 2015 at 11:42 pm

    #1788839

  • RE: Running Total Performance

    Jeff Moden (4/5/2015)

    Eirikur Eiriksson (4/5/2015)

    here is a partial testing code which strongly indicates that the original testing is somewhat flawed.

    Sorry... I don't have the time to wade through a ton...

    April 5, 2015 at 5:33 pm

    #1788819

  • RE: Conversion Failed Varchar to Int - Why ??

    homebrew01 (4/5/2015)

    Why does this cause an error ??

    Seems that SQL should just care if @Col_Input is NULL or not. If so convert the 0 to ' 0...

    April 5, 2015 at 5:21 pm

    #1788817

  • RE: Running Total Performance

    Jeff Moden (4/4/2015)

    Got code and test data for that, Eirikur? And what is wrong with Wayne's test harness? Please be sure to include yours.

    Thought you would be interested;-)

    Still...

    April 5, 2015 at 5:03 pm

    #1788815

  • RE: SPROC with XML

    Quick question, did you have a look at this thread?

    😎

    April 4, 2015 at 3:22 pm

    #1788777

  • RE: dbcc checkdb ("master") with no_infomsgs runs forever, does not stop

    pbyrum (4/2/2015)

    I plan to reboot the server to free up memory. There is not enough memory to run the DBCC command.

    Quick question, what are the server's specs and configs?

    😎

    April 4, 2015 at 3:13 pm

    #1788776

  • RE: If Celko was a rock star, which one would he be?

    TomThomson (4/4/2015)

    chrisn-585491 (4/1/2015)

    Joe is definitely Keith Richards.

    “The select's easy, but the join is another thing...”

    But I'm not here just to write books and make money. I'm here to say...

    April 4, 2015 at 3:01 pm

    #1788775

  • RE: Inserts causing locking - HELP!

    Further on the advices already posted, look at the overall "health" of the server, often it doesn't take much for issues such as the one you've described to surface simply...

    April 4, 2015 at 2:58 pm

    #1788774

  • RE: hash value data types don't match

    t.mounika01 (4/3/2015)

    I am trying to use a multiple hash and then trying to look if the record exists or not using the lookup transform.

    In the lookup, the data...

    April 4, 2015 at 2:46 pm

    #1788773

  • RE: Adding Windows Local Groups using SQLCLR (SQL Server 2012)

    Solomon Rutzky (4/3/2015)

    fw200811 (4/3/2015)

    Moved to SQL Server 2012 specific forum.

    Link to moved post?

    That would be here

    😎

    Edit: Fixed link

    April 4, 2015 at 2:43 pm

    #1788772

  • RE: Are the posted questions getting worse?

    TomThomson (4/4/2015)

    Interesting new site bug. The author and date information for QotD seems to be pretty random - no connection with reality unless you are lucky. What...

    April 4, 2015 at 2:10 pm

    #1788770

  • RE: Running Total Performance

    Kathi Kellenberger (4/4/2015)

    In your test, are you just performing the update or are you also selecting the data?

    I'm selecting the data into "bucket" variables

    😎

    Edit: typo^2

    April 4, 2015 at 1:25 pm

    #1788768

  • RE: Running Total Performance

    Kathi Kellenberger (4/4/2015)

    I'm not an expert on the Quirky Update, but don't you have to run the update which reads the entire table and then select the data after that...

    April 4, 2015 at 1:12 pm

    #1788766

  • RE: Running Total Performance

    Kathi Kellenberger (4/4/2015)

    Jeff -- For the running totals functionality, I think the performance is pretty good if you use ROWS and have the correct index in place. Where I really...

    April 4, 2015 at 12:55 pm

    #1788765

Viewing 15 posts - 5,776 through 5,790 (of 8,761 total)