There are quite a few different ways that you’re likely to see windows functions evidence themselves within your execution plan. Let’s take a look at one example. Windows Function...
2024-07-10 (first published: 2024-06-24)
252 reads
If you want more of a career and less of a job, one thing you will have to do is learn to use your voice. I mean this on...
2024-07-08
11 reads
I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They […]
2024-06-29
101 reads
There are quite a few different ways that you’re likely to see window functions evidence themselves within your execution plan. Let’s take a look at one example. Window Functions...
2024-06-24
24 reads
As I type this, we’re leaving behind spring, and all the amazing events that take place then, and entering the quiet time of summer. After that, we’ll go into...
2024-06-18
14 reads
Oh good gosh. Six months without a single blog post. Most important information: I’m not dead. Apologies. The issue is pretty simple. I’m getting old. Ha! Seriously though, I...
2024-06-17
20 reads
2024-06-10 (first published: 2020-01-23)
510 reads
I had the opportunity last week to present a session at DataSaturdays Stockholm. I can't say enough nice things about the event and the organizers. I presented on Query Store in SQL Server. In my mind, it's an entry-level to middle tier presentation. Most of the room was already working with Query Store, some quite […]
2024-06-01
109 reads
The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]
2024-05-04
111 reads
Today, Grant talks about reasons that companies don't upgrade.
2024-04-26 (first published: 2020-02-11)
448 reads
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
Comments posted to this topic are about the item The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers