Curtis Swartzentruber

in

Browse by Tags

All Tags » Server Products (RSS)
Datatype mismatches: SQL Server performance tip
I ran into a very interesting find the other day while trying to optimize some queries by studying the execution plans. We have a bunch of stored procedures that use an underlying view that points to a single table. This table has an "item_id" key and...
Selecting from stored procedure results
This is a neat little tip I just ran across. Sometimes it would be nice to select from the results of a stored procedure and use the data elsewhere. Standard disclaimer: if you need this type of functionality in a production app, a User Defined Function...
Deploying the ReportViewer ASP.NET control that ships with VS 2005
We're finishing up an ASP.NET and SQL Server Reporting Services migration and trying to get the control working properly on a different server during deployment. Turns out there is a bootstrapper exe to run on the target server. Instructions on deployment...