By Sergey Solodilov – This tip decreases the size of files of a tablespace to the bare minimum. It’s useful when you have many files in a tablespace and you’ve moved some tables or indexes into another tablespace, and then you want to decrease the size of the first tablespace.
Other News
Create Your Own SQL Server Job Management System
by Randy Dyess – If you don’t have the ability to easily manage the jobs on your SQL Server, then you may want to consider writing your own SQL Server job management system, like the one described in this article.
XQX Version 1.0-Beta, an XML interface to relational databases
XQX is the innovative product which enables companies to make available, their data, in an easy and effective manner. With the power of XQX companies can allow people, both within and outside their organization, to retrieve important information, and deliver that information to a variety of endpoint
Architectural Design Patterns for XML Documents
by Kyle Downey – This pattern contains XML untyped by DTD or schema, but follows accessors for underlying program objects. It allows for unlimited extension by multiple, uncoordinated parties at the cost of lack of type-checking; and is simple to implement, with supporting libraries abounding (e.g.
Office 2003 may pose antivirus problem
By Patrick Gray – The problem centers on macros embedded in documents in the Office 2003 beta, or test, version. When saved as an XML (Extensible Markup Language) file, the macros can more or less wind up anywhere. This means that scanners must search the entire contents of a file, rather than exami
MySQL or SQL Server: Look beyond politics and hype when deciding which to use
By Sanders Kaufman, Jr. – Aside from the obvious difference of price, what distinguishes these two products from each other, and how do you choose between them? Let’s take a look at the core differences between these two products, including licensing costs, performance, and security.
Oracle ups Linux efforts with ISV program
By James Niccolai – Oracle is launching a program to encourage its software partners to offer versions of their applications for Linux, and it will pay out some $150 million a year as part of the initiative to help with their marketing and development efforts.
Microsoft Gets Serious About Systems Management
By Barbara Darrow – The upcoming Microsoft System Center will meld capabilities to be offered by the company’s upcoming Systems Management Server 2003 and Microsoft Operations Manager 2004 into an enterprise-ready systems management suite, executives said Monday.<Br><br>MOM 2004 will also provide ne
Getting the last row from a table
by Sunil Bhola – Everyone knows that how to get the first row from a table but what if you want to get the last row and don’t know how many rows are in the table? This query will solve it!
SQL Server Security Audit and Performance Review
ClearData Consulting offers a one-day audit of your Microsoft SQL Servers to ensure secure, efficient systems. Our consultants will come on-site to monitor your system, perform system tests and interview your staff to look for possible ways to improve in the following areas: