You Need Two SLAs for Disaster Recovery
Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once...
2011-01-19
1,880 reads
New PASS Chapter in Orlando–MagicPASS
Kendal Van Dyke is launching a new PASS Chapter called MagicPASS in Orlando this week, with the first meeting on...
2011-01-19
684 reads
31 Days of SSIS – SQL Server Configuration (18/31)
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-19
2,220 reads
Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2
Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...
2011-01-18
2,641 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 voting is open for the Database &...
2011-01-18
12 reads
SQL Lunch - Build Your First PerformancePoint Dashboard with MVP Adam Jorgensen
SQL Lunch - Building a Performance Point Dashboard
Don't forget to attend the SQLLunch tomorrow.
#35-Building your first PerformancePoint Dashboard in SharePoint 2010
Speaker:...
2011-01-18
1,228 reads
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
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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