SQL Server Indexes: The Basics(sqlteam.com)

submitted by graz(255) 4 years, 5 months ago

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

add a comment |category: Database |Views: 8

tags: Database another

Debugging Stored Procedures in Visual Studio 2005(sqlteam.com)

submitted by graz(255) 4 years, 11 months ago

Interesting article on using Visual Studio to debug stored procedures. read more...

add a comment |category: Database |Views: 4

tags: VisualStudio SQLServer another

Multiple Active Result Sets (MARS) – Transactions and Debugging(sqlteam.com)

submitted by graz(255) 4 years, 11 months ago

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

add a comment |category: Database |Views: 10

tags: another

Writing CLR Stored Procedures in C#(sqlteam.com)

submitted by graz(255) 4 years, 11 months ago

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

add a comment |category: Database |Views: 28

tags: Database SQL C# CLR another