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
Read More...
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
Read More...