Month: December 2022

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 Performance No Comments

Replication and Log Shipping Compared Fri, 30 Dec 2022 Replication and log shipping are two features of SQL Server that are used for managing data and ensuring that it is available in multiple locations. Both of these features can be useful for organizations that need to maintain multiple copie Read more… SQL Server HAVING clause on SELECT statements Thu, 29 …

December Blog Post Wrap-up Read more »

By Posted on Posted in Replication No Comments Tagged with ,

Replication and log shipping are two features of SQL Server that are used for managing data and ensuring that it is available in multiple locations. Both of these features can be useful for organizations that need to maintain multiple copies of their data in different locations, such as for disaster recovery or to support multiple locations. Replication….. is a process …

Replication and Log Shipping Compared Read more »

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

The SQL HAVING clause is used in conjunction with the GROUP BY clause to filter the results of a query based on the group by clause. The HAVING clause is used to filter the results of a GROUP BY clause, whereas the WHERE clause is used to filter the results of a query before the GROUP BY clause is applied. …

SQL Server HAVING clause on SELECT statements Read more »

By Posted on Posted in Backup No Comments Tagged with , ,

Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are two important concepts in disaster recovery planning. Recovery Point Objective (RPO)…… is the maximum amount of data that you are willing to lose in the event of a disaster. It is the point in time to which you want to be able to restore your data after a disaster. For …

SQL Server Recovery Point Objective vs. Recovery Time Objective Read more »

By Posted on Posted in Classes No Comments Tagged with ,

SQL Server windowing functions are a powerful and versatile set of tools that allow you to perform complex calculations and operations on a set of rows within a query. These functions operate on a set of rows, called a window, and can be used to perform a wide range of operations, including ranking, aggregation, and ranking. One of the key …

SQL Server Windowing Functions Read more »

By Posted on Posted in Backup, Recovery No Comments Tagged with ,

In SQL Server, log backups are copies of the transaction log that can be used to restore the database to a specific point in time. The transaction log contains a record of all the changes made to the database, such as INSERT, UPDATE, and DELETE operations. By performing a log backup, you can save this information so that you can …

SQL Server Log Backups Read more »

By Posted on Posted in Performance No Comments

Merry Christmas from the team at Stedman Solutions, LLC. Our offices will be closed to celebrate Christmas this year. If you need emergency help during this time, you can reach us through the contact us form, or for existing customers just contact one of us by our cell phone or text. Contact us form https://stedmansolutions.com/contact-us/ -Steve Stedman

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

Here is a sample Christmas-themed query for SQL Server: This query returns the greeting “Merry Christmas!” and the current date. It only selects user tables that have an even object ID and are accessed on December 25th, which is Christmas Day. Here is an example of the output of this query: greeting current_date Happy Holidays to all!

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

Merry Christmas! 2022-12-25 00:00:00.000 This output shows that the query is only returning user tables with an even object ID and the date is December 25th, and it is displaying the “Merry Christmas!” greeting and the current date. Here is another Christmas-themed query for SQL Server that retrieves a list of Christmas gifts from a table: This query uses the …

Merry Christmas! 2022-12-25 00:00:00.000 Read more »