The error which we observed was a failure of a rule – Patch Install Rule Error – Not clustered or the cluster service is up and online.
SQL SERVER – Upgrade Error: Microsoft NET Framework 4.0 Installation Has Failed With Exit Code – 2146498511
The solution of error Microsoft .NET Framework 4.0 installation has failed with exit code -2146498511 which was faced during SQL Server upgrade
How to Set ARITHABORT ON for .NET Applications
A query that runs fast in Management Studio and slow in a .NET application often runs under two different plans, because the two connections use different ARITHABORT settings. This post shows both plans in the plan cache, measures the cost, and explains how to set ARITHABORT ON for all connections through the server’s default connection options.
SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085
Clients sometimes send files made with Results To File in SSMS. Kevin shows how to convert standard SSMS file results to delimited data you can load.
SQL SERVER – SSIS and How to Load Binary Large Objects, or Blobs – Notes from the Field #080
In Notes from the Field #080, Andy recalls his first project loading product images with SSIS and explains how to load binary large objects, or Blobs.
Table-Valued Parameters: Sending Thousands of Rows in One Call
Send thousands of rows in one call with table-valued parameters, compare round trips, and handle missing column statistics accurately.
Parameter Types From .NET: Stopping Implicit Conversions at the Source
Match parameter types from .NET to SQL Server columns, avoid implicit conversions, and inspect cached plans for mismatched strings.