Filtered Indexes - Simple Partitioning without Enterprise Edition?
This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition
2013-02-21
6,249 reads
Nigel Maneffa
Is It Worth Upgrading to SQL Server 2008
New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.
2009-12-18 (first published: 2008-10-21)
30,826 reads
Blogs
My home office setup
That aging hippie (he likes Apple products and has a goatee) known as Brent...
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
This is one of those things that probably doesn’t happen all that often, but...
In Memory Table Indexes
Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s...
Forums
What could cause MS Access app as a front-end to SQL, periodically run slow?
We've got an old Microsoft Access pharmacy application which acts as a front-end to...
SQL Server Case statement conditions
Good afternoon, I am currently working on a data flow and have been given...
Weird CAST/TRY_CAST Behaviour
I have a fact table with two numeric columns defined as DECIMAL(28, 12) and...
Ask SSC