(Vadivel) We might have heard that always we need to create our CLUSTERED index first then NONCLUSTERED indexes.
Other News
A SQL Server XQuery example demonstrating how to delete multiple elements
(Jacob Sebastian) This example shows how to delete multiple elements from an XML document using XML DML in TSQL.
Unhandled exception has occurred while running in Azure
Windows Azure, just like any other IIS website can crash if an unhandled exception occurs. One way that this can happen is if you are calling an Async function call and in the function that is called on completion, you throw an exception.
New Feature in ODI 11.1.1.6: Enterprise Data Quality Integration
(Julien Testut) Oracle Data Integrator 11.1.1.6.0 introduces a new Open Tool called EnterpriseDataQuality which allows ODI users to invoke an Oracle Enterprise Data Quality Job from a Package. This post will give you an overview of this new feature.
slow_log and general_log tables in MySQL 5.1
(Nilnandan Joshi) “Server log tables” is one of the finest feature in MySQL 5.1 version but It looks like people are not using this feature regularly or perhaps they are happy with files only. Here, I’m explaining how we can enable that feature, use it and how it will be helpful for filtering the re
Looking for missing memory using R
(Gwen Shapira) The best thing about Hotsos is the participants. It seems like everyone I meet there is very smart and very educated. This can be intimidating for presenters, but it also makes for good hallway conversations. I had several conversations in Hotsos where I expressed my delight in using
Testing ADF BC Proxy User DB Connection in Multi-User Environment
(Andrejus Baranovskis) I had a blog post about ADF BC Proxy User DB connection – Extending Application Module for ADF BC Proxy User DB Connection. It was quite interesting to test, how this approach works in multi-user environment, when passivation/activation happens. Good news – I didn’t found any
Introducing InfoSphere Streams 2.0 features, Part 1: Application monitoring with metrics
(Chris Howard) New to IBM InfoSphere® Streams 2.0, the introduction of the metrics component provides runtime access to system and user-defined statistics than can be used to monitor the inner workings of your Streams application. This article outlines the new metrics system and describes how to acc
SQL Server: Search Stored Procedure Create/Modify Date or Text using T-SQL
(Justin Cooney) SQL Server Management Studio (SSMS) is a great tool for managing instances of your SQL Server databases. Sometimes, though, the fastest way to retrieve information you are looking for isn’t through the SSMS GUI, but through direct SQL queries.
Yet Another Bundling Approach for MVC 4
(K. Scott Allen) ASP.NET MVC 4 allows you to bundle multiple JavaScript or CSS files into a single “bundled” download, and optionally minify the bundle to reduce the download size. John Peterson has a good introduction to the feature.