Search results for: cursor

By Posted on Posted in Performance No Comments

Introduction: In my years of working with SQL Server, I’ve encountered a variety of common mistakes that can impact performance and database health. In this blog post, I’ll share these pitfalls and provide tips on how to avoid them. Remember, understanding these mistakes is the first step in enhancing your SQL Server’s Performance. Ignoring Database NormalizationNormalization is crucial for reducing …

Common SQL Server Mistakes and How To Avoid Them Read more »

By Posted on Posted in Uncategorized No Comments

Are you ready to deepen your understanding of SQL Join Types? Join us for an exclusive, live webcast that promises to elevate your SQL skills. This is your chance to be one of just 20 attendees at this special event. Webcast Overview: Start with the basics of the SELECT statement—the cornerstone of SQL querying—and swiftly move to a comprehensive exploration …

Exclusive Invitation: Master SQL Join Types with a Free Webcast Read more »

By Posted on Posted in Performance No Comments

Common Uses of TempDB in SQL Server TempDB in SQL Server is a globally available temporary storage area used by the SQL Server Database Engine for various purposes. Here’s a list of the most common uses of TempDB: User Objects: Includes user-defined temporary tables and temporary stored procedures. Used to temporarily hold data for processing within a session. Internal Objects: …

What uses TempDB? Read more »

By Posted on Posted in SQL Server No Comments Tagged with ,

Error 701, “There is insufficient system memory to run this query,” is a common error message in SQL Server. This error indicates that the system does not have enough memory available to execute the query. There are several reasons why this error may occur, including: To address this error, you can try several different strategies, depending on the specific cause …

Error 701 There is insufficient system memory to run this query Read more »

By Posted on Posted in Database Health No Comments Tagged with ,

This month brings treats for new Database Health Monitor users and old! Make sure you check back to see what’s released! This month we will announce a Sale on our Database Health Monitor Course When purchased it allow you to connect to 20 servers! New tips on how to use Database Health Monitor Hot key tips to make your job …

Database Health Month! Read more »

By Posted on Posted in Database Health No Comments Tagged with ,

We hope you enjoyed last month’s Common Table Expressions theme and all the video tips and blog posts we released. July we will be focusing on Database Health Monitor and we will be releasing some SAVINGS as well as some TIPS AND TRICKS! So make sure to follow us on social media, sign up for our newsletter or check back …

What’s Coming in July? Read more »

By Posted on Posted in SQL Server No Comments Tagged with ,

Every DBA, owner or CEO etc. have worries regarding their SQL Server. We face challenges everyday with constant evolving business and technology needs. We at Stedman Solutions are interested and concerned about your worries in regards to SQL Server work. What is your biggest SQL Server worry today? Tell us so that we can focus our attention on the issues …

SQL Server Worries Survey Read more »

By Posted on Posted in TSQL No Comments Tagged with ,

This is part 11 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better performance. You …

TSQL Basics Part 11: CROSS APPLY – Video Explanation Read more »

By Posted on Posted in TSQL 6 Comments

Occasionally you need to take inventory of how much free space each database has. You can find this quickly and easily in Database Health Monitor, but if you want to get it programmatically you can do it with the following query. This query has been tested on SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, and 2019. This …

Query to Find Free Space on All Databases Read more »