Real-time query access with PDW
The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and...
2014-03-13
1,553 reads
Blog Posts
Some Notes On Writing A Question Of The Day
I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest...
2014-03-13
472 reads
Speaking at Midlands PASS Chapter tonight
The Midlands PASS Chapter is an official PASS (Professional Association for SQL Server) chapter located in Columbia, SC. It’s free...
2014-03-13
462 reads
SSRS Top N and Bottom N reporting with Duplicates
Previously I wrote a blog on Top N and Bottom N reporting. There were a couple of gotcha I did...
2014-03-13 (first published: 2014-03-03)
2,970 reads
Tables without Clustered Indexes?
Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database...
2014-03-13
3,252 reads
Upcoming Webinar – Bringing Power BI Q&A to your Organization
Come join me for this webinar on 4/15/2014 at 11:00 AM EST
Bringing Power BI Q&A to your Organization
Q&A is an...
2014-03-13
761 reads
Upcoming Webinar – Creating Power Map Reporting Solutions
Come join me for this webinar on 4/17/2014 at 11:00 AM EST
Creating Power Map Reporting Solutions
Excel 2013 with Office 365...
2014-03-13
759 reads
Virtual Lab – The Domain
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-03-13
1,075 reads
Webinar Today at 3pm
I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...
2014-03-13
390 reads
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
322 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
Forums
Alamat Kantor BCA KCU Bekasi Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel.,...
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
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