(Mike Gunderloy) In my previous article, I showed you how to write a very simple function in Visual Basic .NET and then call it from T-SQL code in SQL Server “Yukon.” But that’s only part of the CLR integration story for the next version of SQL Server. One important part of the story that I left out

(Erland Sommarskog) Questions you often see in newsgroups about MS SQL Server are: How can I use the result set from one stored procedure in another or How can I use the result set from a stored procedure in a SELECT statement? This article presents different answers to these questions, and I als

(Darren Green) If you’ve written a program that utilises DTS then you will need to distribute the DTS files along with your new program. Programs such as the Visual Studio Package and Deployment Wizard will not automatically include all of the files required. The definitive reference for redistribut

(Vinod Kumar) This topic as such is new to SQL Server terms even though they have existed in the many other programming languages before. In this article I would walk you through some of the most common usage of UDFs in SQL Server 2000 context. Note that some of the tips and tricks used in this arti

(Drew Georgopulos) The version of DTS in SQL Server 2000 provides a bundle of pre-packaged tasks. Most are dedicated to moving data, but some are specific to SQL Server maintenance. The data tasks facilitate moving information between database servers (not limited to SQL Server), or moving other fil

This article describes the following configuration settings and considerations for their use: –Affinity Mask –Lightweight Pooling –Max Async IO –Max Worker Threads –Memory –Priority Boost –Set Working Set Size SQL Server can obtain a very high level of performance with relatively l

(Mark Shainman) The growing popularity of Microsoft SQL Server has caused the proliferation of instances of the database throughout the enterprise. However, this widespread adoption with little IT oversight has also produced management issues. To control costs and improve support, your organization

(Erland Sommarskog) In many aspects SQL Server is a very good DBMS that permits you implement powerful solutions with good performance. However, when it comes to error handling… To be blunt: error handling in SQL Server is poor. It is a patchwork of not-always-so-consistent behaviour. It’s also we

(Lynne Harvey Zawada and Peter O’Kelly) For more than 30 years, industry watchers have viewed the Business Intelligence (BI) segment as an area of opportunity for both established enterprise software vendors and software startups. Year after year, the BI segment experiences steady and continuous gro

(Darren Green) DTSBackup 2000 is a designed to help with both backup and transfer of DTS packages. Whilst it is not recommended as a substitute for your normal file and database backup routines, it is an additional layer of protection, with the benefit of package level granularity. See the article B