SQL Server with Mr. Denny:

October, 2008


October 30, 2008  4:53 AM

VMware Windows XP x64 LSI Driver



Posted by: Denny Cherry
SQL

So yesterday I was asked to setup a few x64 workstations on our ESX server. The Vista x64 machines detected the LSI controller no problem, but the Windows XP machines couldn't find the controller, and the drivers that VMware included with ESX (3.0.2) were x86 only drivers.

October 29, 2008  6:50 PM

Join Jason Hall and Myself as we talk about finding out how healthy your SQL Server Enterprise is



Posted by: Denny Cherry
Jason Hall, Quest Software, SoSSE, Webcast

Tomorrow morning at 8am Pacific / 11am Eastern / 4pm London Jason Hall and myself will be talking about how to find out how healthy your SQL Server Enterprise is using both the native tools as well as Quest Software's Spotlight On SQL Server Enterprise.


October 28, 2008  12:57 AM

New SQL Server Wiki Launching Today



Posted by: Denny Cherry
Brent Ozar, Quest Software, SQLServerPedia.com

Today is the unofficial launch of the new SQLServerPedia.com Wiki.  The official launch for the wiki is during PASS, so you have to go...


October 27, 2008  12:46 AM

I’ve finally found myself an offline editor that I like



Posted by: Denny Cherry
Blog, BlogDesk

I've finally found an offline blog post editor which I like. With all the traveling that I've been doing recently its very handy to be able to edit them offline so that I don't have to pay for internet access at airports. It also lets me blog while on an airplane without having them write them in...


October 25, 2008  11:00 AM

Slide Decks and Sample Code for SoCal Code Camp at USC



Posted by: Denny Cherry
Back To Basics, Federated Database, In Person Events, SoCal Code Camp, Storage

Here are the slide decks and sample code from my sessions at this weekends SoCal code camp.

  Bookmark and Share     4 Comments     RSS Feed     Email a friend


October 22, 2008  11:10 AM

Should I ask my boss to send me to PASS?



Posted by: Denny Cherry
PASS

I would say that yes you should. The PASS summit is an excellent learning opportunity that simply shouldn't be missed if you can't avoid it. No matter how much you think you know about SQL Server, there is always more to learn. I tend to think I know quite a bit about SQL Server and I enjoy...


October 20, 2008  11:05 AM

Thank you Orange County SQL Server Users Group



Posted by: Denny Cherry
Clustering, In Person Events, Microsoft Cluster Service, MSCS, Orange County SSUG, Windows 2003

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



Posted by: Denny Cherry
Cache, SQL Server 2005, SQL Server 2008, sys.allocation_units, sys.dm_os_buffer_descriptors, sys.partitions, sys.tables

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?



Posted by: Denny Cherry
Certifications, PASS

Microsoft and PASS have announced that you can take a free Microsoft Certification exam.  Visit the PASS Community Summit 2008 Microsoft Learning Certification Center Registration Site for...


October 13, 2008  11:01 AM

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



Posted by: Denny Cherry
Query tuning, 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 scan), not an Index Seek which is why the SELECT COUNT(*) takes so long. The reason for this is that the COUNT(*) function needs to look at every record in the table. As a workaround...


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: