Forum Replies Created

Viewing 15 posts - 151 through 165 (of 178 total)

  • RE: Display More Than 8000 Characters (SQL Spackle)

    nigel. (1/27/2011)

    Thanks Jeff, nice article.

    Spotted a minor typo in the first code example, has SliceDate instead of SliceData for the column alias.

    I know it has no real effect....

    January 27, 2011 at 7:22 am

    #1279068

  • RE: Unexpected View Performance

    Thanks for posting this. I found it very insightful and relieving because I thought I was the only person that missed things like this. It took you a...

    January 11, 2011 at 8:02 am

    #1271893

  • RE: Sorting Months By Number (SQL Spackle)

    Steve Jones - SSC Editor (11/15/2010)

    ejoell 66477 (11/15/2010)

    IE would not permit horizontal scrolling to display either of your queries so I have no idea of what you are proposing. ...

    November 15, 2010 at 8:33 am

    #1250767

  • RE: Sorting Months By Number (SQL Spackle)

    ejoell 66477 (11/15/2010)

    IE would not permit horizontal scrolling to display either of your queries so I have no idea of what you are proposing. Shame too as I was...

    November 15, 2010 at 8:31 am

    #1250763

  • RE: Life Without a Net

    Ron Porter (11/2/2010)

    I think that the Internet is just one more step along the 'just in time' path. So much of what we've done over the last several thousand years...

    November 2, 2010 at 9:22 am

    #1245487

  • RE: Life Without a Net

    I rarely (and I mean RARELY) use bookmarks/favorites. Not using bookmarks forces me to keep a sharp "search" ability. I've always felt my memory was bad and leaning...

    November 2, 2010 at 8:41 am

    #1245438

  • RE: A Faster BETWEEN Dates

    terrance.steadman (11/1/2010)

    I enjoy learning new and different ways of solving a problem. I can list ways I had solved them here and learn from others who have better knowledge...

    November 1, 2010 at 7:47 am

    #1244824

  • RE: A Check and Foreign Key Constraint Improves Query Performance

    Oh WOW...I just discovered that 99.9% of our FK's are NOT TRUSTED! Out of 1,297 FK's, only ONE is trusted.

    We use an enterprise software package that is about 10...

    October 21, 2010 at 9:09 am

    #1240388

  • RE: Automate Your Backup and Restore Tasks

    "I started as I do with most things by over complicating the solution! "

    LOL, I thought I was the only person that did that.

    I usually refer to it as making...

    October 5, 2010 at 7:25 am

    #1231680

  • RE: Eliminating Duplicate Rows using The PARTITION BY clause

    trubolotta (9/22/2010)My own experience indicates that datra cleansing is a highly variable problem and requires ingenuity and coding expertise, but it is also a one-shot deal.

    Roger that. In my...

    September 22, 2010 at 8:08 am

    #1225616

  • RE: Eliminating Duplicate Rows using The PARTITION BY clause

    @trubolotta Not trying to start an argument here, but hindsight is 20/20 for everyone. Sometimes we find ourselves in a situation like the OP is describing...

    September 22, 2010 at 7:41 am

    #1225581

  • RE: The Breakfast Plan Goes Awry

    Eric Russell 13013 (6/30/2010)

    thisisfutile (6/30/2010)

    Typically our boss brings in donuts on Friday. From time-to-time he doesn't bring any. According to some of the attitudes on this forum (but...

    June 30, 2010 at 9:47 am

    #1187190

  • RE: The Breakfast Plan Goes Awry

    Typically our boss brings in donuts on Friday. From time-to-time he doesn't bring any. According to some of the attitudes on this forum (but not exclusive to this...

    June 30, 2010 at 8:56 am

    #1187151

  • RE: Do you know your getdate()?

    thisisfutile (5/12/2010)

    JacekO (5/12/2010)

    If anyone of you got the 3.33 ms on a 32 bit box please reply with more specifics on the OS, CPU and SQL Server version.

    My XP workstation...

    May 12, 2010 at 7:51 am

    #1166213

  • RE: Do you know your getdate()?

    JacekO (5/12/2010)

    If anyone of you got the 3.33 ms on a 32 bit box please reply with more specifics on the OS, CPU and SQL Server version.

    My XP workstation is...

    May 12, 2010 at 7:40 am

    #1166202

Viewing 15 posts - 151 through 165 (of 178 total)