Kick Spy!, Kick Zeitgeist and Kick Widgets
sqlteam.com — Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query Window is utilized to compare the performance of two queries in a batch. read more...
sqlteam.com — Interesting article on using Visual Studio to debug stored procedures. read more...
sqlteam.com — Multiple Active Result Sets (MARS) is a new SQL Server 2005 feature that allows the user to run more than one SQL batch on an open connection at the same time. In my previous article about MARS I explained what MARS is and how to use it. In this article I'll discuss how transactions in MARS work and how you can debug MARS connections. read more...
sqlteam.com — This is the first article in a series on writing stored procedures using the Common Language Runtime (CLR). This article focuses on basic C# syntax and using Visual Studio to build a stored procedure. It's targeted at DBA's and anyone else who primarily writes in Transact-SQL and hasn't had much exposure to .NET yet. read more...
Sponsored Link: www.carlist.ie
Ads via The Lounge