Powershell Day 23
Day 23 SMO programming Part 4 AS we can work with Server, Database, Table, Column. You can get the similar...
2011-04-22
368 reads
What Don’t I Know?
Apparently a lot, at least according to the blooper reel today
Filed under: Blog Tagged: bloopers, Humor, syndicated
2011-04-22
748 reads
Re-Blog – April 15-21
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-04-22
575 reads
Powershell Day 22
Day 22 SMO programming Part 3 In earlier blog we have discussed about server and database classes, using table clase...
2011-04-22
517 reads
If a web page asks you to update Adobe Flash Player
You don't want to do so from that web page. Instead you want to go to the Adobe web site...
2011-04-22
1,132 reads
Another neat idea - The Mentoring Experiment
Another neat idea from the co-founders of SQLServerCentral.com, Steve Jones and Andy Warren, the mentoring experiment has been launched, and...
2011-04-22
1,813 reads
Why having two accounts is a good thing
Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...
2011-04-22
701 reads
A SQL Server Hardware Nugget A Day – Day 21
For Day 21 of this series, I will talk about processor cache size and its relationship to SQL Server performance.
Cache...
2011-04-21
913 reads
Thirty-Three Weeks…
Good day SQLServerCentral!
(Note: This does not have anything to do with SQL; it’s more of a (*gulp*) regular blog…)
Thirty-three weeks. ...
2011-04-21
621 reads
Powershell Day 21
Day 21 SMO programming Part 2 Continue with my earlier blog where I discussed about the information about SMO. Today...
2011-04-21
501 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
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
Building Great Software
Comments posted to this topic are about the item Building Great Software
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