Monthly Archives: November 2016

#SQLSERVERLearning : Exception on Invalid/Incorrect Hints?

All my blogs with #SQLSERVERLearning is intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for Oracle guy also working in SQL Server world. All findings or Observations with SQL Server … Continue reading

Rate this:

Posted in Oracle Internal, SQL Server Learning | Tagged , , , , | Leave a comment

#SQLSERVERLearning : Does Unique Index Stored NULL Values in Index?

All my blogs with #SQLSERVERLearning are intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for any Oracle guy also working with SQL Server. All finding or Observations with SQL Server … Continue reading

Rate this:

Posted in Oracle Internal, SQL Server Learning | Tagged , , , , , | Leave a comment

#SQLSERVERLearning : Only Execute Current Statement in SQL Server Mgmt Studio??

All my blogs with #SQLSERVERLearning is intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for Oracle guy also working in SQL Server world. For complete list of topics on SQL … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , | Leave a comment

SQL Developer : Add Custom SQL Query as Template.

Daily for SQL plan reading and analysis, using below command quite often from SQL Developer Tool. explain plan for statement_id = ”; select * from gv$sql where sql_text like ‘%%’; select * from table(dbmx_xplan.display); select * from table(dbmx_xplan.display_cursor(”,null,’ALLSTATS_LAST’)); Wouldn’t it … Continue reading

Rate this:

Posted in Helper SQL | Tagged , , | Leave a comment

#SQLSERVERLearning : Changing Short Cut in SQL Server for Query Execution.

All my blogs with #SQLSERVERLearning is intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for Oracle guy also working in SQL Server world. In SQL Developer for running any SQL … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , | 1 Comment

#SQLSERVERLearning : Alias are mandate for inline views

New challenge added to my career life – Microsoft SQL Server.! Now need to work on multiple database along with Oracle (My Fav) as primary. Most of folks feel , both are traditional RDBMS database and should or need to … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , | Leave a comment