Fundamentals of Storage Systems, Understanding Reliability and Performance of Solid State Storage
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
1,140 reads
Fundamentals of Storage Systems, Understanding Reliability and Performance
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
831 reads
Writing Opportunities
Are you looking for opportunities to show off your elite writing skills and consumate SQL Server knowledge? Want a chance...
2010-10-28
630 reads
Last Call for PASSMN Board of Directors
As I mentioned a couple weeks ago, we are looking for nominations for the 2011 PASSMN Board of Directors. PASSMN...
2010-10-28
498 reads
SQLSaturday#59 Speaker Interview #13 – with Mark Kromer
SQLSaturday #59 Speaker Interview #13 – with Mark Kromer
Today, coming in from Philadelphia, PA, we are talking with Mark Kromer, who...
2010-10-28
795 reads
SQL Rally: Performance Tuning Abstract
I get the call, you get the call, everyone gets the call. “Hey, my app/procedure/query/report is running slow.” Now what...
2010-10-28
714 reads
Vote for the Pre-Con’s You’d Pay to Attend
If you read this blog you probably already know about the PASS SQLRally and that we are doing things a little...
2010-10-28
380 reads
Bulk Insert Permissions
In order to be able to execute bulk operations you need to certain level of privilege both on the database...
2010-10-28
32,984 reads
Overwhelmed, Stress, and Planning
It’s been a bit hectic this year. In fact, it feels crazy most weeks as I try to manage work,...
2010-10-28
789 reads
When is that Restore Going to Finish?
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
854 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
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