Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".

How about the rest of you good folks... did anyone else...

SQL would be my first choice for cleaning data, while it's a powerful tool for querying and cleaning data, it may not be the best choice for performing complex...

Hi there! It sounds like you want to create league standings based on game data and team data in different seasons. Here's what you can do:

First, you'll need to...

Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".

How about the rest of you good folks... did anyone else have a...

Thanks, Eirikur.  I appreciate...

Shifting gears a bit...

I ran across an article that had the following statement in it...

"Learning SQL helps us to communicate with databases, but when it comes to cleaning, manipulating,...

@Below86 ,

Looking at what you said, I can really sympathize.  To be sure, my comments were based on people that were actually hired to work with T-SQL day in and...

The appropriate method to shrink a log file for a database in bulk/full recovery model is:

1. put the database in simple mode, full backup

2. shrink the log file,

3. put...

Hey Jeffrey thanks for chiming in.

Let me clarify what’s happening. There is a delete query and an insert query wrapped in a Begin Commit/Rollback Tran. Some of the data...

Yep... I got that and agree.

Again, there...

David... I thought that fighting tooth'n'nail to get something done right was "normal", especially since it wasn't their idea.  And, because it wasn't their idea, they might try to kill...

Nicely written, Nisarg .  And the annotations in the screen shots are helpful and also nicely done.

Ah.  Totally get that.  I'm thinking that they don't actually have a good backup, though and that this is "one of those times".  But, good point.

The "best" way is to anticipate the next question that usually comes...

Ok, so the code that's causing the performance problem...