Download: Powershell a Day -April 2011
I you liked my Powershell a day – april 2011, where every day I wrote a blog about powershell you can...
2011-04-30
1,542 reads
Powershell Day 30
Day 30 Best Practice Having good Security is first best practice for any language no exception with Powershell. Having that...
2011-04-30
1,453 reads
Seize the Moment
Today I had a bit of regret slap me in the face. That face slap came from participation in a SQL Quiz on twitter that was hosted by Paul...
2011-04-29
5 reads
Seize the Moment
Today I had a bit of regret slap me in the face. That face slap came from participation in a...
2011-04-29
1,368 reads
SQL Saturday 74 Is Here! Register Now! Show Up Tomorrow!
Tomorrow (4/30/2011) is SQL Saturday #74 in Jacksonville Florida and once again, I am giving a talk with other well...
2011-04-29
1,483 reads
Physical Row Location
SQL Server 2008 has presented us a couple of options to aid in becoming better DBA’s. You can see this evidenced in many ways in the product. A couple...
2011-04-29
13 reads
Physical Row Location
SQL Server 2008 has presented us a couple of options to aid in becoming better DBA’s. You can see this...
2011-04-29
3,802 reads
Learn T-SQL in 5 Minutes
I will be giving a five minute Lightning Talk at SQLRally in May that aims to do the impossible: Teach...
2011-04-29
2,202 reads
Antivirus solutions that are free
So my sister called me the other day to tell me she has a message on her laptop that said...
2011-04-29
1,658 reads
Re-blog – April 22-28
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-29
1,463 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