(Keyvan Nayyeri) TOP clause was a part of T-SQL for prior version of SQL Server 2005 but it was limited to SELECT statements and could be used with literal values. There were some techniques to make it dynamic using SET ROWCOUNT statement but SQL Server 2005 introduces some enhancements for this cl
Author: SSWUG Research
Multiple Active Result Sets (MARS) – Transactions and Debugging
(Mladen Prajdiæ) Multiple Active Result Sets (MARS) is a new SQL Server 2005 feature that allows the user to run more than one SQL batch on an open connection at the same time. In my previous article about MARS I explained what MARS is and how to use it. In this article I’ll discuss how transactions
Virtualization means changing roles for DBAs
(Mark Brunelli) New processor technology expected from Intel and AMD will one day make database workload virtualization on x86 platforms a more practical affair than ever before. In the meantime, companies that want to virtualize database workloads will be looking to database administrators (DBAs) f
Black Belt Administration: Reporting Services Configuration Manager
(William Pearson) A common attribute of enterprise reporting systems is their provision for single points of maintenance for significant aspects of system configuration. Reporting Services meets the general need for centralized maintenance of reports and their constituent components by housing them
AJAX Security Options
(Aleksey Shevchenko) For the past few months, several Internet security companies (such as Fortify Software and WhiteHat Security) have been speaking out regarding AJAX security concerns. Fortify Software claims that AJAX technology contains a “pervasive and critical vulnerability”. Given that AJAX
Information exchange model at the next level
(Joab Jackson) The National Information Exchange Model has gotten its first upgrade. Version 2 should be released by the end of this month, and the final beta is available on the NIEM site.
The SOA requirement for data integration
(Michael Meehan) In the rush to build out service-oriented architecture a few fundamentals have gotten lost in the shuffle, perhaps none more than data integration. (R)
MySQL Cluster SQL Tips
(Brian Moon) So, I mentioned in my MySQL Cluster post that I found out that cluster and joins don’t get a long too well. There are a couple of tips I have for using joins or replacing them with other techniques that I thought I would share.
Analysis Services Query Performance Top 10 Best Practices
Proper cube design, efficient multidimensional expressions (MDX), and sufficient hardware resources are critical to optimal performance of MDX queries issued against a SQL Server 2005 Analysis Services instance. This article lists the ten most common best practices that the Microsoft SQL Server deve
DataStage 8 Tutorial: Using Range Lookups
(Vincent McBurney) DataStage 8 comes with some range lookup functionality within the lookup stage, a feature that came in at number four in my My top ten features in DataStage Hawk. A field on an input link can be compared to two fields on a lookup link or vice versa using a between clause returning