.NET 2.0 transaction model

The Microsoft .NET 2.0 platform introduces a new namespace called System.Transactions that brings in a lightweight, simplified transaction model. This article discusses the shortcomings of current transaction models and introduces System.Transactions for .NET Framework 2.0 beta 2.

Currently there are two transaction models available in the .NET world, both of which are suited for certain situations. The first is part of the rich ADO.NET data providers. The second is the enterprise services transaction. Before we examine System.Transactions, let’s have a look at the current models.

Writing CLR Stored Procedures in C# - Returning Data (Part 2)

In Part 1 I covered a simple stored procedure that printed the current date. In this article I'll cover writing a stored procedure to return a recordset back to the client. In the process we'll learn a little bit more about .NET and C# including the SqlConnection, SqlCommand and SqlDataReader classes.

Introduction to C# for DBA's

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.

RE: SQL Server 2005 Import/Export Server Registrations

Nice feature, but the artcle could have been written in two paragraphs.  We can play with the gui on our own, thank you.

RE: Dump SQL Permissions

EXCELLENT TOOL FOR ANY DBA especially during the period of SOX compliancy!!! THANKS A BUNCH... ...Michelle

RE: The ARRAY In SQL Server 2000

Interesting reading.  Thank you for taking the time to share the ideas.

Decreased Performance from a UDF

So I've got this batch of T-SQL that runs in Query Analyzer in about 3 seconds or so.  When i put this exact same code into a UDF the time shoots up to over a minute.  Has anyone ever heard of reduced performance when T-SQL is put into a UDF.  By the way  I also […]

RE: What isolation level and lock type should I use?

try :selec * from tableA with HOLDLOCK/*any procesess and others users try to access this tableA but they can't.*/Update tableA set field='tutu' where id=1 commit tran/*now others users try to access this tableA and they can.*/ saluteVictor

RE: Performance Problem

Chek the use of indexes, if the are not the same try to Hint them:..................FROM Table1 (INDEX = idx_index_name)............ Sometimes if you use calculation in the joins it does not use the right index.

RE: Formatting in T-SQL

Yes there's a way as Noeld pointed out but why do you want to format your data like this?? this work is more often than not supposed to be done on the client instead of the server.