SQL Server with Mr. Denny:

i5


January 28, 2008  8:00 AM

Guide to Installing SQL 2000 and SQL 2005 on the same machine

Denny Cherry Denny Cherry Profile: Denny Cherry
i5

You can install SQL 2000 and SQL 2005 on the same machine.  I always recommend that they be installed in this order to try and get everything working as best as possible.

  1. Install SQL 2000
  2. Install SQL 2005
  3. Install SQL 2000 SP4 (Or the latest service...

January 21, 2008  8:00 AM

Virtualizing SQL Server? When to and when not to.

Denny Cherry Denny Cherry Profile: Denny Cherry
i5

Virtualizing servers is huge right now.  And thanks to 0 Comments     RSS Feed     Email a friend


January 14, 2008  8:00 AM

Log Shipping without SQL Server Enterprise Edition

Denny Cherry Denny Cherry Profile: Denny Cherry
i5

Microsoft's Log Shipping is pretty good.  But it requires that you have SQL Server Enterprise...


December 10, 2007  8:00 AM

Temp Tables, Table Variables, and CTEs

Denny Cherry Denny Cherry Profile: Denny Cherry
i5

There are some major differences between temp tables, table variables and common table expressions (CTEs).  Some of the big differences are: Temp Tables vs. Table Variables

  1. SQL Server does not place locks on table variables when the table variables are used.
  2. Temp tables...


November 21, 2007  7:00 AM

Thanksgiving is tomorrow, spend the day with family.

Denny Cherry Denny Cherry Profile: Denny Cherry
i5

I know that this is normally a technical blog, but with the US Thanksgiving day holiday coming tomorrow I wanted to be sure to point out that time needs to be made out of our busy work schedules to make sure that we spend time with our families.  It's very important that we find a good balance...


October 31, 2007  6:09 AM

What is Service Broker?

Denny Cherry Denny Cherry Profile: Denny Cherry
i5, Migration

Service Broker is a transaction message queueing system build into Microsoft SQL Server.  It provides you with in order, guaranteed single read, message processing that is handled and managed with T/SQL code.  This makes it extremely easy to send and process messages either within a single...


October 25, 2007  6:03 PM

New tip published about table statistics

Denny Cherry Denny Cherry Profile: Denny Cherry
i5

My next tip on SQL Server Statistics has been published on SearchSQLServer.com entitled 0 Comments     RSS Feed     Email a friend


October 22, 2007  10:17 AM

How SQL decides how much procedure cache and how much buffer cache to use.

Denny Cherry Denny Cherry Profile: Denny Cherry
i5

There are two main types of cache which SQL...


October 18, 2007  6:18 PM

Excellent Lock Pages in Memory Blog

Denny Cherry Denny Cherry Profile: Denny Cherry
DNS, i5

Bob Ward of Microsoft has written an excellent blog about the lock pages is memory right over on the PSS blog.


October 11, 2007  2:15 AM

Great little database comic strip.

Denny Cherry Denny Cherry Profile: Denny Cherry
Firewalls, i5

While waiting for an index to be created I ran across this little beauty over at http://xkcd.com.  I just had to share it. Exploits of a Mom


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: