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
Recently, I was working on a requirement that required me to retrieve data from the Order table in my SQL server database. After executing the Select query, I got the error Incorrect syntax near the keyword. I was executing the SQL query below. After executing the above query, I got this error, as shown in … Read more
Last month, my client required me to export table data into a CSV file in an SQL Server. In this article, I will walk you through all the methods. Method-1: Using SQL Server Management Studio (SSMS) Follow the below steps. 1. Right-click on the database name your table belongs to, choose Tasks, and then select … Read more
Recently, we had a very critical issue; as an SQL developer, it was pretty challenging for me to fix that issue. After analyzing the problem, I learned we must remove all the constraints related to that issue from the table. So, I have identified a few approaches to do this. In this article, we will … Read more
As a DBA working with SQL Server, managing the user permissions for a specific object is crucial for security. In this article, I will discuss various approaches to checking user permissions on a table in an SQL server. Approach-1: Using the fn_my_permissions We can use fn_my_permissions as a simple approach for this task. The query … Read more
As a database admin, I find the table with the column name daily to fix the issues. Since it is one of my daily tasks, I have identified a few quick methods to perform this. In this article, let us discuss all these methods one by one. How to find table by column name in … Read more
As a developer on one of my projects, checking whether the CDC is enabled on a table in the SQL server was a daily task. I have identified a few simple approaches to do this. In this article, I will take you through all these approaches. Approach-1: Using sys.tables You can easily use the sys.tables … Read more