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
223 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,050 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
282 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
224 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,483 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
224 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,830 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
308 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,202 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
T-SQL Tuesday #193 - Notes to Self
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
Forums
What is the PRODUCT
Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers