I couldn't help myself.

April 11, 2019 at 9:24 pm

#3135846

My $0.02 about the new site... First, I miss the count of likes (for threads and individual comments). No nobody knows if you "liked" a thread or comment....

How about people that just implement missing index recommendations that create a nonclustered index that is a covering index and recreates the entire table?  Yes, I found one in...

Thank you so much.

And this thread just keeps on keeping on... This is a pure rant, so read at your own risk. I have been involved in the interview process for a...

Great name for a beer!

  Yay. Um, so what are those points redeemable for...

Thank you.

I wonder how you were able to reply on January 1, 2019...

This is easily achieved with a LEFT JOIN and ISNULL combination. Of course, assuming that the second batch of inserts is meant for #tblSectionCoursemaster instead of #tblCombineCourseMaster .

I've had a couple of chats with Steve about our move to a "modern" interface for SQL Server Central. It's insane how badly software is coded these days....

If you go up to your name in the navigation bar, you can get to your profile.  When I did that, what I found was that the site emails...

I’m thinking need to do unpivot and pivot to get below result, is there anyway better then i thought :)..Any help appreciated Thank you in advance.

CREATE...

• This reply was modified 6 years, 5 months ago by Dave Convery.
• This reply was modified 6 years, 5 months ago by Dave Convery.
• This reply was modified 6 years, 5 months ago by Dave Convery.

Apparently, even on Facebook, developers still store passwords as plain text. Facebook claims that there was no security breach and the problem is corrected, but I really wonder  when will...

Two things come to my mind, but seem to be weird cases:
 1. Your tables are partitioned, but it's weird that the partitions are exactly the same size.
 2....