Is this coming to you in a file?

Probably, but even with EOMONTH available I still find myself calculating it since I have been doing that way for so long.  You just have to look at my inactive...

Yes, we do have the EOMONTH function, but it is good to know how to calculate the...

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and hit a...

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and hit a wall of...

A guess, you changed the database collation but that would not affect the collation of the character columns created under the old collation.  I would start looking there.

run a quick dbcc opentran against that database - then figure out what that spid is doing

it might not be as bad as john says. it could be a...

I will answer Frederico and Lynn. First, I've checked that output is the same, at least in my test database (not the one that I've uploaded, which has only...

Which comes back to your sample database.  I haven't had a chance to download it yet, but from the discussion I am wondering if the results from your original code...

Hi,

I noticed the author used an ID column of IDENTITY as the PK in every table. This appears to be a best practice based on what i've  read...

Here is the thing, I would not separate out the ZIP CODE (postal code) or the City from the address.  Many businesses make use of third parties to validate customer...

Nice article!

My only quibble is your last example, adding a zip code table. The problem is that zip code and city do not have  a 1:1 correspondence. It is...

Not sure why you are focusing on logical reads.  You do realize that those are reads from memory, and depending on how much data you are accessing, that number could...

I was trying to keep people from posting on the other threads as well, which is why two of them referenced back to the thread I actually replied on.

SELECT ABC, COUNT(ABC) FROM dbo.YourTableNameHere GROUP BY ABC;