Partitioned Tables and Indexes

Here is a good article on SQL Server 2005 Partitioned Tables and Indexes.


Virtual PC 2007 Console System Tray Problem Options.xml doesn’t exist

I have a common Virtual PC 2007 problem with dual monitors for my SQL VMs… when I most need to use my Virtual PC software, often the console goes insane when using a dual monitor, and though I can limp along by using Virtual PC from the system tray, i can not run it from…


SharePoint and SSRS (Reporting Services) IIS Port Conflict

I have been having trouble installing SharePoint on the same Server as SQL 2005 due to port 80 conflicts.  If you search on “SharePoint” in SQL BOL (Books On Line) there are some good links to configure both on the same machine.  Here is some initial reasearch I have done.  Great doc!…


Determine SQL Server Version

Here is a nice way to determine SQL Server Version Information aside from @@version: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)


AdventureWorks Sample Databases for SQL 2005

Here are the AdventureWorks Samples for SQL 2005 and 2008 . Here is a good pointer to the AdventureWorks Sample Databases overview for SQL 2005.   I also found that there is a SqlRun_Tools.msi file under the setup disk  ..\Tools\Setup that willl help with the sample db install as well. There are also .sql scripts…