Pocket Joshua

I will be presenting T-SQL Development Techniques for Performance at SQL Saturday #37 in Philadelphia at 9:30 AM on Saturday March 13, 2010 at St Josephs University as part of the T-SQL Dev Track.

Registration is open until 3/8/2010 or 325 people.  Please make plans to attend and support the Philadelphia area SQL users.  The better the attendance the more love from vendors and sponsors.

The presentation is one I have give before but will be including some new material.

Hope to see you there!

I have not read this article completely yet.  The purpose of this post is to remind me that I do need to read it and get comments and feedback from others who both care and have a clues as to the subject.

Enjoy:

http://msdn.microsoft.com/en-us/library/dd758814.aspx

While SQL Server 2008 is compatible with Windows 7 there are a few things to know to help easy some of the installation quirks.

The general gist is that there will be a few warnings that can be bypassed so long as you install SP1 or latest as soon as your are done with the initial installation.  Additionally, there is on error message that may pop up that will go away if you restart your OS.

Invoke or BeginInvoke cannot be called on a control until the window handle
has been created.

This did happen tome and a reboot did cure the problem.  Two articles that I found that were very helpful are linked below:

Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?

By Aaron Bertrand – SQLBlog.com

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/08/14/is-sql-server-2008-supported-on-windows-7-windows-server-2008-r2.aspx

SQL Server 2008 on Windows 7

By John Paul Cook – SQLBlog.com

http://sqlblog.com/blogs/john_paul_cook/archive/2009/08/10/sql-server-2008-on-windows-7.aspx

The articles reference each other.  They were very helpful and quickly got me on track.  Thanks to Aaron & John.

Cindy Gross on her msdn blog of Troubleshooting, tips, and general advice about SQL Server has a post that consolidates information and links to information on TempDB.  The article has some very simple basic advice as well as a number of links to other resources with more detail.

Compilation of SQL Server TempDB IO Best Practices.

http://blogs.msdn.com/cindygross/archive/2009/11/20/compilation-of-sql-server-tempdb-io-best-practices.aspx

As an avid and explicit user of temp tables I have long since been behind the idea of high performance drives for the TempDB.  Does anyone have any performance and durability data on the use of SSD for the TempDB.

There is a good short article on SQLServerCentral.com on creating Starter Projects in Visual Studio specifically for SSRS reports. 

How to Create a Reporting Services 2005/2008 Template

http://www.sqlservercentral.com/blogs/sqldownsouth/archive/2009/11/20/how-to-create-a-reporting-services-2005-2008-template.aspx

Short and simple trick.  Good for standardizing margins, header, footers etc.