(Frank Kalis) It is nothing really new that indexes have their right to exist in SQL Server. It is also nothing really new, that these indexes need to be maintained every now and then, even though this might be surprising for people who are lulled by the otherwise low maintenance for SQL Server.
Other News
How to Generate Automatic DUMP of SQL Server 2008 Instance on a cluster
(Chris Skorlinski) Use following steps to enable SQL Cluster Resource to automatically generate a dump of a SQL Server Named Instance before a shutdown/failover occurs.
OEM 11g install and ORA-12650
(Miladin Modrakovic) Two weeks ago I was trying to install OEM grid control version 11 .I did it many times already but this time my process failed in the middle of install.
A couple of nice features when using OracleTextSearch
(kyle.hatlestad) If you have your UCM/URM instance configured to use the Oracle 11g database as the search engine, you can be using OracleTextSearch as the search definition. OracleTextSearch uses the advanced features of Oracle Text for indexing and searching. This includes the ability to specify m
Moving Subtrees in Closure Table Hierarchies
(Bill Karwin) Many software developers find they need to store hierarchical data, such as threaded comments, personnel org charts, or nested bill-of-materials. Sometimes it’s tricky to do this in SQL and still run efficient queries against the data.
The Power Of Closures – Deferred Object Bindings In jQuery 1.5
(Ben Nadel) Over the weekend, I started to explore the Deferred objects that were added to jQuery 1.5. Deferred objects are stateful queues that can trigger success and fail event handlers. In a follow-up exploration, I wanted to see if I could use Deferred objects to power asynchronous script loadi
IBM Optim Performance Manager for DB2 for Linux, UNIX, and Windows
(Whei-Jen Chen, Ute Baumbach, Robert Borovsky, Sonali Kenge, Marcia Miskimen and Ling Xu) Optim Performance Manager Extended Edition, a follow-on to DB2 Performance Expert, is one of the key products of the IBM Optim Solution. Optim Performance Manager Extended Edition provides a comprehensive, proa
A Guide to Better Risk Management for DB2 LUW DBAs
(Rebecca Bond) IBM DB2 DBAs intuitively deal with risk identification and management every day, yet they may still be impacted by risk management in ways that they may not recognize.
SharePoint and The Importance of TEMPDB
(Joaquin Torres) One of the most important SQL Databases with regards to SharePoint is the TEMPDB. Most SharePoint performance issues are due to improper SQL configuration and more importantly, not giving enough thought to the tempdb itself. In SharePoint, every action that you take is staged in t
Innovations within reach: Enhance your ESB with the REST Gateway feature in the WebSphere DataPower XC10 Appliance
(Charles Le Vay, Thomas Gissel and Lan Vuong) The IBM WebSphere DataPower XC10 Appliance now expands the range of clients able to access simple data grids with the release of the REST Gateway feature. Non-Java based clients with HTTP capabilites, including PHP and .NET clients, can utilize the XC10