(Bobby Durrett) We are having challenges with queries that spend most of their time on these waits:
Other News
New profiler.sql script to nicely report top time consumers out of PL/SQL Profiler (DBMS_PROFILER) data
(Carlos Sierra) PL/SQL Profiler has been around for more than a decade. With DBMS_PROFILER we can “profile” the execution of PL/SQL code. This is great when the poor performance happens in PL/SQL code and not necessarily due to SQL statements from those PL/SQL libraries. In such cases Trace/TKPROF a
Why did that report run slow? ASH says log file sequential read
(Dominic Brooks) I’ve just been investigating why a certain report ran slow last night.
Semantic models for CDISC based standard and metadata management
(Kerstin Forsberg) In mid April we did a presentation at the 2012 CDISC Interchange Europe with the title: Semantic models for CDISC based standard and metadata management (see our slides and short paper). This time in a sunny, but chilly, Stockholm at a very nice hotel (Elite Marina Tower). Last ye
The DB2Night Show #81: DB2 LUW V10 Breaking News Part 2 with IBM Guests
(Scott Hayes) Again, 100% of our audience learned something! Our special guests, Danny Arnold, IBM Executive IT Specialist, and Glen Sheffield, IBM Toronto Data Warehouse and Big Data Specialist, shared with us Part 2 of our deep dive into What’s New in DB2 LUW V10.
Why is my SSAS Query Log Table Empty?
(Melissa Coates) In Management Studio, if you right-click the SSAS Server instance, you are presented with Analysis Server properties. Here is where you tell SSAS to log queries. The default table name is “OlapQueryLog” which will reside in the database you specify in the connection string.
APAR Friday: Small glitch with DSNZPARM keyword DDLTOX
(Willie Favero) Back on July 11, 2011 ( I can’t believe it’s been a year almost already) I wrote about a new DSNZPARM keyword that was introduced that applied a timeout controls on DDL, different from the rest of the timeout knobs that already existed in DB2.
Changing Granularity of Leaf Level Calculations in SSAS Tabular
(Jason Thomas) My company is awesome!!! Everyday that I go to work, I discover something new and exciting from the people around me and come back home thinking – wow, today was just legendary! The best part of the day is when I get to discuss ideas with my colleagues, it is so fulfilling intellectua
SSIS 2012 – New expression language functions(ReplaceNull,Left, Token, TokenCount)
(Jason Yousef) SQL Server 2012 is full rich of new features for SSIS, really many new useful stuff, such as the script task debug and the renovated Flat File Source, that could handle uneven number of columns…
SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116
(Balmukund Lakhani) Question: All objects can have minimum 1 and maximum of 128 characters in their names in SQL Server. Only exception is local temporary tables that can have maximum of 116 characters. What’s the technical reason behind this? Anyone, why that’s so?