First Presentation Ever And My 50th Post
Last Monday was the first time I've ever presented anything. Honestly, it was the first time really speaking in public...
2014-02-17
661 reads
Blog Posts
Get performance statistics for queries and query plans that are cached by SQL Server for faster query execution
You can use the following two DMVs to give you that information:
sys.dm_exec_cached_plans – You can use this dynamic management view to...
2014-02-17
1,051 reads
Home Workspace: Standing Desk
Ever since I worked in an office with adjustable standing desks, I’ve been thinking about getting a standing desk for...
2014-02-17
487 reads
Interest In SQL Server Seems To Be Declining?
Amusing myself for a minute at Google Trends. Anyone missing 2005?
2014-02-17 (first published: 2014-02-12)
3,555 reads
Make Your Storage Administrator Your Best Friend
That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin. For the...
2014-02-17 (first published: 2014-02-12)
1,634 reads
Presenting at the kickoff Lynchburg Va SQL User Group meeting
There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014...
2014-02-17
727 reads
The CHOOSE keyword
G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...
2014-02-17
1,551 reads
The RedMonk Programming Language Rankings: January 2014 #programming
The RedMonk Programming Language Rankings: January 2014
As long as we have been doing our programming language rankings here at RedMonk,...
2014-02-17
898 reads
Transact-SQL query to obtain basic information about partitioned tables
Here is the simple query that returns basic information about all tables in a database that are partitioned:
SELECT SCHEMA_NAME([schema_id]) AS...
2014-02-17
1,559 reads
What Is a Throwout Bearing?
A throwout bearing is a part of an automotive clutch system that temporarily disengages the engine from the manual transmission while shifting....
2014-02-17
445 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