Get an overview of Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE) query processor, followed by some application and query performance tuning approaches.
Other News
Serious About Security
By Michael Otey – Even with Microsoft’s ramped-up security efforts, your systems are still only as secure as you make them. Here are some common-sense measures you can take to safeguard your SQL Server systems.
Tablespace usage view
By Andrew Barringer – This view allows you to easily see the top 10% by Row Count, Space Used, etc. This is useful for answering the question “what’s taking up all the space in my database?” I wrote it when asked to find what table(s) were using all the space in a particular database.
Range Comparison in DECODE
by T.R. Bharath Rajkumar – One common requirement when writing queries is to do a range comparison in DECODE. But DECODE allows only exact comparison. Range comparison can be achieved by making use of the function SIGN in DECODE.
Oracle, SAP Goal: Speedy Analytics
Oracle Corp. and SAP AG are building software to analyze data within their enterprise applications, but some users say the new and enhanced tools will have to prove themselves more effective than existing business intelligence tools from third-party developers.
XML in the Raw?
by Kurt Cagle – Kurt Cagle says we shouldn’t become so fixated on hiding XML that it disappears. Read his commentary on the fight between the XML Brokers, the XML Linguists, and other groups on whether to “clothe” XML or keep it “naked.”
The 10 Technologies that Will Help You Stay Employed
by A. Russell Jones – Keeping up with key technologies is the best thing you can do to give yourself an edge in the employment market now—and in the future. Are you at least semi-proficient with all 10 of the technologies on our list?
Automatic Numbering, Part Two
by Bob DuCharme – In last month’s column, we saw how XSLT’s xsl:number element lets you add numbers to your output for numbered lists or chapter and section headers. We looked at some of the attributes of this element that let you control its appearance — for example, how to output the numbers as R
True DBA Blooper #9: Backup plan backfires
By Sara Cushman – Every DBA knows the importance of a good backup and recovery plan, but finding one that actually works isn’t so simple.
SQL Server, XML, and the DBA
by Daryl Barnes – Find out about SQL Server and XML in this chapter except from SQL Server 2000 XML Distilled from Curlingstone Publishing.