Category
- Annual Report – Wordpress (1)
- Helper SQL (12)
- Oracle 12c New Features (9)
- Oracle Internal (38)
- Oracle Performance (2)
- SQL Server Learning (20)
Top Posts & Pages
- #SQLSERVERLearning : String Padding in Sql Server (LPAD/RPAD)
- Should we gather stats on Global Temporary Table within any Stats Job?
- SQL Developer : Add Custom SQL Query as Template.
- On Rac dbms_xplan.display_cursor will give plan if cursor is present on node connected.
- Adding Default Column to a table in Oracle and SQL Server.
Archives
- September 2018 (2)
- April 2018 (1)
- June 2017 (1)
- May 2017 (3)
- April 2017 (4)
- March 2017 (1)
- January 2017 (3)
- December 2016 (10)
- November 2016 (6)
- October 2016 (1)
- August 2016 (1)
- June 2016 (2)
- May 2016 (1)
- February 2016 (1)
- January 2016 (1)
- November 2015 (3)
- September 2015 (1)
- April 2015 (1)
- January 2015 (2)
- December 2014 (6)
- November 2014 (11)
- April 2014 (2)
- March 2014 (1)
-
Recent Posts
- Adding Default Column to a table in Oracle and SQL Server. September 21, 2018
- Table Alias in Oracle and SQL Server. September 18, 2018
- CHAR Datatype and ConCat in Oracle and SQL Server. April 3, 2018
- SQL SERVER# : Get last possible time for a DAY. June 2, 2017
- FIXED length character storage and NULL in SQL Server. May 31, 2017
- APPROX_COUNT_DISTINCT in Oracle 12c. May 24, 2017
- Lateral Views in Oracle 12c. May 12, 2017
- SQL Server : Value Constructor Insight. April 13, 2017
- SQL Server : ExecuteNonQuery shows incorrect rows affected. April 6, 2017
- SQL Server : Get Numeric part from a varchar/string. April 6, 2017
- Date Generator in SQL Server using Recursive With Clause. April 5, 2017
- #SQLSERVERLearning : Order By Learning. March 3, 2017
Blogs I Follow
- SQL with Manoj
- Shane Borden's Oracle Blog
- seanstuber
- Improving my SQL BI Skills
- SQLXpertise
- MirrorSpeaks
- Crafty Arty Namy
- Java, SQL and jOOQ.
- DBA-010
- SQL Jana
- amitzil - Oracle DBA blog
- The Oracle Sponge
- Talip Hakan Ozturk's ORACLE BLOG
- Learning is not a spectator sport
- Neeraj Bhatia's Blog
- ng-coder-$scope
- Adityanath's Oracle Blog
- Ahmed Abdel Fattah Blog !
- Database Store
- tier1app
Category Archives: SQL Server Learning
CHAR Datatype and ConCat in Oracle and SQL Server.
Char is a Fixed length data type, provided by database to stored Character Data. It will allocate fix bytes as per length specified for CHAR datatype and will pad with Space for remaining chunks. With Variable declare as CHAR(20), Byte … Continue reading
SQL SERVER# : Get last possible time for a DAY.
During one of SQL requirement, was trying to form Range of Years for executing a DML in small batches as per YEAR. But due to missing last possible end time, we were not able to manipulate some records. For instance … Continue reading
Posted in Helper SQL, SQL Server Learning
Tagged DATEADD, last time of day, MS, sql server
Leave a comment
FIXED length character storage and NULL in SQL Server.
Most of us must be aware of CHAR datatype and its fixed length storage pattern. If we declare CHAR(32) and store only 4 bytes character ‘ABCD’, It will pads up remaining bytes (28 bytes). Ultimately, whole bytes is consume for … Continue reading
SQL Server : Value Constructor Insight.
We all must be aware of VALUE Clause for Inserting values specified, in current blob we will explore different ways other then Insert were we can have use VALUE as handy.! 1. Generating Dummy Data! we can use Value to … Continue reading
SQL Server : ExecuteNonQuery shows incorrect rows affected.
For one of client as per functionality we were invoking a SQL Server procedure using ExecuteNonQuery method. Within procedure we had a DML statement performing update and on rows affected as return from ExecuteNonQuery performing further functional stuff. In one … Continue reading
Posted in SQL Server Learning
Tagged ExecuteNonQuery, NOCOUNT, rows affected, sql server
Leave a comment
SQL Server : Get Numeric part from a varchar/string.
Found question to fetch only numeric information from a string/varchar in some of blogs, so thought let try and share my attempt. Implement logic: 1. Using Recursive With clause, segregated each and every character as separate row. 2. Using Regex … Continue reading
Date Generator in SQL Server using Recursive With Clause.
During one of performance analysis, identified lofty insert statements populating static tables with Date information. As part of one of functionality, we were generating dates and applying necessary function on it within date range specified. As part of performance improvement, … Continue reading
Posted in Helper SQL, SQL Server Learning
Tagged date, date generation, function, sql server
Leave a comment
#SQLSERVERLearning : Order By Learning.
Most of folks feel , both(Oracle-SQLServer) are traditional RDBMS database and should or need to work some what “SIMILAR”. But, But when we actually start working on core with queries, development and tuning.We identified a lot of difference between any … Continue reading
Posted in SQL Server Learning
Tagged Distinct, inline views, order by, sql server, Top, XML Path
Leave a comment
#SQLSERVERLearning : String Padding in Sql Server (LPAD/RPAD)
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 finding or Observations with SQL Server … Continue reading
Posted in Helper SQL, SQL Server Learning
Tagged LEFT, LPAD, padding, REPLICATE, RIGHT, RPAD, sql server
Leave a comment
#SQLSERVERLearning : Export Table data as Insert statement in SQL Server.
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 finding or Observations with SQL Server … Continue reading
