(Harishkumar Baburao Pathangay) Video for Restoring Accidentally Dropped Table space.
Author: SSWUG Research
3 Big Data Disaster Recovery Performance Factors
(Dave Beulke) As I talked recently in my blog “Big Data: 5 Considerations for Disaster Recovery,” Big Data disaster recovery drives companies to intense analysis of the big data usage and its importance.
How to Use Cross Apply Instead of Cursors in SQL Server
(Krishna Turlapati) I recently ran into a stored procedure with cursor logic, I wanted to see what would be the performance gain if cursor logic is rewritten with set theory operations.
Is There Anything in that String?
(Peter Vogel) String variables look like value types, those variables holding integers and dates. But, under the hood, strings are more like reference types, those variables that point to objects.
The User Experience (UX) Of Manually Sorting Data
(Ben Nadel) I have a love-hate relationship with the gesture of manually sorting data. On one hand, I know that in some situations – like a PowerPoint presentation – manually sorting data is a critical part of success; yet, on the other hand, I know that in most situations, I have an extremely negat
Removing Diacritics from Strings
(Richard Carr) Diacritics are additional decorations or glyphs that are added to letters or symbols to modify the pronunciation or meaning of a character. For some functions, such as text-based searches or string comparison, it is useful to ignore diacritical marks.
Table recovery with rman in Database 12c
(Michael Abbey) One of the new features of rman in Oracle Database 12c is the topic of this short document. For many years since we first saw rman around 1994 (?) it was touted as the “weakest solution” for object-based recovery. We went through the lengthy and labour-intensive process of creating a
9b4m3fr3vf9kn and an4593dzvqr4v
(Bobby Durrett) You got to love Exadata and subpartitioned tables. We have these queries on one particular table that are taking forever to parse. Sometimes a simple explain plan on the simplest possible query against the table takes 20 or 30 seconds.
Username Availability Check in ASP.NET Web Forms with jQuery Validation Plugin
(Brij) In this article, we will make simple client side form validation in asp.net web forms using jQuery form validation plugin, check username availability and also add green check mark for valid data.
Redo Behavior
(advait) After Oracle 9.2, there has been a significant changes in redo behavior. Before 10g, Oracle used to have a single log buffer for writing redo information which eventually gets written to online redo logs in round robin fashion. Of course if your database is in archive log mode information f