Forum Replies Created

Viewing 15 posts - 361 through 375 (of 4,080 total)

  • RE: Needing some help - Moving data from one table to multiple

    Don't be afraid to read through the input data three times. Reading through a table is very fast compared to the cost of doing individual inserts.

    Also, you might...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 21, 2016 at 12:14 pm

    #1896525

  • RE: Calculation help...

    =([TotalStaffedTime] - [IdleTime]) - ([ContactTalkTime]+[PostCallProcessingTime]+[DNOutExtTalkTime]) / [TotalStaffedTime] - [IdleTime]

    You're dividing by TotalStaffedTime. Apparently you have cases where TotalStaffedTime = 0. What do you...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 19, 2016 at 4:34 pm

    #1896459

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/18/2016)

    I guess it's my turn in the proverbial barrel.

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

    For this, you wear the HAT OF SHAME.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 18, 2016 at 6:29 pm

    #1896279

  • RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

    Jeff, why are you quoting yourself now?

    Guys, I agree that minimizing the logical reads is always a good idea. My point was that the article espoused accepting more...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 18, 2016 at 11:06 am

    #1896220

  • RE: SOME/ANY/ALL

    George, I read and understand what you are saying, but I have run the queries multiple times with ANSI_NULLs OFF and ANSI_NULLS on.

    * Query 1...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 18, 2016 at 9:47 am

    #1896197

  • RE: Indexes

    Christian, just in case you're still following this thread. The answer that we all agree on is that the correct index choice depends on the particular usage of...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 17, 2016 at 3:17 pm

    #1896051

  • RE: Indexes

    christiandreyer (8/17/2016)

    Hello all,

    1) Should every primary key in a table be a clustered index so that data is organised?

    As a general rule, yes. There may be...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 17, 2016 at 1:45 pm

    #1896022

  • RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

    Stephen Randolph (6/29/2015)

    When it comes to views, I never join views to views.

    Amen

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 16, 2016 at 1:12 pm

    #1895759

  • RE: Today's Random Word!

    ThomasRushton (8/16/2016)

    whereisSQL? (8/16/2016)

    Grumpy DBA (8/16/2016)

    djj (8/16/2016)

    Rocket

    Richard

    Canada

    Dry

    Martini

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 16, 2016 at 9:15 am

    #1895689

  • RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

    Interesting discussion, but I am concerned about the casual dismissal of the number of logical reads. A consequence of more logical reads is that, in a busy system,...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 16, 2016 at 9:03 am

    #1895686

  • RE: String or binary would be truncated error.

    Thank you for setting the problem up so nicely.

    The problem is that something about the REPLACEs below is limiting your result below to NVarchar(4000).

    When your outer replace goes over that...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 15, 2016 at 11:03 pm

    #1895557

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/15/2016)

    ChrisM@Work (8/15/2016)

    Steve Jones - SSC Editor (8/15/2016)

    ChrisM@Work (8/15/2016)

    Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 15, 2016 at 10:03 pm

    #1895556

  • RE: Today's Random Word!

    Ed Wagner (8/15/2016)

    whereisSQL? (8/15/2016)

    Y.B. (8/15/2016)

    Manic Star (8/15/2016)

    HappyGeek (8/15/2016)

    Luis Cazares (8/15/2016)

    whereisSQL? (8/15/2016)

    Revenant (8/15/2016)

    Ray K (8/15/2016)

    Ed Wagner (8/15/2016)

    djj (8/15/2016)

    Grumpy DBA (8/15/2016)

    djj (8/15/2016)

    Ed Wagner (8/15/2016)

    Sweet

    Treat

    Trick

    Joke

    Puzzle

    Jigsaw

    Tools

    Power

    Unlimited

    Opportunities

    Scam

    Spam

    Eggs

    Ham

    Pork

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 15, 2016 at 9:56 pm

    #1895555

  • RE: Streaming itvf in CLR to replace special characters

    Hey Lynn,

    A quick example follows. It needs a lot of polish, but I just wanted to illustrate the concept.

    Like other SQL splitters, this shouldn't be used for strings...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 12, 2016 at 2:41 pm

    #1895301

  • RE: Streaming itvf in CLR to replace special characters

    Lynn, have you tried using your tally table and substring([input],N,1) to reduce the [input] string to a series of individual characters?

    You could put all your special codes to be...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

    August 12, 2016 at 1:46 pm

    #1895289

Viewing 15 posts - 361 through 375 (of 4,080 total)