Locks, Blocks, and Deadlocks Oh My!
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this...
2014-02-12
11 reads
Blog Posts
MCSA in 90 days… & lot of resources
Another free resource for learning and gaining your knowledge that might be possible to earn MCSA Certifications with few efforts....
2014-02-12
1,463 reads
MDX+SSAS #38–CALL ASSP.DMV() to document cubes in SSAS 2005
While you are writing and testing MDX queries in Microsoft SQL Server management Studio (SSMS), how many times you find...
2014-02-12
1,422 reads
New Talent Onboarding at Drexel Building Supply: A Case Study #hr
Studies show a strong connection between three critical talent metrics — productivity, retention, and engagement — and how well a company addresses...
2014-02-12
409 reads
On Accountability
“Sometimes you’ll make a mistake,” a chief executive says. “Life happens. But let’s not do it again. One of our...
2014-02-12
373 reads
On Why Titles Don’t Matter
The chief executive of eClinicalWorks says he guards against “title warfare” at his company, saying that new job titles “get...
2014-02-12
271 reads
Powershell in a Month Day 16 – Working with many objects
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-02-12
1,154 reads
Research: Don’t Offshore Your R&D #outsourcingdoesntwork
Many of you knew this as common sense but a new paper suggests the costs outweigh the benefits.
from HBR.org http://ift.tt/1dUIwOD
2014-02-12
158 reads
Say “No” to Innovation-in-General #innovation
You need to get specific if you’re going to get anything done.
from HBR.org http://ift.tt/LYdfPk
via IFTTT
2014-02-12
250 reads
Scaling SQL Server 2014 Pre-Con in Copenhagen
I will be travelling to Copenhagen, Denmark to deliver a full day pre-con for SQLSaturday #275 on Friday, March 28,...
2014-02-12
937 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