By Joe Wilcox – Microsoft will launch Commerce Server 2002, new software for building e-commerce Web sites and one of the first products supporting the company’s .Net strategy.Commerce Server 2002 will allow Web site operators to manage catalogs of products and services and to tailor the con
Author: SSWUG Research
Configure Memory for More Than 2 GB in SQL Server
This article describes how to configure SQL Server to use more than 2 GB of physical memory. Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 dynamically acquire and free memory as needed. When you run multiple instances of SQL Server on a computer, each instance dynamically acquires an
Optimizing Stored Procedures To Avoid Recompiles
One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. Recently started looking at this issue where I worked and stored procedures gathered from other clients and I noticed that there is an issue with SQL developers not taking recompile
Is a Temporary Table Really Necessary?
From SQLServerCentral – In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.Free registration is required.
XML Namespaces 1.1
by Leigh Dodds – Namespaces have probably generated more debate and confusion than any other W3C Recommendation. With the first publication of a Working Draft for Namespace 1.1, which has caused a great surge of discussion on XML-DEV, it seems like the next iteration of the specification won't b
Tip: Grab headlines from a remote RDF file
By Nicholas Chase – In this tip, Nick shows you how to retrieve syndicated content from RDF and RSS files and convert it to headlines for your site.
US report urges slow road to XML
By Margaret Kane – A new report is cautioning US federal agencies to go slowly in adopting XML. The General Accounting Office found that, in the absence of any formal governmental policy or standard on XML, federal agencies might want to hold back before adopting the Web standard. But the GAO
Oracle wants to be the host with the most
By Ed Parry – When Oracle announced it was getting into the hosting business in a big way, it wasn’t kidding. The company is turning into an outsource to be reckoned with.Oracle has cut the ceremonial ribbon for its 9i Database and Application Server hosting and managing services. The servic
Statement Tracer for Oracle
Above Software has made available a free beta release of their new Statement Tracer for Oracle software. Statement Tracer can be downloaded and used for free through the end of April (an official release is expected in early May).Statement Tracer for Oracle is an effective and easy-to-use so
Create a Developer’s Extract of a Production Database
By Drew Georgopulos – With this 10-Minute Solution, you will meet the challenges of providing a manageable development environment. You will develop an extract of the production environment that is just like production in every way but size, enabling developers to work with a representation of the d