SQL Server with Mr. Denny:

SQL


July 5, 2011  2:00 PM

What does WITH (NOLOCK) actually mean

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Contrary to popular belief WITH (NOLOCK) isn’t actually the SQL Server “Turbo” button.  While it may appear that way,...

August 9, 2010  11:00 AM

Calculating fibre latency correctly is a must when trying to deturmin storage performance numbers.

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Bookmark and Share     2 Comments     RSS Feed     Email a friend


August 31, 2009  6:26 PM

Difference between an Index and a Primary Key

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

There seams to be some confusion between what a Primary Key is, and what an Index is and how they are...


February 2, 2009  1:31 PM

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

SQL Server has two basics kinds of indexes. They are...


October 20, 2008  11:05 AM

Thank you Orange County SQL Server Users Group

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I'd like to thank the Orange County SQL Server Users Group for having me come and speak at their meeting last week.  I had a great time speaking with everyone, and there were a lot of good questions. If you didn't have a chance to download the slide deck you can download it


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...

Bookmark and Share     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 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: