I am writing a query which is aggregating some data from one database into a separate database.<BR><BR>Basically, I have a query which returns 3 columns and I have a query that returns 1 ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

One way to slow down your application is to make multiple trips to the database. Here's a way to cut those trips in half (at least) and it has to do with the EntityFramework.Extended library. In an ...