Oracle

External Article

Deciding on a Primary Key in Oracle

  • Article

Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.

2015-08-25

4,312 reads

External Article

Webinar: Oracle Exadata & In-Memory Real-World Performance

  • Article

On January 28th 3PM GMT, Randolf Geist will present a free, one-hour webinar analyzing different database query profiles based on a real-world customer case. He'll also look at how these different profiles influence the efficiency of Exadata's features and the new Oracle In-Memory column store option. Register now.

2015-01-23

8,371 reads

SQLServerCentral Article

Free Webinar: Statistics in Oracle and SQL Server

  • Article

In their third live 'Oracle vs. SQL Server' discussion, Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will look at statistics in Oracle and SQL Server. Expect a lively debate on Oracle vs. SQL Server from two leading RDBMS experts on Jan 23, 2013.

2013-01-22 (first published: )

2,678 reads

External Article

Oracle to SQL Server: Crossing the Great Divide, Part 1

  • Article

When a SQL expert moves from Oracle to SQL Server, he can spot obvious strengths and weaknesses in the product that are too familiar to be apparent to the SQL Server DBA. Jonathan Lewis is one such expert: In this article he records his train of thought whilst investigating the mechanics of the SQL Server database engine. The result makes interesting reading.

2010-05-10

3,704 reads

Blogs

A Conversation That Refused to End: What We Learned from Our First Event in Zurich

By

On May 8, 2025, we hosted our first official event in Switzerland at Prime...

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

Read the latest Blogs

Forums

The Internals of Writing a Page

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Internals of Writing a...

How to Safely Remove a SQL Server Data File Without Downtime

By shukla.chandan12

Comments posted to this topic are about the item How to Safely Remove a...

Question on SQL Query with NOT condition

By mcfarlandparkway

I have a record, in those the three columns where firstname / last name...

Visit the forum

Question of the Day

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

See possible answers