what do you think happens with appended spaces in sql

select len('dfdf       ')

select len('       dfdf')

in oracle too!


select * from
(

select 'sdff   ' a  from dual
)  main

where main.a ='sdff'

Dirty reads in SQL Server

it's important to understand that sql server reads the new uncommited value - not the original value like in Oracle.

bitmap indices

sql server does not have this functionality- point for oracle