Learn With Sundar

Get Started

  • Change Schema Name Of Table In MS SQL Server

    Introduction In this article we will learn the trick to Move a Table from One Schema to Another Schema. Sometimes accidentally we might have given the incorrect name of a schema for the table while creating. But we can move the newly created table from one schema to another schema. Syntax Example Here Details is…

  • What is Blazor and How does it works

    Introduction In this article, we will discuss about the amazing technology called Blazor. Personally after working on this amazing technology, it increased my development works so much productive and interesting. In this article, we will cover the overall features of Blazor like as, What is Blazor Why should we use Blazor Getting started with Blazor…

  • 5 Tips to Improve SQL Query Performance

    Introduction In this article, I will share few SQL Tips for Boosting our SQL Query Performance. We nobody likes delay in response, right !!. Here are some simple changes that we have to make our query perform faster. The following is the flow of this write-up, Use Schema Name Always Select ONLY required Columns Use…

  • Identifying object dependencies in SQL Server using SP_DEPENDS

    Introduction When developing components for SQL Server one change may affect another database object.  Finding these dependent objects should be straightforward, but in most cases it is not as easy as we would think. There are several methods of getting this information, in this article we will have a look using SP_DEPENDS a System Stored Procedure.…

  • Select Names Starting With Vowels in MS SQL Server

    Introduction Sometime we may need to select the column results that the string starts with Vowels. In this article, We will have a look, How to select the columns results starting with Vowels. Example As an example, we have a StudentDetails table, first lets select all the results from the table. The above query’s result…

  • Display Line Numbers in a SQL Server Management Studio Query Window (SSMS)

    Introduction Sometimes when we encounter an error message for a T-SQL query while debugging. The SQL Server shows the error message along with the line number where the error has occurred. In this article, I will give a simple tip to enable the Line Number feature in SSMS. This feature is applicable to all versions…

Subscribe

Enter your email below to receive updates.