(Muthusamy Anantha Kumar) As we all know, SQL Server 2005 has new features when compared to SQL Server 2000. One of the features that we are going to discuss in this article is the Row_Number() function. SQL Server Database administrators and developers have been longing for this function for a long
Other News
.NET Stored Proceedures: Reading Excel Files or Transferring SQL Server Tables into Oracle Tables
(Jagadish Chaterjee) In this article, I shall introduce you to developing a .NET based CLR stored procedure which can read a simple Excel file and transfer that information into an Oracle database using Visual Studio.NET. Once we have completed the stored procedure with the Excel file, we will furth
Properties, Getting and Setting Them Dynamically
In this code snippet we have a custom object that contains a method called GetProperties. The purpose of this method is so the object can return an arraylist of all the named properties it contains. Again you could use this to populate a drop down which then adds fields to be reported on or calculat
Building COM Servers in .NET
(Lim Bio Liong) COM/.NET interop is a well-known, well-documented and well-loved technology. It serves to help us bridge existing COM-based systems with .NET components, allowing us to leverage the wealth of functionality available through the use of the .NET class libraries. On the flip side, COM/.
Implement an advanced physical database with SQL Server 2000
(Thomas Moore and Ed Tittel) Learn about schema binding, data partitioning, and other aspects of advanced physical database implementation. This information, including practice questions, will help you prepare for the CAD/MCSE/MCDBA 70-229 certification exam. (pdf)
Using MySQL – Data and Structures
(Keith Brown) A common problem when learning how to the MySQL Command Line Client is getting the syntax exactly right. There are several conventions which are used throughout the MySQL virtual workshops when displaying commands that you will have to type.
Manage, Don’t Tune
(Sanjeev, Saurabhi Singh and Siddharth Singh) Over years of performance tuning endeavors, we’ve encountered many performance myths, ideologies, and traditional approaches to working with relational databases. We believe that the need of the hour is not to tune for performance, but to manage applicat
Performing Client-Side XSL Transformations
(Tony Marston) It is a feature of my software that I produce HTML output from XML documents with server-side XSL transformations. This means that as well as producing the XML document I transform it into HTML on the server before I send the result to the client.
Troubleshooting Dialogs
(Remus Rusanu) So you built your first Service Broker app, you’ve sent the first message and now you’re looking for the message on the target queue. Yet, the message is not there. What do you do? Where do you look first? Well, troubleshooting Service Broker is a bit different than troubleshooting yo
How to Share Data Between Stored Procedures
(Erland Sommarskog) This article tackles two related questions: How can I use the result set from one stored procedure in another, also expressed as How can I use the result set from a stored procedure in a SELECT statement? How can I pass a table as a parameter from one stored procedure to a