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 …
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 …
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
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!
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 …
Here is a sample query using the MIN and MAX functions in T-SQL: This query selects the minimum and maximum values for the Price column from the Products table. The results of the query will be a single row containing the minimum and maximum values for the Price column. Here is how the query works: Want to learn more about …
It’s never a good idea to email passwords, whether it’s your own personal password or a password that you’re sharing with someone else. Here are a few reasons why: A better option for sharing passwords is to use a service like privnote.com. This service allows you to create a secure, encrypted note that you can share with others. The recipient …
Corruption in a SQL database is when the database becomes damaged or corrupted, making it unable to be used or accessed. This can happen for a number of reasons, such as hardware failure, software bugs, or even human error. When a database is corrupted, the data it contains may be lost or inaccessible, which can be a major problem for …
New Course – Preparing for Corruption in SQL Server Read more »
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS CXPACKET ASYNC_NETWORK_IO OLEDB SP_SERVER_DIAGNOSTICS_SLEEP XE_LIVE_TARGET_TVF LCK_M_SCH_S CXCONSUMER MEMORY_ALLOCATION_EXT LCK_M_S Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
SQL Server backups are an essential part of any database administrator’s job. In this blog post, we’ll discuss what SQL Server backups are, why they’re important, and how to create them. First, let’s define what a SQL Server backup is. In simple terms, it’s a copy of your database that you can use to restore your data in case of …