(Darren Green) If you are having problems with the syntax for the dtsrun command line, or just want an easy way of generating a valid command line first time, try using the dtsrunui utility. As the name indicates it is very similar to dtsrun, but with a user interface. This allows you to easily sele

Microsoft has released an update to Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE) on Microsoft Windows Server 2003. This update addresses issues with WMSDE when used with Microsoft Windows SharePoint Services on computers that are running Windows Server 2003. This article describes how

You may have wondered what the different wait types mean that you see listed with certain transactions with SQL Server. This handy table will explain each, along with some tips to address them.

(William Pearson) In this two-part article, we will return briefly to our exploration of what has continued to be a popular topic (and which, as I mentioned in Article Ten, results in several e-mails each week in my inbox), Reporting Options for Analysis Services Cubes. As I stated before, our focus

(Claude Seidman) As we saw in Chapters 1 and 2, one of the most important prerequisites for a successful data-mining effort is the preparation of the case data, which you need to do before you can begin mining any data. In many, if not most, cases the source of the training for your data-mining mode

(Davide Mauri) If you ever worked with tables using the text datatype, you have found that you cannot use the REPLACE TSQL function on it. Ok, that’s fine we know that the text datatype has some drawbacks, but we still need to use it (for example I cannot work without it, since a great part of my wo

We have been used to traditional report writers for many years now. In this era of thin client, multi-tier, object oriented, service based architecture, the good old report writers have remained more or less similar. For example, most of these provide header, footer, detail, and group based bands wh

(Peter W. DeBetta) The next version of SQL Server, code-named “Yukon,” will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UD

(Brian Fonseca) As the absolute size of corporate and government databases continues to swell, more users are turning to technology they previously didn’t consider for very large databases: Microsoft Corp. and its DBMS and Windows. A study by the Winter Corp., released last month, identifies the

(Susan Harkins and Mike Gunderloy) Developers who are new to Transact-SQL (T-SQL) sometimes discover one part of the language and use it doggedly, even when there are better alternatives. An example is using the classic IF…THEN statement for controlling program flow. This is usually the first, and