SQL Server with Mr. Denny:

SQL Server 2005


July 17, 2008  11:00 AM

Book: The Windows Manager’s Guide to iSCSI SANs



Posted by: Denny Cherry
Exchange, Microsoft Windows, SQL, SQL Server 2005, SQL Server 2008, Storage

That's right I said a book.  Well it's actually an eBook but good enough right?  The best part is that it's available for free.  It's a three chapter eBook called "The Windows Manager's Guide to iSCSI SANs".  Each chapter was posted separately so you have to click through to each...

July 10, 2008  11:00 AM

My Experience with putting a CRL Procedure into SQL



Posted by: Denny Cherry
C#, CREATE ASSEMBLY, CREATE PROCEDURE, Encryption, Microsoft.SqlServer.Server, SQL CLR Procedure, SQL Server 2005, SQL Server stored procedures, T/SQL

A little while ago I came upon a situation where I needed to put a CRL procedure into SQL Server 2005.  Now I've been using SQL Server 2005 since the day it went RTM, and this is the first occasion that I've needed to put a CLR procedure into SQL.  Could I have done what I needed to without a CRL...


July 10, 2008  11:00 AM

SQL 2008 RC0 Intellisense doesn’t work against SQL 2005



Posted by: Denny Cherry
Beta, Intellisense, SQL, SQL Server 2005, SQL Server 2008

I've been working with SQL 2008 RC0 for a couple of weeks now, and something I've noticed that really sucks.  The Intellisense doesn't work against a SQL 2005 server any more.  I've been using the SQL 2008 UI exclusively for several months now (since the November CTP at least) and I've gotten...


July 3, 2008  5:39 AM

Installing SQL Server on Windows Server 2008



Posted by: Denny Cherry
SQL Server 2005, SQL Server 2008, Windows 2008, Windows Firewall

I ran across an excellent post from Shawn Hernan of the SQL Server Development team (the guys that write SQL Server).  Shawn has put out an excellent blog post on what needs to be done to get SQL Server2005 or SQL Server 2008 installed on Windows Server 2008.  You can find the post


June 12, 2008  5:24 AM

Use caution when upgrading SQL 2008 CTP SSIS packages to RC0



Posted by: Denny Cherry
Beta, Migration, SQL Server 2005, SQL Server 2008, SSIS

A ran across a bit of a problem when upgrading my SQL 2008  CTP 5 (November 2007) SSIS Packages to SQL 2008 RC0.  Apparently Microsoft has changed the way that they handle the script tasks within the SSIS packages.  Because of this when I edit all of the script tasks within my SSIS package the...


June 10, 2008  6:39 PM

Article: SQL Server memory configurations for procedure cache and buffer cache



Posted by: Denny Cherry
Article, Cache, SQL Server 2000, SQL Server 2005

I've just published another tip over on SearchSQLServer.com.  This one is titled SQL Server...

Bookmark and Share     2 Comments     RSS Feed     Email a friend


May 26, 2008  11:00 AM

A very strange Service Broker and TempDB problem



Posted by: Denny Cherry
Service Broker, SQL, SQL Server 2005, TempDB

So, a little while ago I was having a major problem at work that I'd like to share in the hopes that someone else finds this information useful. (When I was having this problem, Google wasn't able to find anything for me.) The symptoms that we were having in a nut shell was that the tempdb was...


May 1, 2008  9:00 AM

Checking the cached execution plans



Posted by: Denny Cherry
Cache, Execution Plan, Query tuning, SQL Server 2005, sys.dm_exec_cached_plans, sys.dm_exec_plan_attributes, sys.dm_exec_query_plan, sys.dm_exec_requests

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 17, 2008  10:00 PM

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



Posted by: Denny Cherry
Article, Service Broker, SQL Server 2005, SQL Server 2008

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

Bookmark and Share     1 Comment     RSS Feed     Email a friend


March 31, 2008  10:00 AM

Back To Basics: The UPDATE Statement



Posted by: Denny Cherry
Back To Basics, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, T/SQL, UPDATE

After you've inserted the data into the table, it's time to update the data.  We do this by using the UPDATE statement.  The update statment can be used in two ways.  The first is to update a record or set of records in a single table, by simply filtering the data in the table by using values...


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: