(r.stropek) SQL Server 2005 now offers the possibility to partition tables and indexes. Using this feature can boost you DWH load. It will not necessarily enhance your query performance but it will make the typical tasks of loading the DWH DB easier.

(Eric Smith) Most functions require a set list of parameters to operate. However, you’ll create some functions that need a variable list of parameters. A good example of this is the AppendFormat method of the StringBuilder class. Depending on the format string you specify, you may need zero addition

(Nick Swan) It’s easy when you know how! I’ve been playing around with Beta 2 of Microsoft Office SharePoint Server 2007 for a couple of weeks now trying to get Forms Authentication to work. Together with Dan Winter from Microsoft and Adam Tybor I’ve got an internet presence site working with Forms

(Steve Hanov, Andrew Roth and Hobbe Smit) In this paper, we try to determine the refactoring necessary to implement a new feature in MySQL, a popular open source database system. The first step is to obtain the conceptual and concrete architectures. We find the conceptual architecture by examin

(Aldrich Merrill) Most of us have probably faced this situation at one time or another: there’s a deceptively simple query in your system that’s performing poorly: SELECT col1, col2, col3 FROM aLargeTable WHERE flag = 1

(Bipin Joshi) There are developers who write code and then there are developers who write better code. The difference is obvious. Writing good code is skill that not all developers have. This also implies that this skill can be improved. A part of this skill includes ability to refactor the code tha

(Gerald Leung and Grant Hutchison) The DB2 XML evaluation guide is a step-by-step tutorial to introduce the reader to the DB2 Viper data server on Windows platforms using the XML storage and searching (SQL/XML, XQuery) capabilities available to support next-generation applications. (R)

(Tarry Singh) Starting with this article, we will begin a discussion on administering our RAC database. Administration can mean many things; think of all that you do as an Oracle DBA–backup, restore, export, import, tuning, benchmark and even some PL/SQL work (It is not just for programmers you kno

(Syed Adnan Ahmed) It is a very common requirement in SharePoint Portal Solution to analyze a SharePoint solution in terms of storage capacity and statistics of sites, document libraries, area etc., to monitor the growth of the SharePoint solution and to take prompt action, if any thing goes wrong.

(Bipin Joshi) If you’ve ever traveled to unfamiliar destinations, you know the importance of maps. They help you to travel easily, making your journey more pleasurable. The same holds true for Web sites. A Web site should present visitors with a simple yet flexible navigation structure so that they