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 …
Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Steve : Now, one of the things that when we talk about drive failures and that there is a big difference between corruption and complete drive failure. And here’s an example. It was another medical group. We do a lot of work with medical groups. They called …
SQL Server Corruption: Corruption vs Drive Failure Read more »
Our Database Health Monitor Training is about to launch! It’s today at 1:30pm PST via Zoom! Can’t Make It? Register anyways and we’ll email you a recording.
SQL Server is a powerful and complex database management system that is used by millions of organizations worldwide to store, manage, and analyze their critical data. While SQL Server is a robust platform, it is not immune to issues that can cause problems in its operation. Therefore, it is essential to take preventative measures to keep a SQL Server healthy. …
Steps to help keep your SQL Server running smoothly. Read more »