SQL Server 2005: Immediate Deadlock notifications(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years ago

Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment. That's why it's crucial to have as much information about them from the production environment as possible. This is one way of getting it immediatly when it happens, read more...

add a comment |category: Database |Views: 44

tags: 2008 Locks SQLServer Database 2005 another

Automated GUI testing - Is it worth it?(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 4 months ago

Unit tests no. Acceptance and Integration testing yes with great success. read more...

add a comment |category: Unit Testing |Views: 16

tags: NUnitForms Testing TDD another

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

Free SQL Server tools that might make your life a little easier (weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 6 months ago

Free MS and non MS tools for easoer work with SQL Server 2005 and 2000 read more...

1 comment |category: Database |Views: 62

tags: SQLServer SqlServer2005 2000 2005 Database another

C#: Care about Event Memory Leaks with Delegate.GetInvocationList()(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 7 months ago

Subscribed events are one of the most common reasons of memory leaks in .Net. This means that if you have an object that has an event and there are other object that are subscribed to that event, the original object won't be properly disposed until all events are unsubscribed since an event is a strong reference. read more...

2 comments |category: C# |Views: 421

tags: MemoryLeak Delegate .net2.0 C# Patterns another

C# : Get current Caret Line and Column in multiline WinForms TextBox(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 7 months ago

A managed way of finding current Caret Line and Column in a multiline windows forms textbox. read more...

add a comment |category: C# |Views: 376

tags: Multiline CaretPosition Column Line C# another

SQL Server: Notify client of progress in a long running process(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 7 months ago

In long running scripts it's usefull to notify the client of the progress. Here's a simple solution. read more...

add a comment |category: Database |Views: 30

tags: Raiserror notify Database SQLServer another

SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (bet(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 8 months ago

SSMS Tools Pack is an Add-In (Add-On) for Microsoft SQL Server Management Studio 2005 and Microsoft SQL Server Management Studio Express 2005. It contains a few upgrades to the IDE that I thought were missing from Management Studio. read more...

2 comments |category: Database |Views: 81

tags: 2000 SSMS Add-on add-in Database another

SQL Server: The proper and fastest way to check if rows exist(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 8 months ago

Simple yet very underused way to check if rows matching a condition exist. read more...

add a comment |category: Database |Views: 63

tags: SQLServer EXISTS 2000 Database Tips another

SQL Server 2005: An error or intended behavior with Database Compatibi(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 8 months ago

It turns out you can still run CLR functions, sprocs etc when changing the compatibility level from 90 to 80. Bug or feature? read more...

1 comment |category: Database |Views: 0

tags: SqlServer2005 CompatiblityLevel SQLServer SQLCLR another

"Nothing has changed" - Determining when a procedure has been altered(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 8 months ago

Cool little script to determine when a stored procedure was last updated. read more...

add a comment |category: Database |Views: 3

tags: TSQL SqlServer2005 SQL SQLServer another

Exchange: Accept and Cancel Meeting Request with WebDav(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 9 months ago

i show how to accept and cancel the meeting request with WebDAV protocol. read more...

add a comment |category: XML |Views: 75

tags: Accept Cancel MeetingRequest exchange WebDav 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: SQLServer VisualStudio 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: SQL CLR Database C# another

Nominate Subtext for a 2007 Community Choice Award(stevenharman.net)

submitted by ussherm(5285) 4 years, 11 months ago

The SourceForge.net Community Choice Awards are a chance for you, the community of open source software users, to nominate and then vote on the projects that you find most useful, best designed, most collaborative, etc... Support the .NET Open Source community and Subtext - Go Vote! read more...

add a comment |category: Open Source |Views: 0

tags: StevenHarman subTEXT OpenSource another