(Pinal Dave) Yesterday I had discussed two analytical functions FIRST_VALUE and LAST_VALUE. After reading the blog post I received very interesting question.
Other News
Protect your sensitive data using InfoSphere Optim Designer
(Yuka Nomura) IBM InfoSphere Optim Data Masking Solution V2.2 is a solution to protect sensitive data in data sources with data privacy functions. IBM InfoSphere Optim Data Masking Solution V2.2 provides various features for data masking as “data privacy policies.”
Parallel Query Deadlocks
SSWUGtv – New Show! Will the cloud HELP our databases? Laura Rose, the news of the day and more. Also, the first in a series of segments on scale up vs. scale out and options that are available. [Watch the Show] Previously… Interview with Denny Cherry, SQL Server MVP and SSWUG.ORG Class Presenter. We also have the latest news on […]
SSWUG TV – Interviews with Bob Zurek from Endeca and SSWUG.ORG Presenter Laura Rose
Video Programming for IT Professionals
Survivor Feedback
Survivor Feedback You can picture the concept of Survivor as taking a harsh stance. Similar to the theory of evolution, Survival of the Fittest becomes a mantra. We remove our weak link so that the company can survive. Or, you can picture the concept of Survivor as motivation to help your company become efficient and competitive. Not for the purpose […]
Select For Update – In What Order are the Rows Locked?
(Charles Hooper) A recent thread in the comp.databases.oracle.server usenet group asked whether or not a SELECT FOR UPDATE statement locks rows in the order specified by the ORDER BY clause. Why might this be an important question? Possibly if the SKIP LOCKED clause is implemented in the SELECT FO
How to add pdf descriptions via XML files?
(Crystal) Today I am going to demonstrate how to add pdf descriptions via XML files. If you have the same question, please follow me. Have you ever know we can add pdf descriptions via XML files? If you want to add more information for your pdf files, you need to add pdf descriptions via XML files.
Tune That SQL to Improve DB2 Performance!
(Craig S. Mullins) Structured Query Language, better known as SQL, is a powerful tool for manipulating data. It is used in virtually every relational database management system on the market today, not just by DB2, but also by Oracle, Sybase, MySQL, and Microsoft SQL Server.
Two Misconceptions about the Semantic Web
(Jesse Weaver) I recently presented at the Semantic Graph Database Processing BOF at SC2011, and I had the opportunity to discuss with others the needs for high-performance computing in web-scale computation and the benefits of Linked Data and ontologies on the World Wide Web.
SQL Server: Effective Query Tuning
(Glenn Berry, Louis Davidson and Tim Ford) Query tuning is the heart and soul of optimizing SQL Server performance. If your typical workload consists of ill-designed or inefficient queries, you’ll experience performance and scalability issues. If your queries are longer, more numerous and more compl