I have been working on a demo code to simulate a performance based query from a SQL 2005 instance on new 2008 instance for testing purpose. This is to prove how the latest version features can help to attain the performance and to avoid any changes to the code. Intellisense is most wanted feature by...
In oracle IF a session start with RESUMABLET RASACTION , If any DATA FILE got full for any reason the transactions running in that Session they will be waiting until you add more datafiles. However,In current version of SQL if it ran out of space in data file it will die and rollback the whole transaction...