(Geniiius) One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing. Creating the optimal indexes for a system, is no where near a trivial excercise. You need to consider the read/write ratio as well as how you write your queries. This i
Other News
Effective Xml Part 4: Let me project this (Xml file) for you
(Pawel Kadluczka) Xml is ubiquitous. No doubt about it. It is being used almost everywhere and almost by everyone. This includes places where huge amounts of data are being processed. This means xml files (or streams) used there are also huge.
Transact-SQL Improvements with SQL Server 2008, Part 1
(Baya Dewald) Transact-SQL is a powerful programming language for developing and managing SQL Server databases. Microsoft significantly enhanced the language in the last few years, and many improvements were introduced in SQL Server 2008. In this two-part series, I discuss some of the improvements I
SQL SERVER – Denali – 14 New Functions – A Quick Guide
(Pinal Dave) Last two weeks I have written various blog post on new functions introduced in SQL Server Denali. So many comments and request I have received from various readers that they would like to see everything together.
Compare DB2 for z/OS and DB2 for Linux, UNIX, and Windows
(Balachandran Chandrasekaran) This article gives DB2 database administrators an overview of DB2 on a different platform than the one they’re most familiar with. Database administrators can leverage their DB2 skills on z/OS or on Linux, UNIX, and Windows (LUW) to understand how DBA tasks are carried
Database Appliances
Database Appliances Yesterday as I started the discussion around Appliances. I found it difficult to characterize the concept of Appliance and the different vendors providing these resources. Generally you could say appliances form the foundation for a private cloud offering while reducing the cost of designing and maintaining the configuration due to some form of standardization. I don’t have a […]
Database Appliances
SSWUG TV With Stephen Wynkoop Don’t miss this Interview with Mark Tabladillo, SQL Server MVP and acclaimed data mining instructor. Watch the Show Database Appliances One of the trends from vendors that seems to be growing is the database appliance. Different vendors are providing pre-defined systems individually or with strategic alliances. Oracle has taken the approach of having a single […]
Invalid Hints are Silently Ignored? An Invalid USE_HASH Hint Transforms a Sort-Merge Join into a Nested Loops Join
(Charles Hooper) How many times have you heard or read that the Oracle Database query optimizer may freely ignore hints if it so chooses? How many times have you heard or read that the query optimizer silently ignores hints that are invalid? I was recently reminded of both of these concepts while
Locating UNKNOWN SQL_ID Info in OEM Through AWR
(Kellyn Pot’Vin) Rarely are reports based off large snapshot variances helpful to a DBA unless you come across an odd situation such as this one…Better yet, we need to know a little bit about our AWR tables behind our reports so we can piece together what the reports leave out…:)
Oracle Big Data Appliance (BDA) — What’s Cooking?
(Alex Gorbachev) Oracle Big Data Appliance (BDA) is expected to be announced at the Oracle OpenWorld next week. It will take some time for it to be actually available for shipment and lots of details will likely change but there are good indications of what it’s going to be like.