SQL Server with Mr. Denny:

ITKE grandparent


October 16, 2008  11:00 AM

Handy Query to look at amount of data in Buffer Cache

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Here's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache.  It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk. SELECT...

October 15, 2008  7:07 AM

Attending PASS 2008? Want a free MCP exam?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Microsoft and PASS have announced that you can take a free Microsoft Certification exam.  Visit the


October 13, 2008  11:01 AM

Why is my SELECT COUNT(*) running so slow?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Take a look at the execution plan for your query. You'll notice that the query is doing an Index Scan (or a table...


October 10, 2008  8:04 PM

Database superstition

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Sean McCown posted what I think is an excellent blog post about Database...

0 Comments     RSS Feed     Email a friend


October 10, 2008  11:06 AM

My blogs 1 year birthday

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Well today is the one year birthday of my blog.  It's been a very fun and exciting year.  Here's hoping that the next year will be just as fun.  Denny 2 Comments     RSS Feed     Email a friend


October 8, 2008  1:12 AM

We just moved into our new office in Marina Del Rey, and the view is great.

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

The company I work for just finished our office move into our newer slightly larger office.  I've managed to snag myself a Window seat this time around.  I just wanted to share the view with everyone.  This is the view out my desk window.


October 6, 2008  8:33 AM

Orange County SQL Server User Group has started up

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Orange County now has its own


October 1, 2008  11:00 AM

T/SQL Code to remove SQL Injection Values from your tables

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

With SQL Injection Attacks being all the rage these days, I've been asked a...


September 30, 2008  6:58 PM

SQL Server consolidation: Why it’s an optimization technique

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

This morning I released another tip on SearchSQLServer.com called "SQL Server consolidation: Why...

0 Comments     RSS Feed     Email a friend


September 29, 2008  11:00 AM

Decreasing Network Traffic and Network Latency When Using Replication

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these...


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: