(Nigel Rivett) Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. The feature is only available for enterprise and developer edition. For other editions you can get a similar functionality with a partitioned
Tag: SharePoint / BI
Using delayed JOIN to optimize count(*) and LIMIT queries
(Peter Zaitsev) In many Search/Browse applications you would see main (fact) table which contains search fields and dimension tables which contain more information about facts and which need to be joined to get query result.
Sub-templates and More with Oracle HTML DB
(Lawrence Linnemeyer and Bradley Brown) In this third part of a three-part article covering Oracle HTML DB, you’ll learn about sub-template definitions and more.
IDUG is coming, IDUG is coming. Will you be there?
(Willie Favero) I know, you don’t have a clue what this post is going to be about, do you… LOL
Working with ASP.NET 2.0 Web Parts and Windows SharePoint Services 3.0
(Erika Ehrli) ASP.NET 2.0 provides a new set of possibilities for SharePoint developers. Jo-Anne West and I were talking about the cool things you can do with Windows SharePoint Services 3.0. Both of us have a background working with ASP.NET and SharePoint Products and technologies, so this is a fas
Validating Incoming Data by Using Polymorphism with Objects in PHP 5
(Alejandro Gervasio) If you’re a PHP developer who wants to learn how to take advantage of polymorphism to build more efficient and robust object-oriented applications, then this group of articles might be what you need. Welcome to the final part of the series that started with “Using Polymorphism w
How to alert on system errors
(Simon Sabin) Alerts in SQL server rely on the error being logged to the event log. Not all system messages are logged which means you can’t alert on them. In SQL 2000 you could hack the sysmessages table, however in SQL2005 you can’t.
Oracle Clusterware install: ‘Invalid parameters, or failed to bring up VIP’ after ‘interface is not public’
(Christo Kutrovsky) Allow me to guess the sequence of events that brought you to this blog, possibly via google. –You just installed the Oracle 10g clusterware –You just ran root.sh and got an error: The given interface(s), “eth0” is not public. Public interfaces should be used to configu
Getting Started with ASP.NET
(Jeff Cogswell) Ready to get started with ASP.NET? Great! Here’s what you’ll need. –If you don’t yet have the Microsoft .NET 2.0 runtime, download and install it here. –If you don’t already have Visual Studio 2005, then download and install the free Visual Web Developer 2005 Expression Editio
Designing Forms for Microsoft Office InfoPath and Forms Services 2007 (Part 2)
(Scott Roberts and Hagen Green) At this point in the book, you not only know how to design form templates that look nice but you can also take advantage of most of the basic (and some not so basic) features available when using InfoPath in design mode. Now you can create professional-looking forms i