Notes from MySQL Enterprise Lunch and Learn With Representatives from Sun & Oracle (MySQL 5.5 Now Downloadable)
Today we sat through a pizza ‘n pop lunch while listening to a MySQL Offering and Licensing for the company...
2010-10-27
2,048 reads
Bloggers-Don’t Blog About Spam!
Earlier this week I posted Bloggers, Quit Worrying About Spam, discussing what I felt was an over-focus on preventing spam...
2010-10-27
683 reads
A Little SSMS Wish
IN SQL Server 2000, we didn’t have the fancy-schmancy Management Studio…we had Enterprise Manager and Query Analyzer, and we liked em,...
2010-10-27
519 reads
Vote For The SQLRally Pre-Con Seminars
Do you know a real-life Pointy Haired Boss? Maybe you don’t work for him, but I bet you’ve met one.
In...
2010-10-27
599 reads
Virtual Presentation Tomorrow
I’ll be presenting a practice run at one of my PASS Summit presentations, Identifying Common Performance Problems using Execution Plans,...
2010-10-27
667 reads
SQLSaturday #59 - Speaker Interview Series # 12 with Ayad Shammout
SQLSaturday #59 - Speaker Interview Series # 12 - with Ayad Shammout
Today, we bring you the immaculate interview. If his sessions are as...
2010-10-27
858 reads
The SQL Rally - Who Would I Vote For?
I was looking over the pre-conference sessions submitted for the SQL Rally event taking place next May in Orlando. I...
2010-10-27
843 reads
Postponing SQL Lunch Presentation Until Next Week
I woke up this morning about 3 AM with clogged sinuses and a fever. Great. The changing weather patterns that...
2010-10-27
642 reads
Do You Have Other Opportunities Open?
Imagine you’re talking with a recruiter about a position that seems like a good fit and during that conversation they...
2010-10-27
601 reads
Common SQL Server Mistakes – Functions in the WHERE Clause
This continues my series on Common SQL Server mistakes, looking at more T-SQL mistakes.
What’s Wrong?
If you saw a query like...
2010-10-27
3,453 reads
Blogs
T-SQL Tuesday #201 - Temp Tables, Friend or Foe?
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Forums
ALAMAT BCA KCU TULUNGAGUNG Hub 082225313145
WA CS 082225313145 WWH2+WP2, Jl. Pangeran Diponegoro No.54, Tamanan, Kec. Tulungagung, Kabupaten Tulungagung, Jawa...
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
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