SQL Server with Mr. Denny:

Development


May 20, 2009  1:32 PM

I’m drunk with power at ServerFault.com



Posted by: Denny Cherry
Beta, ServerFault.com

As of Monday it's official, that I'm now one of the two moderators over at ServerFault.com.  From what I understand this means I basically go through the list of posts that people have tagged as not being relevant to he site and remove them,...

April 26, 2009  5:29 AM

SQL Server Standard Edition getting Lock Pages in Memory



Posted by: Denny Cherry
Bob Ward, Bug, Lock Pages, Microsoft CSS, SQL Server 2005, SQL Server 2008

Microsoft SQL Server 2005 and 2008 Standard edition will be getting the Lock Pages in Memory feature that SQL Server Enterprise Edition has had starting in SQL Server 2005.  This was announced by Bob Ward via the


March 30, 2009  5:27 PM

Article: Testing a SQL Server environment before an upgrade



Posted by: Denny Cherry
Article, SearchSQLServer.com, Testing, Upgrading

I just published another article up on SearchSQLServer.com.  This one is entitled Testing a SQL Server environment before an...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan



Posted by: Denny Cherry
Back To Basics, Execution Plan, Index Performance, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says.  Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...


March 2, 2009  2:43 PM

Standalone SQL Agent Update 3/2/2009



Posted by: Denny Cherry
SQL

I’ve been quiet about the Standalone SQL Agent for a while now.  I haven’t forgotten about the project, in fact I’ve been busily working on it in what little free time I have.  I’ve been working on phase 2 of the project which is adding in the UI to handle job management.  Needless to...


February 16, 2009  9:53 PM

Processing XML files with SQL Server functions



Posted by: Denny Cherry
OPENXML, SearchSQLServer.com, XML

I just published a new article on SearchSQLServer.com called Processing XML files with SQL Server...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


December 25, 2008  11:00 AM

What should I do when my Windows Admin wants to put an anti-virus on the SQL Servers?



Posted by: Denny Cherry
Anti-Virus, SQL

My answer to that one is pretty easy.  Let him / her.  I'm a firm believer that every machine on the network should have anti-virus software installed.  Most anti-virus software is pretty lightweight (especially compared to the amount of hardware that your SQL Server has), and if a virus did get...


December 15, 2008  9:00 AM

Back To Basics: Getting Data from an XML Document



Posted by: Denny Cherry
Back To Basics, T/SQL, XML

One of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using the XML...


November 22, 2008  7:08 PM

PASS 2008 Wrapup



Posted by: Denny Cherry
PASS, SQL

Well the PASS 2008 summit must be official over as I'm sitting at the airport waiting for my plane.  I was expecting a very long security line here at SeaTac but I was through security within maybe 10 minutes.  While means that the two hours I was planning on standing in line I instead get to sit...


November 17, 2008  8:00 AM

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



Posted by: Denny Cherry
In Person Events, Query tuning, Resource Governor

The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them.  This is a great speaking opportunity for me as they are about 20 minutes from my house. I won't be speaking there until...


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: