External Article

Oracle to SQL Server, Crossing the Great Divide, Part 3

  • Article

We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.


3,312 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.


3,704 reads


Daily Coping 1 Dec 2022


Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan


So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?


SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs


Replication Statistics

By coolchaitu

In Transactional Replication, create index and Alter index commands do not get replicated to...

The Last Valid Restore Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Valid Restore Time

Getting started with ROUND() and Its Use Cases

By Manvendra Deo Singh

Comments posted to this topic are about the item Getting started with ROUND() and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers