Tampa IT Camp 2011 Presentation
I presented a one hour session at Tampa IT Camp on SQL Server PowerShell Extensions (SQLPSX): “In this session we...
2011-03-20
558 reads
Einladung zum SQL Server Performance Tuning und Troubleshooting Workshop, 24. Mai 2011 in Wien
Sind Sie schon mal in das folgende Problem-Szenario gelaufen, und mussten Ihren wohlverdienten
Feierabend und die Vorfreude auf das Wochenende opfern:...
2011-03-20
812 reads
PASS Prof Dev Blog
In case you hadn't noticed, PASS has a number of virtual chapters. Many of the virtual chapters broadcast LiveMeetings about once...
2011-03-20
1,126 reads
SQL Saturday 70 SSRS Deep Dive Files Uploaded
SQL Saturday #70 (Twitter: #SQLSat70) was another successful event! And...I had yet another full house (some even left due to...
2011-03-19
431 reads
Primary Keys – why accept the defaults.
G’day,
When I design a table in SQL SERVER, I like to have a reasonable understanding of how the table will...
2011-03-19
1,760 reads
Filmed: DBAs@Midnight Episode 2.30
Friday night (as per usual) we filmed a new episode of our 2 1/2 year old webshow, DBAs@Midnight in front...
2011-03-19
852 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple of things that i hadn’t even considered. In thinking...
2011-03-18
5 reads
Database Tools Follow-up
After posting a database tools list yesterday, I found that there were things that I had forgotten and a couple...
2011-03-18
603 reads
Are You Taking Advantage of Twitter for SQL Server?
One thing I always do lately, whenever I give a presentation is ask the audience how many of them use...
2011-03-18
888 reads
Teaching Two Classes at University College–University of Denver
I will be teaching two classes for the Spring 2011 Quarter at University College – University of Denver. One will be...
2011-03-18
502 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