SQL Server 2008 Data Compression Example
I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.
First, I identified...
2008-10-31
4,295 reads
I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.
First, I identified...
2008-10-31
4,295 reads
Since the release of SQL Server 2008, a slew of new books have been released, or are about to be...
2008-10-30
1,732 reads
Microsoft's free SQL Server Health & History tool (SQLH2) has had a minor update and can now be used with SQL...
2008-10-21
2,273 reads
As I travel and visit DBAs from around the United States, I am always surprised at the job titles DBA...
2008-10-16
641 reads
Every week, there are dozen of free educational events to attend throughout the United States. The sad part is that...
2008-10-15
628 reads
A SQL Saturday event was held Saturday, October 11, 2008 in Olympia, WA. Sponsored by the Olympia Area SQL Server...
2008-10-11
564 reads
The annual Tulsa TechFest (Tulsa, OK) had over 500 attendees today (Thursday), and is expecting another 500+ attendees on Friday....
2008-10-09
444 reads
I am one of the biggest advocates there is of self-education. Whether you are a novice, intermediate, or expert-level DBA,...
2008-10-07
1,010 reads
If you have ever considered taking a leadership role in PASS, you should seriously consider becoming a SQL PASS board...
2008-10-07
417 reads
Just got back from attending IndyTechFest in Indianapolis, IN, which was held on Saturday, October 4, 2008, and had nearly...
2008-10-06
707 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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