2010 PASS Summit Recap
The 2010 PASS Summit has been over for a week and a half now and I've finally recovered & processed everything...
2010-11-23
687 reads
INDEX DEFRAGMENTATION SCRIPT
Advertisements
INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005
I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me...
2010-11-23
1,508 reads
Roundup: Un-SQL #001 – Branding
Hi-ho all, and a wonderful Un-SQL event it’s been! We had at least twenty-six entries!! First, the recap:
While T-SQL Tuesday...
2010-11-23
801 reads
Dynamic PowerShell
I learned something new while giving my PowerShell session at the PASS Community Summit a couple of weeks ago.
One astute...
2010-11-23
1,439 reads
Building A PowerShell Module Installer
As part of the 2.3 build of SQLPSX I built an MSI based installer to package all 10 SQLPSX modules....
2010-11-23
2,112 reads
SQL server basics for beginners
Advertisements
In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.
SQL–Structured Query...
2010-11-23
1,579 reads
A Couple Interesting Talks
At the PASS Summit a few weeks ago, the keynote talks and the WIT luncheon were streamed live to the...
2010-11-23
818 reads
Careful with the New MCM Requirements
Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification...
2010-11-23
681 reads
Giving Thanks
I came across a blog post today from Jason Strate (Blog | Twitter) about giving thanks. This topic has come about due to the holiday in the United States...
2010-11-23
11 reads
Giving Thanks
I came across a blog post today from Jason Strate (Blog | Twitter) about giving thanks. This topic has come about...
2010-11-23
869 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