Automated Permissions Auditing With Powershell and T-SQL: Part 6
Everybody still with me? Have you tried the script from Part 5? Did you notice how SLOW the Active Directory...
2013-11-20
780 reads
Blog Posts
Backups and Consistency
I wrote about transactional consistency recently. Why do we need this?
Imagine that I have an orders table and an ordersdetail...
2013-11-20
1,043 reads
Indexing Fundamentals
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,687 reads
Select * from * : Quick Tips
What? You want to see all of your data? Well do I have the script for you! New, Improved, Extra...
2013-11-20
461 reads
Speaker Idol Competition at the Hammond .NET User Group
Here's the link to download the sample scripts and meme-tastic slidedeck from my presentation "SQL Server Indexes in Your Ill-Begotten...
2013-11-20
534 reads
Testing network throughput with iperf
Have you ever wondered if that black box in your datacenter called the network is performing as well as it...
2013-11-20 (first published: 2013-11-11)
2,193 reads
Triangle SQL Server User Group Wrapup
Tonight I had the pleasure of presenting remotely to the Triangle SQL Server Users Group. I presented my session entitled “Squeezing...
2013-11-20
629 reads
Which C-level executive will be the big data champion? | ITworld
In your environment, who do you see being the Big Data champion? it probably depends on the goals of what...
2013-11-20
299 reads
Colorado SQL Events : November 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-11-19
344 reads
Colorado SQL Events : November 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-11-19
581 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