Bijay Kumar Sahoo
Recently, I tried force a value into the identity column, SQL Server stoped me with the error Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF. Cannot insert explicit value for identity column in table I was executing the following query. SQL After executing the query above, I got … Read more
In this tutorial, I am going to walk you through exactly how to handle these changes with the precision of a seasoned DBA. Whether you are looking to modify a column’s data type using ALTER TABLE or move a table to a completely different security schema using ALTER SCHEMA, I will cover every angle. SQL … Read more
Statistics are the single most critical component of query performance. They are the “map” that the SQL Server Query Optimizer uses to navigate your data. If the map is wrong, the engine gets lost, and your application performance tanks. In this guide, I will walk you through exactly how to update statistics on a table … Read more
As a Database Architect who has spent years optimizing high-concurrency environments, I have seen one feature consistently change the game: SQL Server In-Memory OLTP. But here is the catch: In-Memory tables are not a magic switch you flip to make everything faster. They require a fundamental shift in how you think about data persistence, locking, … Read more
In this guide, I am going to walk you through the most effective methods to copy tables between databases. I will cover everything from the quick-and-dirty T-SQL commands to the robust GUI tools provided by Microsoft. By the end of this article, you will know exactly which method fits your specific scenario. SQL Server Copy … Read more
In this comprehensive guide, I will walk you through exactly how to “describe” a table in SQL Server. Since T-SQL (Transact-SQL) handles this differently than other SQL dialects, I will show you the standard methods, the “insider” shortcuts, and the advanced querying techniques that will give you total command over your database schema. Describe Table … Read more
One question kept popping up in meetings and interviews: SQL or NoSQL – which database technology should I focus on? Over the years, having worked with both database types extensively across various industries from finance in to healthcare —I’ve come to appreciate the unique strengths and ideal use cases of each. In this comprehensive guide, … Read more
Understanding the difference between these two SQL clauses isn’t just academic—it’s essential for writing correct, efficient queries. I’m sharing everything I’ve learned about HAVING vs WHERE. Whether you’re a beginner learning SQL or an experienced developer looking to sharpen your skills, this comprehensive guide will clarify these often-confused clauses once and for all. SQL HAVING … Read more
The distinction between SQL and MySQL is fundamental to understanding how modern databases work, yet it’s one of the most commonly misunderstood topics in software development. Let me walk you through everything you need to know. SQL vs MySQL Understanding the Core Difference Here’s the simplest way I explain it to newcomers: SQL is a … Read more
As a database professional working with SQL Server for over a decade, I’ve seen countless scenarios where table-valued functions (TVFs) have transformed complex queries into elegant, reusable solutions. Today, I’m going to share everything I’ve learned about this powerful feature that every SQL Server developer should master. SQL Server Table Valued Function What Are Table-Valued … Read more