SQL Server with Mr. Denny:

SQL


November 30, 2007  8:00 AM

New Article: Tricks to increase SQL Server query performance

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've published a new tip over on SearchSQLServer.com entitled " 0 Comments     RSS Feed     Email a friend

November 19, 2007  8:00 AM

Microsoft Announces SQL Server 2008 November CTP

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Microsoft announced at TechEd in Barcelona, Spain that the SQL Server 2008 November CTP would be made available this month.  Read more here. ---> Update... Microsoft...


November 15, 2007  7:23 PM

New tip published: Update SQL Server table statistics for performance kick

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've published a new tip over at SearchSQLServer.com entitled Update SQL Server table...

0 Comments     RSS Feed     Email a friend


November 14, 2007  8:00 AM

Make sure that your environmentals are setup correctly

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

When you setup your data center, something that seams to be getting overlooked these days is the data center environmentals.  We all know that we need batteries and a generator for the power to keep the servers online, and that we need AC to keep them cool.  But I've seen a disturbing number of...


November 12, 2007  7:32 AM

What’s the benefit of 64bit?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

There are a several benefits of moving to 64bit hardware. 64bit hardware supports more CPUs than 32bit hardware. In addition the 64bit...


November 7, 2007  8:13 AM

Making time for the family.

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Working in IT can be a fun and exciting career, however it can also be an extremely demanding one.  When working in IT you have to find a...


November 5, 2007  8:00 AM

What is the BACKUPTHREAD wait type?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

If you have ever seen the BACKUPTHREAD wait type in the sysprocesses table or sp_who2 output and wondered what it is, I have...


October 29, 2007  8:00 AM

Easy way to read XML execution plans.

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it.  It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.


October 24, 2007  5:09 AM

Upgrade for sp_who2 called sp_who3

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've published this before over on tek-tips.com, but I figured that I'd republish it here as well.  I've written an update for sp_who2 which I call sp_who3.  It can be most useful when trying to diagnose slow running queries as it can provide a wealth of information in a single...


October 17, 2007  5:46 PM

What does the min server memory setting actually mean?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I know that there is some confusion about what exactly the minimum server memory setting...


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: