by Laurence Moroney – The conversion of the native office document format to XML allows developers to create documents on the fly and serve them from a Web service. Read this article to learn how.
Author: SSWUG Research
Inside SQL Server 2000
By Kalen Delaney – Inside SQL Server 2000 was published in November 2000. As an update to my 7.0 update of Ron Soukup’s best selling 6.5 version, it is intended to fill in many of the gaps left by the online documentation dealing with how SQL Server actually stores and processes data internally. It
Cross-Join Performance
By Russ Whitney – When you’re analyzing terabytes of data, the performance of your CROSSJOIN() functions can make–or break–your application’s overall performance.
Fast way to add a comment header
By Michael Garstin – For a rapid way to add a comment header to your code from Query Analyzer, add a “comments.tql” file to the Query Analyzer Templates sub-directory.
OracleInstall
Have you downloaded Oracle trial software from Oracle Corp.’s Web site? Are you having any problems? Do you have any questions? OracleInstall provides installation assistance and technical information for Oracle’s free trial software. This information is available to you from Oracle’s Web sit
The brain that thinks out of the box.
By Mikael Bergkvist – Thinking out of the box might be a dangerous thing. Usually it’s assumed to be good, but how can it, in a world where solutions are sold for a profit? This is the direct opposite to creativity, which is the driving force behind the capitalistic principle of creating nish
Read XML from a File by Using Visual Basic .NET
This article demonstrates how to use the XmlTextReader class to read Extensible Markup Language (XML) from a file. XmlTextReader provides direct parsing and tokenizing of XML and implements the XML 1.0 specification as well as the namespaces in XML specification from the World Wide Web Consortium (W
W3C proposes XML encryption methods
By Paul Festa – The Web’s leading standards group proposed two recommendations for encrypting XML data and documents, a key development in the organization’s push to standardize technologies crucial to Web services.
INSERT, UPDATE and DELETE Costs
by Joe Chang – If you can’t wait until the final version of this article on INSERT, UPDATE, and DELETE costs in SQL Server, this preliminary article on INSERT costs is a good start.
Fast Delete of Duplicate Rows
by Riju George – With reference to your tip for the week 08/04/2002 submitted by Madan Patil, this is another way of deleting duplicate rows from a table. The difference being the time it takes to delete the duplicate rows with this method is many times faster than the earlier method.