Re-initialize replication not working
For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask...
2014-02-22
564 reads
Blog Posts
Sql Cluster Resource not comming online
when you check on the sql server services and sql agent services it’s getting started on windows cluster but on...
2014-02-22
683 reads
Working From Home
I have been working 100% from home for almost four months now, and one of my former coworkers recently hit...
2014-02-22
542 reads
1977 Toyota FJ40 Land Cruiser – #4wd #fj40
The Toyota FJ40 Land Cruiser has been out of production for 26 years, but you wouldn’t know it when talking...
2014-02-21
711 reads
1977 Toyota Land Cruiser FJ40 – #landcruiser
Tom Campbell is a wildlife cinematographer by trade and his incredible ’77 Toyota Land Cruiser FJ40 was built to assist...
2014-02-21
650 reads
Friday Followup For February 21, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-21
301 reads
Improving SQL Server Performance by using Instant File Initialization
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-21 (first published: 2014-02-18)
3,628 reads
Notes From The February 2014 oPASS Meeting
Live notes from the meeting.
Attendance is low tonight, about 10 people (though it was well advertised, I got quite a...
2014-02-21
700 reads
Reblog: February 14 to February 20
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-02-21
762 reads
Spreadsheet controls in #Office 2013
Now available are Audit and Control Management Server (ACM), and Discovery and Risk Assessment, which are both designed to help...
2014-02-21
597 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