SQL Server with Mr. Denny:

May, 2009


May 7, 2009  11:00 AM

Pull vs. Push Subscriptions? Which one should you use?

Denny Cherry Denny Cherry Profile: Denny Cherry

This is a "it depends" sort of question. These are my recommendations, your mileage may vary. Your distributor is on the same system as your publisher - Pull is probably for you Your Subscribers are a very high transaction count - Push is probably for you You need to manually copy the...

May 4, 2009  11:00 AM

How can I remove duplicate records in my tables?

Denny Cherry Denny Cherry Profile: Denny Cherry

All to often we end up with duplicate rows in a table.  The best way to keep duplicate rows out of the database is to not let them in.  But assume that they are there.  This bit of sample code shows how to delete those duplicate rows quickly and easily in a single statement.  No temp tables...


May 1, 2009  5:03 AM

Should I install an Anti-Virus software on my server?

Denny Cherry Denny Cherry Profile: Denny Cherry

Yes, for crying out loud yes. Every server that can access the Internet or be access from the Internet, or that can be accessed from a computer that can access the Internet should have an anti-virus on it.  Preferably a corporate wide solution like Bookmark and Share     2 Comments     RSS Feed     Email a friend


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: