It is so simple to view a table in SSMS. As a senior developer in SQL Server, I have identified several approaches. In this article, I will walk you through each approach. Approach-1: Using Object Explorer in SSMS Follow the below steps. 1. Log in to the SQL Server Management Studio (SSMS) 2. Expand the … Read more
As an SQL developer, I must constantly duplicate the table structure without copying the data. This is where copying the table schema comes into the picture. Since this process is part of my daily activity, I have identified a few approaches to copying the table schema in SQL Server. In this article, I will walk … Read more
Recently, my client required that I enable versioning for one of the critical tables in my SQL server database. I tried running the SQL query below to enable versioning but encountered this error. In this article, I will walk you through the complete steps to fix this issue. I tried running the above query, but … Read more
My team recently received a requirement to change the schema of a table in the SQL server database. We have identified a few quick approaches to this task. In this article, I will walk you through each approach individually. Approach-1 Using ALTER SCHEMA Statement The primary approach is to use the ALTER SCHEMA Statement to … Read more
As an SQL developer, I was required to create a new schema for the SQL server. I have identified a few simple approaches to this. In this article, I will walk you through each approach individually. Approach 1: Using the CREATE SCHEMA Statement This is the basic approach to do this task. Syntax Example We … Read more
Since I used to get the requirement to determine the size of our data, it is crucial to know the row count in an SQL server table. As a senior developer in SQL, I have identified a few simple approaches to do this. In this article, I will walk you through all those approaches individually. … Read more
Recently, I was required to change the column position in my SQL server table. As a senior SQL developer, I have analyzed all the possible approaches. In this article, I will discuss each approach. Approach-1: Using the SSMS design approach Follow the below steps. 1. Open SQL Server Management Studio [SSMS]. 2. Right-click on the … Read more
As an SQL developer, I often received requirements for specific tables in my SQL server database. Since I belong to a large organization with massive data, locating a particular table is pretty challenging. So, I have identified a few approaches to do this job efficiently. In this article, I will discuss all the strategies for … Read more
I used to receive frequent requests to clear data from my database, so I deleted all records from tables using multiple approaches. I will walk you through all the approaches to do this. Note: Before deleting the record from the table, properly back up it for the safer side. Approach-1: Using the DELETE Statement Check … Read more
Recently, we were required to set up a QA environment where we had to create all the tables as they were in the dev environment. So, as a developer on an SQL server, I analyzed the complete requirement and concluded that we should duplicate all the tables from the dev environment to the QA environment. … Read more