(JackLi) Today, I want to point out another SQL Server 2012 SP2 fix that may affect your performance troubleshooting. When you are troubleshooting a long running query, chances are you will use sys.dm_exec_requests to look for progresses of the query. But one of the column – cpu_time is not accurate
Other News
Overview of SharePoint 2013’s Social Computing Capabilities
(Errin O’Connor) Social collaboration in the workplace has been embraced by some organizations and really shunned by others due to possible legal and compliance concerns. Both types of organizations, those who embrace it and those who feel the ROI does not outweigh the risk, have valid points and un
Using the MERGE Statement to Perform an UPSERT
(Greg Larsen) The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement.
Customizing MONREPORT … or not
(Ember Crooks) If you’re not familiar with MONREPORT, see my DB2 Basics entry on MONREPORT first.
Resource Balancing — Disk Space
(Lockwood Lyon) With access path tuning addressed, the database administrator can now turn to the details of query execution to determine if a long elapsed time can be reduced.
Formula Evaluation – Expression Parsing
Yesterday I introduced the concept of evaluating a mathematical expression using a C# technique that converts the string to values and operations that can be performed. The code that performs the calculation uses expressions in the form of postfix notation (sometimes called Polish Notation) simplifying the calculation process. One difficulty is that we are taught to write equations using infix […]
Planning of Database Structure & Organization — Part — 2
Planning of Database Structure & Organization – Part – 2 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning different associations available like 1 – to – 1, 1 – to – N or N – to – 1”, here is the article. Associations:- The planning of associations is determined...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Introduction and resources for migrating from Oracle to DB2
(Henrik Loeser) Well, a boring headline for an interesting topic. Originally I had planned to title today’s blog entry “Forget about Black Friday and Cyber Monday – Save big by moving to DB2”. But then writing this entry has dragged on for some days…
Build a simple catalog management application for e-commerce
(Maobing Jin, Aditya Joag, Rohit Gargate and Mohana Kera) In this tutorial, we will demonstrate a catalog management system for e-commerce solutions through an application on top of InfoSphere MDM Collaborative Edition and WebSphere Commerce Enterprise Edition. The application will provide a simple
Choosing A Cloud App? Look For a JSON-based API
(Andronikos Nedos) If your company isn’t already using a cloud-based business application, there’s a very good chance that they will be in the next year or so. What makes me so sure?