T-SQL

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