(Ovais Tariq) I have been working with a few customer cases and one interesting case popped up. The customer was facing a peculiar problem where the rows column in the EXPLAIN output of the query was totally off. The actual number of rows was 18 times more than the number of rows reported by MySQL i
Other News
Warning of Uncommitted/Unsaved Changes in ADF Faces Pages
(Shay Shmeltzer) Ever wondered how to notify users of your ADF Faces application that they have uncommitted changes on their ADF page before they go off and check their facebook page (or just close the browser’s tab)?
GridviewFix jQuery plugin
(RupeshKumar) In this article, I have discussed the problem that developer faces while using dataTable plugin with Asp.net Gridview control and suggested the solution for the same problem. This article is for you, if you are using very famous dataTable jquery plugin with Asp.Net data-bound server c
A CLR Alternative to the SQL Server ISNUMERIC function
(Joe Kunk) Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function.
List all triggers in a database with its source code
(Vadivel) Yesterday I saw a question in a forum asking for help in writing a script to list out all Triggers within a database. They also wanted to see the source code of each trigger.
How to Programmatically Set User And Group Permissions
(Ivan Ivanov) There is a company with a lot of employees. The requirement is to automate the request process and the approval of employees’ holidays.
Use database catalog filtering in IBM Data Studio to view, manage, and work with database objects efficiently
(Loic Julien, Salvador Ledezma, Hardik Patel and Gary Gong) This article describes a new filtering capability made available in IBM® Data Studio. By filtering directly from the underlying database catalog, this function allows Data Studio to provide an overall improved experience with less informati
Microsoft SQL Server 2008 R2 StreamInsight Overview
(Tim Cullen) I was reviewing some of the new features in SQL Server 2008 R2 and ran into a technology named StreamInsight. The company I work for is a large manufacturing and distribution company and I think this technology could benefit the company. What is StreamInsight and what benefits can the c
Another Attack of Colossal Stupidity
Another Attack of Colossal Stupidity Like you, I also get the daily newsletter in my Inbox. I write and submit the editorial, and SSWUG builds everything else. I saw a link yesterday for one of the most frequent searches this past month, “SPOOL OUTPUT SQL SERVER”, and decided to click on it. Lo and behold, I come across a forum […]
Maintenance Task Considerations
Maintenance Task Considerations We received a number of replies regarding the Maintenance Wizard shipping with SQL Server. A number of the comments raise concerns I hadn’t even considered, such as what happens when you move to another version of SQL Server and use undocumented tools to support the MS GUI. David: I share your opinion. When you combine the three […]