SQL Saturday #63 PPT
The PowerPoint deck from my presentation is here if you want it
http://www.sqlservercentral.com/articles/Presentations/70959/
- Posted using BlogPress from my iPhone
Filed under: Blog...
2011-04-03
859 reads
Powershell Day 3
Day 3 Programming in Powershell Part 1 Now you got some good basic information about Powershell, and some basic commands...
2011-04-03
1,098 reads
View system object definitions
G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...
2011-04-03
633 reads
SQL Saturday #63 – Dallas: Resources
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
644 reads
A SQL Server Hardware Nugget A Day – Day 2
For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...
2011-04-02
546 reads
SQLSaturday #63, Great Event!
So,
I actually had a early morning sessions and gave my Solid State Storage talk and had a great time. The audience was...
2011-04-02
639 reads
Powershell day 2
Day 2 Introduction to Windows Powershell. Windows Powershell is a very powerful shell script to interact with windows. Using windows...
2011-04-02
1,472 reads
SSMS Tips & Tricks – Scripting Multiple Objects
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,366 reads
If you fire that trigger, make sure you have the correct ID
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
576 reads
A SQL Server Hardware Nugget A Day – Day 1
Well, I apparently did not learn my lesson last year, when I did a month long series called “A DMV...
2011-04-02
429 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