PASS Virtual Chapter Events : December 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-12-04
409 reads
Blog Posts
PowerShell- Monitoring Multiple Service on a Group of Servers
I got a request to monitor multiple services and send an email to intended recipients. This post explains how to...
2013-12-04
1,417 reads
Service Broker Sample – Asynchronous Triggers
Introduction
Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so...
2013-12-04
2,486 reads
Service Broker Sample: Asynchronous Triggers
Introduction
Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so...
2013-12-04
3,547 reads
SQL Server Data Mining: Time Series Algorithm Tips
The Time Series algorithm has several parameters that may be adjusted if needed. I have tried adjusting several of these parameter settings and determined that the following appear to...
2013-12-04
30 reads
SQL Server Data Mining: Time Series Algorithm Tips
The Time Series algorithm has several parameters that may be adjusted if needed. I have tried adjusting several of these...
2013-12-04
2,205 reads
SQL Server Data Mining: Time Series Algorithm Tips
The Time Series algorithm has several parameters that may be adjusted if needed. I have tried adjusting several of these parameter settings and determined that the following appear to...
2013-12-04
21 reads
SSRS – Self Referencing Reports or Drill through to same report
When looking at a report and wanting to drill through to get more detail, we often create two reports for...
2013-12-04 (first published: 2013-12-02)
3,000 reads
Year In Review: 2013
Ok, so it’s not quite the end of the year yet. I figured I would get a head start on...
2013-12-04
1,237 reads
Disk Space GUI Tool – Multiple Servers with GridView and Email Output
This tool helps you get the disk space information on the computers of your choice. Either you can type the...
2013-12-03
873 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