Blog Posts

Blog Post

PowerShell – Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell

Method 1: Environment Variable
PS:\>$ENV:PROCESSOR_ARCHITECTURE
Method 2: Using Win32_OperatingSystem
ps:\>$computername=’abcd’
ps:\>(Get-WmiObject Win32_OperatingSystem -computername $computername).OSArchitecture
Method 3: Using Win32_Processor
ps:\>$computername=’abcd’
ps:\>Get-WmiObject -Class Win32_Processor -ComputerName $ComputerName| Select-Object AddressWidth
Method 4:[IntPtr]::Size - Gets the...

2014-01-06

2,162 reads

Blog Post

MDX Root Function

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here. In the past, I have encountered scenarios where I...

2014-01-05

14 reads

Blog Post

MDX Root Function

This week I discovered an incredibly useful MDX function, the function is called Root.  Full documentation can be found here. In the past, I have encountered scenarios where I...

2014-01-05

43 reads

Blog Post

Day 11 – Purging syspolicy

This is the eleventh installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

2014-01-04

50 reads

Blogs

My Social Media Rules

By

I developed these rules a while back, before COVID. I had a period of...

Why Use TRY_PARSE(): #SQLNewBlogger

By

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

A Guatemalan's Guide to Drinking Coffee Properly

By

My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...

Read the latest Blogs

Forums

Partitioning a table with TEXTIMAGE_ON option

By Brandie Tarvin

I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...

OUTER APPLY Fundamentals: Part 2

By Imran2629

Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2

Building Great Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Great Software

Visit the forum

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          1
If I run this query, how many rows are returned? 
SELECT *
 from dbo.OrderHeader
 where customerid between 3 and '6'

See possible answers