Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started...
2018-08-14
376 reads
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started...
2018-08-14
376 reads
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-08-13 (first published: 2018-07-30)
1,501 reads
This crossword is based on terms you might come across in an article about Dynamic SQL.
2018-08-08
623 reads
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS....
2018-08-08
289 reads
The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse,...
2018-08-06
415 reads
I have a presentation I do every now again on security basics that I’m actually quite proud of. One of...
2018-08-02 (first published: 2018-07-12)
1,966 reads
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.
Why database mail?...
2018-08-01
334 reads
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the...
2018-07-31 (first published: 2018-07-18)
2,988 reads
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-07-25
239 reads
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
172 reads
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
Comments posted to this topic are about the item What is the PRODUCT
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
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