One of the most important operations in SQL Server is joining tables. Joining tables involves combining data from two or more tables based on a common column or set of columns. To help SQL Server users better understand the different join types and their uses, Steve Stedman has created a free SQL Server Joins poster. The SQL Server Joins poster …
SQL Server’s DBCC IND command is an undocumented database console command that is used to display the allocation and deallocation status of the data pages in a table or index. This command is not officially supported by Microsoft and is not intended for general use. To use the DBCC IND command, you must first connect to your SQL Server instance …
As a database administrator, ensuring the integrity of your SQL database is of utmost importance. Any corruption or damage to the database can result in data loss or application downtime, which can have severe consequences for your business. One of the tools you can use to maintain database integrity is the DBCC Checkdb command. In this article, we will discuss …
Maintaining Database Integrity with DBCC Checkdb Command Read more »
As someone who has worked with SQL Server for many years, I know how important it is to understand the different types of joins. Inner join, left outer join, and right outer join are the most commonly used joins in SQL Server. Understanding the differences between these join types is essential for creating efficient and accurate queries. Inner join is …
Hey there, fellow SQL enthusiasts! I’m Steve Stedman, and I’m excited to share my latest SQL Server course on the TSQL Output Clause. If you’re like me and passionate about mastering SQL Server, then you’re in for a treat! This course is designed to help you unlock the power of the TSQL Output Clause to streamline your database operations. Check …
SQL School: Master the TSQL Output Clause with My SQL Server Course Read more »
CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR on SQL Server allows you to create stored procedures, triggers, and functions using languages such as C# and VB.NET. While CLR can be a useful feature, it can also be a security risk if not …
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
A couple days ago I was working with a client, they called me they needed desperate help about a query that was running really slow in their system. It was an insert, inserting into a good sized table but not millions of rows by any means. We started looking at it and thinking, so why is your insert statements slow? …
Running backups on a SQL Server Fri, 31 Mar 2023 Running backups on a SQL Server is crucial for several reasons: Disaster Recovery: SQL backups are essential for disaster recovery. If your SQL Server fails, becomes corrupted, or suffers from a data loss incident, having a backup allows you t Read more… SQL Server Corruption: Corruption vs Drive Failure Thu, …
Running backups on a SQL Server is crucial for several reasons: Disaster Recovery: SQL backups are essential for disaster recovery. If your SQL Server fails, becomes corrupted, or suffers from a data loss incident, having a backup allows you to restore the database to a previous state. Without a backup, you may lose critical data and suffer from extended periods …