Using session is fragile, it's non-scalable both on the client (meaning the user can no longer use multiple tabs to parallelize processes) and on the server (for obvious reasons), and it fools you ...

For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...