sql

career development

SQL Session – Execution Extract, Transform, and Load your Data Warehouse

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

career development

SQL Session – Execution Plan Caching and Reuse

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

career development

SQL Session – Inside SQL Server 2008 Resource Governor

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

t-sql

Code Review

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

t-sql

INDEX ON partition_scheme_name, filegroup_name, and default

Consider the CREATE INDEX statement below: CREATE INDEX ix_tableName_columnName ON tableName (columnName) ON { partitionSchemeName (columnName) | fileGroupName

career development

SQL Session – Inside SQL Server Policy-Based Management

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

t-sql

ASC, DESC, and Filtered Views

I know I've covered quite a bit of the CREATE INDEX statement, but there is even more to learn. Today I want to cover ASC, DESC, and the WHERE clause for

dev

SQL 202 – FILLFACTOR and Indexes

FILLFACTOR specifies the percentage for how full the Database Engine should make the leaf level of each index page during index creation or rebuild. FILLFACTOR

career development

SQL Session – DTS to SSIS

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

t-sql

SQL 102 – Indexes With Included Columns

I've shown you how to create indexes, CLUSTERED versus NONCLUSTERED indexes, today I want to build on that. Let's say you have a lookup query that takes names,

career development

SQL Session – Fortress SQL Server

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

dev

SQL 102 – UNIQUE INDEX

Ok, you understand how to create an INDEX. You understand the differences in CLUSTERED and NONCLUSTERED indexes. Did you know you could index a view? You can.