dba
Partitioning: MERGE, SPLIT, and SWITCH
OK, you know how to set up partitioning for a table and an index, and now you think you've solved your deadlocking, and your I/O issues forever, right? Hardly.
dba
dba
Partition Schemes
In my last article I started covering partitioning. I'm going to pick that up and continue with how to create your database to use multiple filegroups. Without
azure
The Import and Export Data Wizard and SQL Azure
In my previous post I walked through migrating a database from SQL 2008 to SQL Azure. I briefly walked you setting up your account with SQL Azure, creating a
career development
Introduction to Master Data Services
You find yourself sitting in front of your machine late one evening. Everyone has gone home for the night except for you. You've left a scan running to
microsoft sql
What is SQL Azure?
I've been getting this question or some variant of it for weeks now. Some people are confusing SQL Azure with SQL 2008 R2, and some are thinking it's SQL 2010.
t-sql
Introducing Microsoft SQL Server 2008 R2 eBook
With the release of SQL 2008 R2 (Artoo), there's plenty to learn in order to upgrade your skills. Microsoft Press has released a free eBook that can help you
microsoft sql
Migrating Databases to Azure
When converting a database from an older version of Microsoft SQL to Azure, there will be many gotchas along the way. I'd like to help you learn from the
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
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
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,
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.