Consider the following scenario: • You install and then configure a failover cluster of Microsoft SQL Server 2005. • The build of SQL Server 2005 is 3179 or a later build.
Other News
Curious cursor optimization options
(Hugo Kornelis) The best way to optimize performance of a cursor is, of course, to rip it out and replace it with set-based logic. But there is still a small category of problems where a cursor will outperform a set-based solution. The introduction of ranking functions in SQL Server 2005 has taken a
UNIQUE Column with multiple NULL values
(Muthusamy Anantha Kumar) As you know, when you create a UNIQUE constraint on a nullable column, SQL Server allows only one NULL value, thereby maintaining the UNIQUEness. However, there are situations when we need more than one NULL value in the column but still have to maintain uniqueness, ignorin
SQL Server 64-bit applications and performance drawbacks
(Serdar Yegulalp) There’s no question that the commodity computing world is broadly transitioning from 32-bit to 64-bit architectures, especially on the server side. Conventional wisdom would have it that 64-bit is better, period: You can deal with a larger, less bounded memory space and do more wit
LINQ, Spatial Data, Version 1.00000 in 2008 and More
Register Early for the Virtual Conference… …and help provide feedback on setting up the session schedule, see the tools early, participate in chats and more. All just for getting your name in the hat early. The SSWUG SQL Server Virtual Conference – on your desktop, in your timezone, more than 27 sessions and much more. This is YOUR conference. > […]
(89) – Find Out About LINQ and Spatial Data Changes Coming in SQL Server 2008, Straight from Microsoft, In Two Interviews on the Show Today.
Pro-Center Video Programming for IT Professionals
Are You Open to Version 1.00?
Featured Article(s) Handling Concurrency issues in ADO.NET (Part II) This is the second and the concluding part in this series where we will discuss the types of concurrency and the best practices in choosing and working with them. Latest SSWUGtv: Mock Interview, Part II. The Technical Interview: Go through the interview process, questions, answers and interpreting the responses. Learn About […]
Take Advantage of SQLXML with ASP.NET
Looking for advantages of SQLXML I found some interesting things: “SQLXML is a set of supplemental tools that extend SQL Server’s existing support for retrieving and storing XML data. With SQLXML 3.0, you are now able to use SQL Server to expose Web services. SQLXML’s Web services let you execute
CF_XSLT ColdFusion Custom Tag For Xml Transformations
(Ben Nadel) I was doing a bunch of stuff with XML and XSL Transformations in ColdFusion the other day and I got really tired of the fact that I had to create an intermediary XSLT variable before I could call the XmlTransform() method. To deal with this, I whipped up a quick little ColdFusion custom
Introducing ADO.NET Entity Framework
(Julia Lerman) The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. However, w