Yes dwain.c, that would work as well! Thanks for the input.

Wow!!! That is fantastic! Thank you so much!

My father is from Germany and our lastname is short on vowels. There is only one and the last three letters are consonants. People inevitably want to put...

Not sure I want to throw this out there, but here goes... I deal with some very large tables and count(*) or count(PrimaryKey) performs horribly at times. When I...

Jeff Moden (9/19/2013)

---

Erland Sommarskog (9/19/2013)

---

The syntax UPDATE FROM is scorned by some people, because it has a possible ambiguity. I don't share that opinion, because I think that rightly used...

Wow!! Very cool! Thank you!

Correct. The query window is running only one of those. And in another query window, I'm checking the table as it runs (using sp_spaceused because it is so...

Thank you for the very detailed explanation Craig! That is exactly what I need. That pivot query was very, VERY helpful. I was able to see how...

Thank you for your reply Naga. Yes, it is a lot of information. I tried to be real methodical but it just made for a very long post!...

Good question. There is another server in this whole configuration, let's call it Server 1. That's what the end users are hitting and updating. Server A copies...

Server A processes data in WarehouseDB at midnight every night. As soon as that is done, the transaction log is backed up. Server B then has a job...

GilaMonster (2/20/2013)

---

Am I correct in saying that the WarehouseDB that you're trying to restore logs to was online and usable before you started? You set the DB to read only...

Dilip -

Click the link at the top (or bottom) of the article that indicates "This Article is part of the Stairway Series: Stairway to SQL Server Reporting Services." That...

Another option:

SELECT pd.CustID

FROM Product_Details pd

LEFT JOIN (SELECT CustID FROM Product_Details WHERE ProdID = 0) c ON pd.CustID = c.CustID

WHERE pd.ProdID IN (1, 4)

AND c.CustID IS NULL

GROUP BY pd.CustID

HAVING COUNT(*) =...

This is SO cool!! Someone from this distinguished community simply MUST end up in the 15 finalists!!!