The Small Print
In today's guest editorial, Phil Factor issues a stark warning against cunning salesmen and hidden costs in cloud computing.
A Tool for the Job
Phil Factor is puzzled by reading how difficult a relatrional database is to use for certain tasks.
Has tempdb grown since the last restart?
Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.
Performance Tuning Re-indexing and Update Statistics – A Case Study
Recently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance.
Human Power
It's incredible what humans can accomplish when they work on a problem with passion. This editorial was originally published on Mar 20, 2008. It is being re-run as Steve is on vacation.
SSD Lifetimes
This week Steve Jones looks at the expected lifetimes of SSDs and finds one that might be a nice upgrade for your system.
Create SQL Server Analysis Services Partitions using AMO
When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.
SQL Saturday #179 - Kharkov, Ukraine
SQL Saturday in the Ukraine. If you want a free day of training, sign up and attend.
Day 7 of The OLAP Sprint
The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.
Generating SubTotals using GROUPING
This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.
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