After moving from Enterprise Evaluation to Standard Edition, a database cannot be started in this edition because it uses a partition function. Here is the fix.
SQL SERVER – Finding Top Offenders in SQL Server 2012 – Notes from the Field #068
John Sterrett shows how to capture a workload and find your top offenders in SQL Server 2012 right inside Management Studio, without writing any T-SQL.
SQL SERVER – Notes and Observations on ReadOnly Databases in SQL Server
Can you create temp tables, stored procedures or shrink files in ReadOnly databases? I answer these reader questions with simple examples.
BULK INSERT With FORMAT CSV and FIELDQUOTE for Quoted Files
A comma inside a quoted name can break a CSV load without any error. Here is how FIELDQUOTE fixes it, and how to validate what arrives.
SQL SERVER – Installation Error – INSTALLSHAREDDIR parameter is not valid because this directory is compressed or is in a compressed directory
SQL Server setup failed saying the INSTALLSHAREDDIR parameter is not valid because the folder is compressed. Here is how removing that attribute fixes it.
SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Msg 8152, String or binary data would be truncated, is an error most developers have seen. Here is what causes it and why the setting that hides it needs care.
SQL SERVER – Warning: Null value is Eliminated by an Aggregate or Other SET Operation
Why does SQL Server warn that Null value is eliminated by an aggregate or other SET operation? I show when it appears and how it can be suppressed.