SQL Server with Mr. Denny:

ITKE grandparent


May 14, 2008  8:00 AM

Any other DBAs brave enough to go to EMC World?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Next week I'll be stepping into the lion's den of sorts.  I'll be off to Las Vegas to attend EMC World.  I went last year, and I'm pretty sure that I was about the only full time DBA there.  The storage folks treated me pretty nice, even after they found out that I was a DBA. Hopefully when I...

May 12, 2008  9:00 AM

Data Normalization, with storage being so cheap what’s the point?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Back in the old days one of the big reasons that people enforced such...


May 8, 2008  11:00 AM

Back To Basics: The SQL Server Service Broker

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

The SQL Server Service Broker is a fantastic new addition to SQL Server.  For those who have used Microsoft Message Queue (MSMQ) the service broker will be easy to understand as it's the same basic concept.  Messages are sent from one place to another, within a database, from database to...


May 8, 2008  4:04 AM

Quest Meet the Expert Video published

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

Quest Software has just published the first of a few videos which I recorded with them. You can download or view the video from here. I've...


May 5, 2008  9:00 AM

I’ll be speaking at the Inland Empire .Net User Group

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

The nice folks at the

    0 Comments     RSS Feed     Email a friend


May 1, 2008  9:00 AM

Checking the cached execution plans

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

As we all know SQL Server, will for good or bad, cache execution plans.  Up until now it's been very tough to see the cached execution plans.  You pretty much had to grab the query or procedure (with the parameters) and run it with Query Analyzer and have it return the execution plan.  The only...


April 28, 2008  9:00 AM

Checking free disk space from T/SQL

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I've seen some very creative ways to see how much free disk space SQL Servers have.  Most make use of xp_cmdshell which some very complex dos commands or vbscripts. However there is a much easier way.  Microsoft has included the system extended stored procedure xp_fixeddrives.  It returns the...


April 24, 2008  12:23 PM

My ERRORLOG shows some spids have an ‘s’ after them. What’s going on?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

That "s" is new in SQL Server 2005.  It means that the SPID is a...


April 21, 2008  9:00 AM

Back To Basics: The DELETE Statement

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

When you have data in your table that you need to remove the DELETE statement is the way to do that.  Using the DELETE statement without any WHERE clause will remove all the data from your table.  The WHERE clause works the same way as the WHERE clause for SELECT and UPDATE...


April 17, 2008  10:00 PM

New Article: Configure SQL Server Service Broker for sending stored procedure data

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I’ve just published a new tip on SearchSQLServer.com called Configure SQL...

    1 Comment     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: