Tag Archives for " Pro Advice "

Sep 01

Table-Valued Parameter Performance Using C# Data Tables

By Jeffry Schwartz | Expert , Miscellaneous , Performance Tuning , SQL Development , SQL Server

The following testing and resulting data is a direct result of a recent issue that was discovered at one of our client sites.  After setting up SQL monitoring that does use a SQL trace to capture long running queries, suddenly certain processes would lock up and be unable to complete.  Initially we thought it was […]

Continue reading
1 2 3