Deadlocks are unavoidable artifacts of today's RDBMS architecture–and all too common in high-volume OLTP environments. But thanks to .NET's Common Language Runtime (CLR), SQL Server 2005 provides developers with a new way to deal with error handling. In this month's column, Ron Talmage shows you how to harness TRY/CATCH to help resolve a deadlock.
A look at controlling transactions and locks with hints and snapshots in SQL Server 2000 and 2005.
Who builds SQL Server? It's an interesting collection of individuals and we're looking to bring you some profiles of them all. This time Steve Jones interviews Thierry D'Hers, leader of the BI group.
Shawn Wildermuth is the “go-to guy” for information on ADO.NET. He is the author of Pragmatic ADO.NET: Data Access for the Internet World and numerous articles, is a Microsoft MVP, and works as an independent consultant in Atlanta.
Shawn’s web site, The ADO Guy, is a good resource for developers looking for answers to questions about ADO and ADO.NET. The site also lists interesting blogs, books and sites that are among Shawn’s favorites.
With a month left before the 2005 PASS Summit, there is yet another great reason to attend this SQL Server conference in 2005. Read about it and be sure that you register today with our source code "SSC".
After a fantastic reception to his SQL Server 2000 cryptography toolkit, Michael Coles brings us a basic look at cryptography so you can understand what you are getting into if you implement it.
In any well run development environment, you will have a separate SQL Server for developers to work on, completely different from your production server. However there are a few tricks that Jason Hall brings us that you might want to implement to ensure a smooth running environment.
This article looks at how partial classes can be used to implement business logic into datasets so that they are more business aware and intelligent.
The dataset is an integral part of Microsoft’s new data access model ADO.NET. It introduces a simple offline method for retrieving and updating data. Before using the dataset, you should have an understanding of the Microsoft .NET platform and a basic understanding of the dataset model.
Why should a SQL Server DBA want to keep their job? It seems obvious, but Steve Jones continues with his series on employee retention by taking a look at it from the employee side.
Michael Rys is one of two program managers responsible for the XML features in SQL Server. He also represents Microsoft on the W3C XQuery Working Group, and on the ANSI working group for SQL. I asked him what is distinctive about the XML support in SQL Server 2005, as opposed to that found in rival database management systems. As Rys acknowledges, "all the three major vendors, Oracle, IBM and Microsoft, are moving towards second or third generation suppor
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers