Author: SSWUG Research

Community

Mining For ‘Yukon’ Nuggets

It sounds like “Yukon” Beta 1 is still 30 to 60 days out (and will be a closed beta with prearranged participants, anyway). But that won’t stop Microsoft from talking turkey about its next version of SQL Server, at the TechEd conference. We’ve been conversing since last fall with Randy Hollow

Community

DB2 XML Extender

DB2 XML Extender provides new data types to store XML documents in DB2 databases and new functions to work with these structured documents. Managed by DB2, these documents are stored as character data or external files. Retrieval functions enable you to retrieve complete documents or individu

Community

Shrink Database Size

by Naresh Awasthi – This database procedure can be used to shrink tablespaces by passing two values: 1. Tablespace_name 2. Freespace_keep_pct It’s specially useful if you are refreshing a dev instance from prod and you don’t want to occupy the same size RBS, TEMP, an