(Venkatakrishnan J) Another common request that usually comes up is how do we enable Pagination in Pivot Tables. Though this is not available out of the box, lets look at one approach today to have pagination in pivot tables. Lets start with a simple pivot table report as shown below containing 2 co
Other News
SQL Server clustered index design for performance
(Matthew Schroeder) Clustered indexes in SQL Server are a critical consideration in the overall architecture of the database. They are often overlooked, misunderstood or, if the database is small, considered unimportant. (R)
The Other Side of Open Source, A Rebuttal
Featured Article(s) Tips for using SQL Server 2005 constraints (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 constraints. SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more. Also on the show, the 60-second SQL […]
On Open Source Going Mainstream
SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more. Also on the show, the 60-second SQL Server tip of the day, upcoming events, the newsletter and discussion list watches and other goodies. Also Available [Watch Now] SQL on Call – answering […]
Quick Tip: Adding mySQL and PHP to Your Windows Path
(BSchwarz ) Here is a quick tip showing you how to add mySQL and PHP to your Windows Server path. Many people ask how to do this and while it is included in the Installing mySQL and Installing PHP tutorials I thought I would make it easier for everyone to get the information.
Semantic Web takes big step forward
(Paul Krill) The Semantic Web, a concept tossed around for years as a Web extension to make it easier to find and group information, is getting a critical boost from the World Wide Web Consortium (W3C).
A Year in XQuery
(Dominic Mitchell) About a year ago, I wrote The year of XQuery?. I’ve just finished my involvement with the large project at $WORK that was using XQuery. So it’s time to reflect over it a little.
Create a Language Compiler for the .NET Framework
(Joel Pobar) Compiler hackers are celebrities in the world of computer science. I’ve seen Anders Hejlsberg deliver a presentation at the Professional Developers Conference and then walk off stage to a herd of men and women asking him to sign books and pose for photographs. There’s a certain intellec
Drill Down on Anonymous Types
(Bill McCarthy) Anonymous types are a new feature of Visual Basic 9 (2008). They provide a quick and easy way to define simple classes for holding values. Both VB 9 and C# 3.0 provide support for anonymous types, but C# supports only immutable anonymous types, whereas VB supports both mutable and im
Get Control of Access Path Changes for Dynamic SQL when Migrating to a New Version of DB2
(Craig Mullins) Are you making plans to migrate to a new version of DB2? Do you know what impact the access changes for dynamic SQL will have on performance? When migrating to a new DB2 version, access path changes for dynamic SQL are unpredictable – as is the impact those changes will have on appli