(Bob Watkins) Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles, a BIGFILE tablespace stores its data in a single datafile with a much larger capacity. BIGFILE tablespaces can grow as large as 32-128 terabytes (TB
Author: SSWUG Research
Visual Explain Version 8 tip
(Willie Favero) I had the opportunity today to present Pat Bossman’s (IBM SVL Optimizer) presentation on Visual Explain Version 8 to the Austin DB2 User Group (HOTDUG). Pat has a great tip in his presentation describing how to get the information necessary to setup your connection from Visual Explai
How to create a New Custom JSF Component that randomly displays select items in SelectOne… and SelectMany components
(Lucas Jellema) Selection components, such as Radio Buttons. Dropdown-lists, Lists, Shuttles and Check Boxes, are key elements of many a web page. Java Server Faces has a pretty wide range of such selection widgets available, from selectOneRadio to selectManyCheckbox in the RI and a wide range of a
Expanding to Meet Demands
(David A. Kelly) Small business doesn’t mean small requirements. Take the case of fast-growing Bebo.com, the United Kingdom and Ireland’s most popular social networking site.
32-bit vs. x64
(Linchi Shea) When it comes to the issue of 32-bit vs. x64, you can easily walk away from a presentation with an impression that going to x64 will most likely give your SQL Server application a performance boost. I’d like to show you–with some test data–that you should be careful with that impress
Logical Functions: IsSibling(): Conditional Logic within Filter Expressions
(William Pearson) In this article, we will examine IsSibling(), once again as a conditional logic modifier, but within the context of a filter. Combining IsSibling() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the practi
ASP.Net State Management Techniques
(Santhosh Babu) This article discusses various options for state management for web applications developed using ASP.NET. Generally, web applications are based on stateless HTTP protocol which does not retain any information about user requests. In typical client and server communication using HTTP
Does LAMP make economic sense?
(Barry Railton) Many companies have data scattered across several databases that are often maintained by proprietary software. For example, we might have a computer inventory in a specialized application that keeps track of assets, an office phone list in a Word document, employee locations in an Ex
Build Your Own Analysis Services Cache-Warmer in Integration Services
(Chris Webb) Cache-warming is one of the most neglected performance-tuning techniques for Analysis Services: perhaps it seems too much like cheating? Yet almost everyone knows how much difference there can be executing a query on a cold cache and a warm cache so there should be no excuse not to be d
Using Visio 2003 for Enterprise Architects to Design SQL Server Databases
(Chris Buckett) Although it has many quirks, Visio 2003 for Enterprise Architects (available with MSDN premium and above), is a great tool to use when you’re laying out your database design, and can be used to organize your thoughts, annotate tables and views, store stored procedures, and remain in