Enabling High Performance Power Plan via PowerShell
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,965 reads
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,965 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-13
463 reads
Let's keep this talk going about what you can do. We know I'm rather big on user groups and SQL...
2013-12-13
447 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-12-13
486 reads
What sort of testing lab do you setup when you're testing things out? I hear see the world adventureworks almost...
2013-12-13 (first published: 2013-12-03)
1,265 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-12-12 (first published: 2013-12-03)
2,352 reads
As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback,...
2013-12-12
1,794 reads
“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have...
2013-12-12 (first published: 2013-12-03)
3,475 reads
Well, we talked about user groups... Let's talk about their big brother; SQL Saturdays. @SQLCenturion runs them here in OKC. They...
2013-12-12
472 reads
Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe...
2013-12-12
778 reads
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers