SQL Server and the “Lock pages in memory” Right in Windows Server
Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL...
2011-02-14
1,724 reads
Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL...
2011-02-14
1,724 reads
Much like the USA Network here in the States welcomes characters, I’d like to formally let the world know that...
2011-02-14
578 reads
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog...
2011-02-14
612 reads
On Wednesday, February 16 at 2:00pm CST I’ll be presenting “.NET Powers Activate! Form of PowerShell!” to the PASS PowerShell...
2011-02-14
783 reads
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
650 reads
I work with a client that has an office about 25 yards from a train track and recently the railroad...
2011-02-14
609 reads
I see this question on the forums all the time and thought it was worth a repost here.
Just this week,...
2011-02-14
1,328 reads
Do you know about congenital heard defects (CHD)? Did you know that February 7-14 is the week dedicated to making...
2011-02-14
474 reads
PASSMN meeting is this week on Tuesday. Without further ado…
Meeting Details
Here are the details on the meeting location and time:
Date:February...
2011-02-14
531 reads
I got a chance to evaluate performance of both views and stored procedure for high level decision making.
As all of Us knows that purpose/scope...
2011-02-13
11,589 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...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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