|
|
graz
graz
 |
|
Stories kicked by graz
|
|
submitted by
spirit1
6 months, 14 days ago weblogs.sqlteam.com — 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: 21
| 
|
tags:
2008, Locks, 2005, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 11 months, 17 days ago, submitted by
graz
11 months, 22 days ago 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...
add a comment
|
category: Database | Views: 2
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 year, 1 month ago, submitted by
spirit1
1 year, 1 month ago weblogs.sqlteam.com — 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: 75
| 
|
tags:
MemoryLeak, Patterns, Delegate, C#, .net2.0 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 year, 2 months ago, submitted by
spirit1
1 year, 2 months ago weblogs.sqlteam.com — 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: 25
| 
|
tags:
2005, SSMS, Add-on, 2000, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
graz
1 year, 5 months ago 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...
add a comment
|
category: Database | Views: 0
| 
|
| tag it
Everyones tags: | Your tags: | |
No tags
|
|
|
|
|
published 1 year, 5 months ago, submitted by
graz
1 year, 5 months ago 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...
add a comment
|
category: Database | Views: 1
| 
|
tags:
SQL, CLR, Database, C# | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 year, 5 months ago, submitted by
 ussherm
1 year, 5 months ago stevenharman.net — 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 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|