SQL Server with Mr. Denny:

ITKE grandparent


November 3, 2011  5:06 PM

SQL Server 2012 Licensing Changes

Denny Cherry Denny Cherry Profile: Denny Cherry
Microsoft licensing, SQL Server, SQL Server 2012, SQL Server licensing

So you may have heard earlier today about the license changes that are coming out for SQL Server 2012.  I know that the official announcement can be a little hard to get through and the changes can be a little confusing at first (or even second or third) glance.  The SQL Server licensing team was...

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


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


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


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: