SQL Server with Mr. Denny:

ITKE grandparent


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

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


April 20, 2009  11:00 AM

Yes DBAs you really do have to deal with licensing

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server licensing

Probably one of the least fun things about being a DBA is having to deal with the licensing of SQL Server. Continued »


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


December 3, 2008  8:31 AM

Ask your Exchange Server questions to the Exchange MVPs

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

If you are like me you work with Exchange, and probably have to work with Exchange Server at least some times, and you may some all sorts of questions about it.  Well here is your chance to ask some of the top Microsoft Exchange MVPs all those questions.  Combined the MVPs on this chat have over...


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

0 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: