Getting Fast Counts of Large Service Broker Queues
Getting Fast Counts of Large Service Broker Queues
This question regarding getting a fast count from a service broker queue came...
2011-01-18
2,184 reads
PowerShell Week at SQL University – Post 4
Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what...
2011-01-18
26 reads
PowerShell Week at SQL University – Post 4
Recap
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using...
2011-01-18
1,373 reads
New Cumulative Updates for SQL Server 2008 SP1 and SP2
Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of...
2011-01-18
705 reads
January OPASS Meeting
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn, 850 Village Oak Lane, Lake Mary. SQL Server...
2011-01-18
7 reads
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-18
6,143 reads
DBA 101: Why is my log file full?
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-18
2,674 reads
PASS SQLRally Professional Development Vote Done and the Development Track Vote is open
Congratulations to the winners in the Professional Development Track Vote for PASS SQLRally. You can see the winners at http://www.sqlpass.org/sqlrally/2011/Agenda/Sessions/SessionsProfessionalDevelopment.aspx.
Now the...
2011-01-18
783 reads
January OPASS Meeting
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn,...
2011-01-18
609 reads
SQL Saturday #62
I had the honor of traveling to Tampa Florida this past weekend and presenting a session to a great group...
2011-01-18
479 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
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