(Ben Nadel) I started digging into Node.js recently as a means to understand why my Gulp.js build script wasn’t working. This lead me down a rabbit hole of exploration into Streams in Node.js and, more specifically, into how streams handle errors. And, while this may be obvious to most Node.js devel
Other News
Finding Duplicate Records Using GROUP BY in SQL Server
(Vishwanath Dalvi) There are various times when we need to find duplicate records in SQL Server. It is possible to find duplicates using DISTINCT, ROW NUMBER as well as the GROUP BY approach.
The SQL Server 833, What Is It?
(Michelle A. Poolet) Here’s a story that I’d like to share, about the infamous SQL Server 833. A while ago I was on a performance-tuning call at a client site; they’d been experiencing event 833 from some of their production SQL Servers, and they wanted to know if this was a SQL Server problem or a
Zone Maps
(Alex Fatkulin) Zone Maps is a new feature that got officially introduced in 12.1.0.2.0 so I’ve decided to take a closer look.
What Is Oracle Elapsed Time And Wall Time With A Parallelism Twist
(Craig Shallahamer) In this post I’m focusing on Oracle Database SQL elapsed time, adding parallelism into the mix and then revisiting wall time. What initially seems simple can take some very interesting twists!
Getting started with Oracle Database In-Memory Part III – Querying The IM Column Store
(Maria Colgan) In my previous blog posts, I described how to install, enable, and populate the In-Memory column store (IM column store). This weeks post focuses on how data is accessed within the IM column store.
Generate reports remotely and offline with InfoSphere Optim Performance Manager command-line utility
(Amitava Kundu, Anushka Chandrababu, Neela Madhav Suram and Ellen Livengood) You can use predefined report features in the InfoSphere Optim Performance Manager for DB2 for Linux, UNIX and Windows web console to generate reports in HTML, PDF, PPT, and XLS formats.
‘this’ in JavaScript
(Ronnie Mukherjee) Few people learn JavaScript as a first programming language. Typically people will start with an object-oriented language such as C#, Java or C++.
When you really need to know why your SQL Query’s slow
(Tony Davis) It is useful to know that a SQL Query is slow, but it is even better to know why. To do this, we need to see how SQL Server’s Query Optimizer has translated the query into something that it can execute, and what happened at each stage of execution, and for this we need to see the execut
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype
(Pinal Dave) Seven years ago, I wrote a blog post about – Query to Find Seed Values, Increment Values and Current Identity Column value of the table. It is quite a popular blog post and lots of people like it as it gives immediate details about Identity Values.