Bulk Transfers: Some guidelines
Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out...
2013-12-14
550 reads
Blog Posts
How to work around Azure database migration limitations
Microsoft Windows Azure SQL Database, commonly known as SQL Azure, is a relational database in the cloud that is part...
2013-12-14
623 reads
Possible ways to secure SSIS Packages
SQL Server Integration Services (SSIS) security is based around several layers that provide a rich and flexible security environment. These...
2013-12-14
719 reads
SQL Server Encryption Options
Many database servers store confidential data, which must be protected from unauthorized access when it’s transmitted across the network and...
2013-12-14
683 reads
T-SQL Tuesday #49: Wait For It Roundup
A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of...
2013-12-14
1,666 reads
Understanding SQL Server Query Optimization – Part 2
An execution plan is the sequence of operations SQL Server query optimizer performs to run the statements. The SQL Server...
2013-12-14
1,272 reads
Understanding SQL Server Query Optimization – Part 3
A critical part of database design and management is index design. Index design involves balancing space requirements and the resource...
2013-12-14
504 reads
Understanding Triggers
A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger...
2013-12-14
701 reads
Android Annoyances
I wrote last week that I had switched back from Android to iOS, but I didn’t list out specific gripes...
2013-12-13
893 reads
Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49
A couple of weeks ago I gave you some scripts to collect wait stats from your SQL Server instance over...
2013-12-13 (first published: 2013-12-10)
2,344 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
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
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