You can improve OLAP performance when you set a cube’s aggregation level. When you build a cube, you set the aggregation level according to the desired speedup in processing queries. (Speedup describes how much faster queries run with precreated aggregations than without aggregations.) The system es

(Bruce Szabo) Data Transformation Services (DTS) is extremely useful in solving a number of problems.In some cases I have used it to solve data problems and in other cases I have used it to solve some tasks that have nothing to do with SQL. One difficulty I found with DTS was managing the different

(Amol Kulkarni) When multiple database objects access each other sequentially, the sequence is known as a “chain.” Although such chains have no independent existence, when SQL Server is traversing the links in a chain, it evaluates user permissions on the constituent objects differently than it woul

This article describes how to establish connections to SQL Server in an ASP script by using ActiveX Data Objects (ADO), while taking advantage of the connection pooling feature of ODBC 3.0.

(Dinesh Asanka) Generating next numbers in SQLServer should not be a problem. But problem arises when customer ask for different types of next numbers where you cannot generate directly from SQLServer. This brief article describes how you would tackle this problem in different scenarios. (R)

(Sanders Kaufman, Jr.) If you’re a Microsoft programmer, you have probably invested quite a lot in the transition from Windows NT/SQL Server 7 to Windows 2000/SQL Server 2000. The transition to Longhorn/Yukon is going to require a similar investment. Enhancements to SQL Server (Yukon) will include m

You can use the SQL Server 2000 Replication ActiveX controls to embed replication functionality inside custom applications. This article describes how to program the SQL Snapshot and SQL Distribution controls by using Microsoft Visual Basic .NET.

(James Luetkehoelter) So it’s here. Finally. For those of you who haven’t had a chance to work with the beta, it’s probably a good idea to download the evaluation version and start. This add-on should be widely adopted in a relatively short time. It doesn’t matter if you’re primarily a developer or

(G. Vijayakumar) When I first started using SQL Server as a novice, I was initially confused as to the differences between the SELECT statement, views, and stored procedures. They all seemed to perform more or less the same task (retrieve data), and I wanted to know the pros and cons of using each.

(Dinesh Priyankara) Recently one of my co-workers came and asked me the correct version of SQL Server that we have installed in our company and the service pack. So, I asked him to run the SELECT @@VERSION in the Query Analyzer and see the result to get the version and service pack installed. He ran