2009

If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server.…

Read More SQL Session – Inside SQL Server 2008 Resource Governor

I’d like to start a new series that will help you learn some of the techniques I’ve used in the past.  Some of these techniques are useful, some aren’t.  Using SQL is a constant learning process.  You have to be willing to look at your solutions and throw out those ideas that no longer work…

Read More Code Review

Consider the CREATE INDEX statement below: CREATE INDEX ix_tableName_columnName ON tableName (columnName) ON { partitionSchemeName (columnName) | fileGroupName | default } What’s it all about? Let’s take these one at a time, and dig in a little bit. partitionSchemeName (columnName) Before you can use this option, you have to have your partition scheme defined. Check…

Read More INDEX ON partition_scheme_name, filegroup_name, and default