(Andrew Reid) I ran this example on Oracle 11.2. If an application spends too much time waiting on log file parallel write and/or log file sync, it may be doing too many user commits. To illustrate this, I created the SQL*Plus script below.
Author: SSWUG Research
Dynamic SQL – Let’s Do The Math
(Craig S. Mullins) We’ve come a long way in the world of DB2 in the past decade or so. I remember way back when it was common for DBAs to say “If performance is an issue, dynamic SQL should not be used… always use static SQL!” But today, in 2014, it is usually the case that dynamic SQL is the […]
Feeling Your Informix OATs: Part 2
(Tom Beebe and Lester Knutsen) Part 1 of this series introduced the IBM OpenAdmin Tool (OAT) environment and its graphical user interface (GUI) available in IBM Informix software for making changes to Informix database systems. This concluding installment takes a look at some of the advanced sets of
More FAQs about SQL Server 2014 In-Memory OLTP
(Michael Otey) Based on the interest in the new SQL Server 2014 In-Memory OLTP engine, it seems that SQL Server 2014 will be adopted quickly by people eager to use this new feature.
Don’t (always) call v()
(Jeffrey Kemp) Instead of calling a function, when you can get the same effect by accessing a documented PL/SQL variable, you should. For example:
Redesigning Tablespaces in an Existing Database
(Ember Crooks) Like many applications, WebSphere Commerce puts all tables in USERSPACE1 unless they need larger page sizes. This actually works just fine for smaller and midrange implementations, but we have about one build a year that requires something else – either because of standards that clien
Button OnClick Event Handling In Android Using XML file
(Dinesh Kongonda) Hi friends it is observed that sometimes it observed that may of the events occur at button click, so in java we use OnClickListener to handle these events. As android uses java it also uses the similar syntax.
SQL 2012 ORDER BY list of RANGE window frame cannot contain expressions of LOB type
(Niall Best) I ran into this error when preparing some data for a report in SQL Server Reporting Services 2012. I was trying to partition data showing construction progress for work areas by week number using the updated ORDER BY clause for Windowing functions with SQL Server 2012.
T-SQL Anti-Patterns: Nested Views
(Kevin Feasel) Our next T-SQL anti-pattern is a performance killer. Similar to EAV, it happens when developers get a little too smart for their own good.
Tips to improve SQL Server database design and performance
(Vamsi Krishna Reddy.Munnamgi) Best performance is the main concern to develop a successful application. Like a coin database is the tail side (back-end) of an application. A good database design provides best performance during data manipulation which results into the best performance of an applica