(Brian Moran) The Transaction Processing Performance Council’s (TPC’s) TPC-C benchmark is the most common way of comparing performance in the database space—and a favorite tool in vendor marketing wars. You might find publicized TPC-C scores valuable in evaluating and enhancing your database environ

(Vinod Kumar) In this article I will walk through some of the aspects in using Order by from a developers stand point. There are tons of pitfals and advantages in optimizing queries. And more often than not we say the query has got Order by hence cannot be optimized much. Here let me walk through so

(William Pearson) In this article, we will look beyond the confines of Analysis Manager to introduce the creation and use of local cubes with Microsoft Office 2003 (“MS Office”). In conjunction with MSAS, we will overview the concepts involved with our topic, and then we will “drill down” into t

(Brian Moran) I’m undertaking a research project. I want to understand the effects that MySQL and other open-source databases are having and might have in the future on the mainstream database market–SQL Server in particular. I’ve been cynical about the idea that MySQL can aggressively compete with

(Roman Rehak) Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here’s a collection of such nuggets for developing SQL Server applications.

(Peter Petroski) Using naturally occurring data can have negative impact on database performance. We should restrict ourselves to using cold, hard, sequential numbers, and forget about those warm, comfortable relationships with data that are so familiar.

(Andrew Novick) In database terms, CRUD stands for the four essential database operations: Create, Read, Update and Delete. To create a high performance system, these four operations should be implemented by stored procedures, each procedure implementing one of the four operations. This is the secon

(Akram Hussein) The following article will give you a quick start on how to use the new reporting service of Microsoft inside your ASP.NET Application. It is relatively very easy to use reporting services, however it is a bit different from what we are used to in Crystal reports.

(Ameet Phadnis) Many projects do access data through Stored Procedures. There are 5 standard stored procedures for tables in the database. The standard procedures are for –Get: Getting a list from the table. –GetSingle: Getting single record from the table. –Add: Adding record to the tabl

(Gregory A. Larsen) This is the first article in a series of articles that I will discuss various aspects of working with SQL Server date/time columns. SQL Server has two different date/time columns. They are DATETIME and SMALLDATETIME. This article will define the difference between these two S