Are Stored Procedures Faster Than Stand-Alone Queries?
Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...
2019-10-15
8 reads
Are Stored Procedures Faster Than Stand-Alone Queries?
Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...
2019-10-15
15 reads
Updated Data Profiling in Power BI Desktop
In this month’s (October 2019) release of Power BI Desktop, they have added a ton of cool stuff, you can read all about it via the Power BI Blog. ...
2019-10-22 (first published: 2019-10-15)
421 reads
Power BI Monthly Digest – October 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI
2019-10-22 (first published: 2019-10-14)
413 reads
MSDTC Best Practices with an Availability Group
In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these […]
The post MSDTC Best...
2019-10-14
15 reads
MSDTC Best Practices with an Availability Group
In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these recommendations change if you...
2019-10-14
21 reads
MSDTC Best Practices with an Availability Group
In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these recommendations change if you...
2019-10-23 (first published: 2019-10-14)
502 reads
Database Fundamentals #24: Filtering Data
If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause because of your use of it when manipulating data with DELETE and UPDATE statements. It’s...
2019-10-21 (first published: 2019-10-14)
617 reads
#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.
I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading
2019-10-14
95 reads
Launching SQL Compare with Context
Years ago Redgate Software started some work to link our tools together. I remember early efforts, about which I had dubious thoughts as to the value. I hadn’t looked...
2019-10-21 (first published: 2019-10-14)
268 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