True, but my knowledge of the...

Yelena Varshal (8/25/2008)

---

Steve Jones - Editor (8/25/2008)

---

If you use Google to answer a question geared for your knowledge, such as an exam question, the Question of the Day, etc., then...

marius.draganescu (8/25/2008)

---

Lynn,

It's not all the "distinct" records I need to return, it is all records with a duplicate SSN that I am interested in. I tried the query, and it...

If you are looking for distinct rows (based on the sample data), why the joins, group bys, and having count(*) > 1? I'd think the following would work just...

Timothy (8/25/2008)

---

Jack Corbett (8/25/2008)

---

I have noticed that people have mentioned googling a problem or asking someone else at the office for help on an issue as cheating. I don't...

If you can, I'd test on a much smaller database. If you have access to SQL Server 2005 Developers Edition ($50 USD), you could install it on your desktop,...

Yamachari (8/22/2008)

---

Recording ALL DML operations would be like drinking from a fire hydrant. Throttle it down to only what you really need to monitor and then spend the money...

Then I would carefully test the use of the COPY_ONLY. One of two things will happen. One, it won't work. Two, you may not be able to...

Be careful with the COPY_ONLY option. You may not get what you are expecting. I am assuming that the file group backup is being taken for DR purposes.

😎

Still confused due to a previous post in this thread. Some one had added additional names that had the same SSN as D Duck, and you indicated that those...

Tangent...

Like coming to a complete stop at a 4-way intersect in the middle of no where with no...

One, show us the code you have developed and tried.

Two, create a more represenative set of data that is similiar to what you are working with and what the result...

If it works like most other backup chains, yes, it looks like you need to restore the full backup. the file group backup, then the differential backup.

😎

Out of curiosity, what are the values for the first_lsn, last_lsn, checkpoint_lsn, database_backup_lsn, and last_recovery_fork_guid for these three backups from msdb.dbo.backupset?

😎

I agree with Matt Miller. This is a good candidate for using a tally table.

😎