Learn With Sundar

Get Started

  • Find All Tables Containing Column With Specified Column Name – MS SQL Server

    Introduction In this article, we will discuss how to get the list of table names that contain specific columns. Sometimes we may need to find the table names which contain similar column names or we may know the column name but, we may not remember the table name. By using a simple query we can…

  • Where are the SQL Jobs are Stored in SQL Server

    Introduction In this article, We will discuss where the SQL Jobs are stored in SQL Server. Most of us know the purpose of SQL Job, A job is a specified series of actions that SQL Server Agent performs. Use jobs to define an administrative task that can be run one or more times and monitored…

  • Getting Started With Golang

    Introduction Golang is a General Purpose programming language developed by Google engineers Robert Griesemer, Ken Thompson, and Rob Pike in the year 2007. Golang is also known as Go. Golang is open-source. Table of Contents Overview of Go Features of Golang Go Getting Started Conclusion Overview of Go Applications developed using Go works faster since…

  • How to Check SQL Server Database Size

    Introduction In this simple article, I would like to share how to check DB size. Sometimes when working in a Database, we may need to know the current space occupied by that particular DB. Based on the size, we need to take action. There are three easiest ways to check it, Using T-SQL Statement Using…

  • Find When was a SQL Server View Last Modified

    Introduction In this simple tips and tricks article, I would like to share how to when was a view last modified. Let’s have a look at the below T-SQL Statement In the above T-SQL Statement list, from the column LastModifiedDt column we can find when was the view last modified. Conclusion We will learn more…

  • Find Table Creation Date In SQL Server

    Introduction In this article, we will discuss how to get the created date of a table. Sometimes, we may need to know when the table was created in the particular database. Rather than relying on the row inserted date, we can see when the table was created. Finding the Created date using T-SQL This T-SQL…

Subscribe

Enter your email below to receive updates.