I’m in a book! Data Professionals at Work
A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for...
2018-10-24
226 reads
Kenneth Fisher
Generate a random number of children for each parent
I was asked an interesting question the other day.
Is it possible to get a different random number of rows...
2018-10-17 (first published: 2018-10-03)
2,054 reads
What is the Object Explorer Details tab good for?
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL...
2018-10-17
285 reads
Highlighting sp_spaceused
I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick...
2018-10-15
227 reads
Which is faster? IN (list) or IN (SELECT FROM Temp)
If you’ve done much with IN (list) then you’ve realized that it basically translates out to
col=val1 OR col=val2 OR...
2018-10-11
2,484 reads
Letting the business bully you: T-SQL Tuesday #107
Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in...
2018-10-09
225 reads
Data Types Word Search
Just for fun here is a word search with all of the data types available in SQL Server. Well, two...
2018-10-05 (first published: 2018-09-26)
1,831 reads
SQL Homework – October 2018 – Time for an upgrade
When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was...
2018-10-01
310 reads
You can’t DELETE TOP (x) with an ORDER BY
Did you know you can’t do this?
DELETE TOP (10)
FROM SalesOrderDetail
ORDER BY SalesOrderID DESC;Msg 156, Level 15, State 1, Line 8
Incorrect...
2018-09-27 (first published: 2018-09-19)
3,203 reads
Escaping strings
No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom.
Not...
2018-09-24
889 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers