Category Archives: SQL Server Learning

Generate Script for Foreign key’s in SQL Server.

Posted on January 11, 2019 by Deepak Mahto

During conducting one of the Proof Of Concept around “InMemory“, we had to disable foreign key to use Migration wizard provided by SSMS. Before disable, we had to create script for all foreign key for multiple tables in Database and … Continue reading →

Rate this:

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

Aliasing Table in Oracle and SQL Server and interesting difference.

Posted on September 18, 2018 by Deepak Mahto

Sometimes we assume things to work and not test it, but it surprise you and give you a reason to learn. We have a product that works on top of both Oracle and SQL Server, hence we are bound to … Continue reading →

Rate this:

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

CHAR Datatype and ConCat in Oracle and SQL Server.

Posted on April 3, 2018 by Deepak Mahto

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 →

Rate this:

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

SQL SERVER# : Get last possible time for a DAY.

Posted on June 2, 2017 by Deepak Mahto

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 →

Rate this:

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

FIXED length character storage and NULL in SQL Server.

Posted on May 31, 2017 by Deepak Mahto

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 →

Rate this:

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

SQL Server : Value Constructor Insight.

Posted on April 13, 2017 by Deepak Mahto

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 →

Rate this:

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

SQL Server : ExecuteNonQuery shows incorrect rows affected.

Posted on April 6, 2017 by Deepak Mahto

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 →

Rate this:

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

SQL Server : Get Numeric part from a varchar/string.

Posted on April 6, 2017 by Deepak Mahto

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 →

Rate this:

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

Date Generator in SQL Server using Recursive With Clause.

Posted on April 5, 2017 by Deepak Mahto

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 →

Rate this:

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

#SQLSERVERLearning : Order By Learning.

Posted on March 3, 2017 by Deepak Mahto

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 →

Rate this:

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