(Arthur Fuller) My current project involves a 62 million row table with more than 500 columns. The data came from a source outside SQL Server, and the table into which it arrived consisted of an identity primary key; all the remaining columns were stored as varchar(50).
Author: SSWUG Research
FIX: Error message when you run a full-text query in SQL Server 2000: ‘Error: 17883, Severity: 1, State: 0’
When you run a full-text query in SQL Server 2000 while a catalog merge operation also occurs, the result set may not return quickly. When this delay occurs, the SQL Server User Mode Scheduler (UMS) may stop responding. Additionally, you may experience stalled worker request behavior.
Encrypting Your Valuable Data With SQL Server 2005: Part 2
(Dinesh Asanka) After reading Part I in this series, you will have an architectural understanding of data encryption in SQL Server 2005. In this article, we will discuss the real implementation of it.
Meet the specs: WS-RT 1.0 operations, Part 2
(Kane Scarlett) Meet the WS-ResourceTransfer 1.0 initial draft specification, a proposed open standard that extends certain operations by allowing fragments of XML code in a single resource to be addressed instead of having to affect the entire resource. This article provides a closer look at how th
Drawing Line Chart in ASP.NET
(Steve Hall) Save the following code as an .ASPX web page on your .NET web server to try this sample using GDI+ encapsulated in a class to display a primitive line chart. The class features an arraylist to hold a dynamic number of chart points and utilizes transforms to simplify the plotting of worl
Building Event-Driven Architecture with an Enterprise Service Bus
(Lucas Jellema) One of the more important concepts in the domain of Service-Oriented Architecture (SOA) is that of Event-Driven Architecture (EDA). Similar to the event mechanism in, for example, JavaScript or 4GL environments where triggers—pieces of executable program code—can be hooked into event
Standalone XQuery Implementation in .NET?
XQuery 1.0 and XPath 2.0 are now W3C Recommendations, thanks in part to the contributions of several Microsoft employees over the years. An earlier draft of the XQuery specification is supported in SQL Server 2005 , and you can send an XQuery to the server using the ADO.NET that shipped in Visual S
Iterating through all controls on the form with VB.NET
(Irina Medvinskaya) If you’ve ever had to change all the controls on a form in runtime, you know how tedious it can be to modify the controls one by one. Here’s a simple way to perform this useful function with VB.NET.
Managing Database Transactions with the TransactionScope
(Paul Kimmel) New software can be evolutionary or revolutionary. The problem with revolutionary software is that sometimes people aren’t ready for the revolutionary. So, in general most software plods along with relatively simple changes. Whether there is a long term design or plan, it is hard to sa
An Introduction to the Internet Explorer Developer Toolbar
(John Peterson) If you’re like most Web developers, when you were first learning HTML, you probably spent a great deal of your time playing around with your browser. The fact that you could simply do a “View Source” and see how an interesting web page was implemented was one of the things that helpe