So which null equals this null, that null? maybe this null, or is it this null?

Posted by GrumpyOldDBA on SQL Blogcasts See other posts from SQL Blogcasts or by GrumpyOldDBA
Published on Wed, 16 Jun 2010 19:15:56 GMT Indexed on 2010/06/16 20:54 UTC
Read the original article Hit count: 496

Filed under:

diagnostics

|

General Tuning

|

best practice

Tuning takes many routes and I get into some interesting situations and often make some exciting finds, see http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/17/just-when-you-thought-it-was-safe.aspx for an example. Today I encountered a multitude of Foreign Key constraints on a table, now FKs are often candidates for indexes and as none of the defined keys had an index it required a closer look. I view foreign key constraints as somewhat of a pain, excessive keys can cause excessive related...(read more)

© SQL Blogcasts or respective owner

Related posts about diagnostics

Add Trace methods to System.Diagnostics.TraceListner

as seen on Stack Overflow - Search for 'Stack Overflow'
I wrote a Log class derived from System.Diagnostics.TraceListener like so public class Log : TraceListener This acts as a wrapper to Log4Net and allows people to use System.Diagnostics Tracing like so Trace.Listeners.Clear(); Trace.Listeners.Add(new Log("MyProgram")); Trace.TraceInformation("Program… >>> More
The Benefits of using Oracle Diagnostics for Oracle Applications

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Listen to Kurt Larsen, Vice President of Oracle Support provide an update on the cost savings and problem avoidance provided to customers using Oracle Diagnostics within the E-Business Suite! >>> More
EBS: How To Install Oracle Diagnostics

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Diagnostics Support Pack is available as a patch and can be applied using adpatch. Installation is easy. Just follow the steps in Doc ID 167000.1, eBusiness Suite Support - Oracle Diagnostics Support Pack Installation Guide For information on how to run the Diagnostics from a menu within… >>> More
Hello it’s your server calling

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
This is nothing exciting but I've always found this startup procedure very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's own this procedure can't actually be… >>> More
Cursors 1 Sets 0

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on the production server for the past 4 years I guess… >>> More

Related posts about General Tuning

WebLogic Server Performance and Tuning: Part I - Tuning JVM

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Each WebLogic Server instance runs in its own dedicated Java Virtual Machine (JVM) which is their runtime environment. Every Admin Server in any domain executes within a JVM. The same also applies for Managed Servers. WebLogic Server can be used for a wide variety of applications and services… >>> More
SQLAuthority News – A Successful Performance Tuning Seminar at Pune – Dec 4-5, 2010

as seen on SQL Authority - Search for 'SQL Authority'
This is report to my third of very successful seminar event on SQL Server Performance Tuning. SQL Server Performance Tuning Seminar in Colombo was oversubscribed with total of 35 attendees. You can read the details over here SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand… >>> More
Resources for JVM Tuning

as seen on Stack Overflow - Search for 'Stack Overflow'
Anybody knows a good book or two (or resources) for JVM Tuning? I am struggling to find any. I stumbled upon Apress Java EE 5 Performance Management and Optimization, but there was not much in there. >>> More
Performance Tuning Tips for Apache

as seen on Internet.com - Search for 'Internet.com'
Apache is one of the most successful open source projects of our times. A big advantage of this popularity is that over the years people have spent a great deal of time fine tuning the software for better performance. Read on to learn more. >>> More
When Tuning Oracle is not an Option

as seen on Internet.com - Search for 'Internet.com'
Before you start monitoring your Oracle database, make sure you understand some of the behind-the-scenes issues of using Oracle monitoring. >>> More