(Ben Hall) Partition Tables is a feature of SQL Server 2005 which allows you to separate your data into blocks (partitions) of data to improve performance and manageability as each partition can be stored in its own filegroup, which in turn can be on a separate disk array. In this post, I will cover
Other News
Top Queries in SQL Server 2005
(Muthusamy Anantha Kumar) SQL Server Database Administrators usually like to know which queries use the most CPU time and which queries use the most I/O. To get that information, SQL Server Database Administrators have run profiler pro-actively in SQL Server 7.0 and SQL Server 2000.
Unit Testing with Silverlight
(Scott Guthrie) One of the important capabilities we shipped with the Beta1 release of Silverlight 2 was a unit test harness that enables you to perform both API-level and UI-level unit testing. This testing harness is cross browser and cross platform, and can be used to quickly run and verify auto
Joining to the Next Sequential Row
(Paul Alcon) One of the more obscure requirements that a developer may find themselves facing is the need to compare a row with its immediate sibling. One such case is when a list of values needs to be processed to produce a moving average or to smooth a sequence of statistical numbers where their o
Implementing a Session Timeout Page in ASP.NET
(Steven Smith) In many applications, an authenticated user’s session expires after a set amount of time, after which the user must log back into the system to continue using the application. Often, the user may begin entering data into a large form, switch to some other more pressing task, then retu
Limit postbacks with ASP.NET 2.0 client callbacks
(Tony Patton) Developers have been grappling with the stateless nature of the Web since its inception. That is, once a page has been requested and loaded, the connection to the server is gone.
Plug-in development 101, Part 2: Introducing rich-client applications
(Chris Aniszczyk) Plug-in development in Eclipse is somewhat of an art form. If you’re new to the concept of plug-ins, especially in the context of OSGi and Eclipse, it can be a burden learning the myriad tools Eclipse has to help you write plug-ins. This article will help you learn some basic plug-
Apply an Identical Transformation to a DOM Tree Using TrAX
(Leonard Anghel) To test your TrAX application without involving your live business processes, simply build an identical transformation. You can do this using the newTransformer() method—without any arguments. The following code is a full example that applies an identical transformation to a DOM tre
Setting Up A MySQL Cluster
(Artem Russakovskii) This article contains my notes and detailed instructions on setting up a MySQL cluster. After reading it, you should have a good understanding of what a MySQL cluster is capable of, how and why it works, and how to set one of these bad boys up. Note that I’m primarily a develope
Using the CASE statement instead of dynamic SQL
(Armando Prato) I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alte