(Willie Favero) I thought this no-charge teleconference might be of interest to some of you. It’s a few weeks away but I wanted to give you time to get it onto your calendar. Everything in blue is copied directly from the IBM announcement of the event.
Other News
How Fast Can Updates Run?
(Martin Farach-Colton) Last time, I introduced the notion of strict and lenient updates. Now it’s time to see what the performance characteristics are of each.
Keywords in Oracle
(Steve Callan) Some words in Oracle have special meaning. Maybe not to you, but then you’re not the one having to parse, execute and fetch what you type. To be more precise, the “some words” in the first sentence can be categorized as reserved words and keywords. Within the keywords category, contex
calculating differences in time
(Jasper) Ok, so there’s this very useful standard function called ‘ADD_MONTHS’ in Oracle, which gives you your date added with a couple of months.
List-Of-Values Component in Search and Edit Form
(Andrejus Baranovskis) Sample application described in this post contains high practical value, it implements real use case. Defined use case – based on value selected in List-Of-Values (LOV) component, perform query in database and display results in form. Form with results is updated, when value i
Multicores/manycores and conventional wisdoms
(Linchi Shea) There seems to be a consensus that we are at an important inflection point in computing because of the emerging trend towards multicores on a chip near term and manycores on a chip in a not so distant future. If you are writing software, you need to have a solid understanding of what t
Integrating Profiler and PerfMon Log Files
(Mladen Prajdiæ) Troubleshooting SQL Server requires the use of both PerfMon (Performance/System Monitor) and SQL Trace files created by SQL Profiler or directly by SQL Server trace. Analysis of the gathered data is much easier if you can correlate your trace file with the PerfMon counters. In this
Multiple Server Query Execution in SQL Server 2008
(Eric Kang) SQL Server 2008 SSMS introduces a new feature, Multiple Server Query Execution, in Query Editor. This feature intends to increase the productivity of running same query against multiple servers at once. Some of useage include: · Configure group of servers or server farm · Generate re
Search Engine Q&A #14: Beware 3rd party file-system drivers with DBCC CHECKDB
(Paul S. Randal) Here’s an issue that I thought was a one-off but it just popped up again over the weekend so I want to publicize it.
Growing Your SQL Server Position Into Unchartered Waters
750+ registrations for the SSWUG SQL Server Virtual Conference! See you all there! http://bitonthewire.wpengine.com/conference Books Directory Updated We’ve been busy updating our books directory – have you seen it lately? From SQL for MySQL Developers to SQL Queries for Mere Mortals and more, we have some great titles for you to take a look at. When you get a few […]