Power BI first impressions
I have been using Power BI the past few weeks (see my video of all the features) after I was invited...
2013-11-12
1,370 reads
Blog Posts
Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !
I got motivated to write this post as there was a question on twitter which was like -
The user was...
2013-11-12
1,262 reads
The Cloud Is Scary – #TSQL2sDay #49
It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...
2013-11-12
643 reads
T-SQL Tuesday – Cloud Atlas – #TSQL2sDay
This month, Jorge Segarra (Blog | @SQLChicken) is running T-SQL Tuesday on the cloud. T-SQL Tuesday is a monthly blogging event where a number...
2013-11-12
791 reads
T-SQL Tuesday #48 – Cloud Atlas
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will...
2013-11-12
546 reads
T-SQL Tuesday #48–Cloud Atlas
I never saw the movie, though it’s on my list to watch sometime. I love the Wachowski’s as directors.
This month...
2013-11-12
980 reads
T-SQL Tuesday: Head in the Clouds
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work in IT there’s approximately zero chance that you’ve managed...
2013-11-12
17 reads
T-SQL Tuesday: Head in the Clouds
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work in IT there’s approximately zero chance that you’ve managed...
2013-11-12
10 reads
T-SQL Tuesday: Head in the Clouds
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work...
2013-11-12
937 reads
A better way to find missing indexes
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a...
2013-11-11
980 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