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...
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...
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...