April 26, 2009 5:29 AM
Posted by: Denny Cherry
Bob Ward,
Bug,
Lock Pages,
Microsoft CSS,
SQL Server 2005,
SQL Server 2008Microsoft 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 7:45 PM
Posted by: Denny Cherry
Microsoft CSS,
SQL Dumper,
SQL Server 2008If you don't already read the CSS teams blog, I suggest that you do. A little while ago they posted a blog post about how the
March 12, 2009 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Execution Plan,
Index Performance,
SQL,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008All 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)...
January 22, 2009 3:00 PM
Posted by: Denny Cherry
Code Snippet,
Plan Guides,
SQL Server 2005,
SQL Server 2008,
sys.plan_guidesSo you've saved a plan guide into your SQL server, and you want to look at the plan. You can Query the sys.plan_guides catalog view and see the data exactly as you entered it, which works fine if you just have a hint in there. But if you have a full XML query plan that isn't going to do you a...
December 22, 2008 11:00 AM
Posted by: Denny Cherry
BIDS,
SQL Server 2008,
SSISUnlike in SQL 2005, when developing SSIS packages in SQL Server 2008 BIDS you must have the SSIS service installed on your workstation. This is a change from SQL Server 2005 where you did not have to have the actual SSIS service installed on your workstation.
It doesn't appear that you...
December 8, 2008 1:06 PM
Posted by: Denny Cherry
CREATE PROCEDURE,
SQL Server 2008,
T/SQL,
Table VariablesI would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure.
While we have been able to do this in the past, by using XML to pass more than one value in, then break it apart. But this is just such a...
December 1, 2008 11:00 AM
Posted by: Denny Cherry
Article,
Clustering,
SQL Server 2005,
SQL Server 2008For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven't already). When you do be sure to check out the article which I have in the magazine about clustering your SQL Server.
For those without a subscription you can sign up for...
November 14, 2008 8:36 PM
Posted by: Denny Cherry
Certifications,
SQL Server 2005,
SQL Server 2008Microsoft has now released the the majority of the upgrade exams from SQL Server 2005 to SQL Server 2008.
Continued »
