I'm confused on that one. How were you planning to get the differential backups on to the target machine? Log Shipping works in pretty much the same manner -...

That's cool. Didn't know about the NTILE function. Wish I'd had that about 6 years ago. It would have made my life a lot easier. Of course, we would...

Sounds like you might want to consider log shipping or some flavor of it instead of differentials. That would give you the ability to look at your DB and...

Keep forgetting about the Row_Number function, even though I've used it. SQL 2000 and lower habits are pretty deeply entrenched. 😛

Thanks for the reminder about that one.

Joe's code is pretty good for this - build a temporary set with some Identity-type column. Div or Mod that appropriately and compare the remainders. (I'd probably do integer division,...

--Duplicate Comment removed. Somehow the original never reported success. Sorry.

Speaking as one of those sending out quite a bit of info from the conference keynotes, I think that your observations are accurate. There was a lot of information going...

Raj,

If you add that expression, you will indeed not have a NULL in the column, but that doesn't help the case where there was actual data in the...

I appreciate the visualization. Does this work with both FoxPro and Paradox DBF files? My issue was trying to load a Fox DBF using that technique. I could never...

I guess I can see both sides, but fall more on the frustrated consumer side. Most eval editions have some way of being unlocked or registered to become a full...

We've recently hit a similar snag in trying to see if candidates are a good fit or not. It's one thing to go through the interview and get good answers,...

Well, the PDF option isn't really a good one for me. Our ERD's are a little too big to be easily readable in that format without some serious taping. The...

Printing to PDF for most ERD's is pretty difficult to do unless you can finagle some pretty large page sizes for your ERD Images. You can export your images...

How long has it been since ER/Studio had the export to HTML Report option? I use that pretty regularly and push it to a file share. The only major issue...

I generally tend to agree with this, but the disappearing act is more often a detriment to the career of a DBA. Few people remember that the servers ran for...