(William E. Pearson, III) This is the fifth article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of

(graz) I’ve reached that horrible stage in a project. We’re still doing development but the users are in an extended alpha/beta test of the software. And they don’t like to lose the data they’ve entered. That means as I fix bugs and add new features I need to keep our development database in sync wi

(William Pearson) In this article, we introduce the concept of distinct counts, discussing why they are useful – indeed, often required – in our organizational analysis efforts. Throughout our session, we will describe some of the challenges that are inherent in distinct counts, and then we will und

(Dan Sullivan) SQL Server 2000 has a scalar data-type system that defines data types such as int or float, which DBAs commonly think of as “primitives” because they contain values that you can’t break down further into components. However, SQL Server 2000 doesn’t provide a practical way to extend th

(Gayathri Gokul) Transact-SQL is central to the use of Microsoft SQL Server. All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of an application’s user interface.It is trivial that we master some of the basics T-SQL, which you will b

(Brian McKnight) A database can be marked for many reasons. Generally it falls into the following conditions: –A database or log file is missing. –In SQL 6.5, a device may not be present or in 7.0/2000 a file may not exist. –SQL Server may not have been able to restore the database in amp

(Michael Otey) SQL Server’s IDENTITY columns let SQL Server automatically assign unique values to table rows. When you add a row to a table, the application you’re using doesn’t need to know anything about the row’s unique identity number; SQL Server just handles that part automatically. However, in

For clients dependent upon SQL, the number of concurrent users accessing a database could cause havoc on data integrity if left unchecked. Using these locking hints, you can ensure data changes are handled appropriately.

When you trace SQL Server activity with SQL Profiler or with other third party event tracing tools, you may receive an access violation in the CRowsetTraceData::FGetNextRow function.

(Itzik Ben-Gan) SQL Server 2005, formerly code-named Yukon, introduces a wealth of new T-SQL features and enhancements, which I briefly highlighted in my November 2003 article, “What’s New in Yukon T-SQL,” InstantDoc ID 40206. But in my opinion, common table expressions (CTEs) are by far the most im