The Heap™ – Consultancy ©®

« first day (2700 days earlier) ← previous day next day → last day (2172 days later) »

12:22 AM

Learning and growing is the most important thing you can do. That's why I'm here, mostly. I like helping people, but I really like having access to world-class talent.

Thanks, @PaulW for the details in that conversation. Subtle but important, so thanks!

11 hours later…

ypercubeᵀᴹ

11:35 AM

You'd better not use the old-style (old means more than 20 years) joins. The ANSI syntax is more readable and less error-prone. — dezso Jul 27 '16 at 13:14

@dezso pedantic note: both syntaxes are ANSI ;)

-4

Q: r/SQLServer•Posted byu/erraticmigrant 6 minutes ago Replication from on prem to Azure - receiving error "Invalid Object Name... Error Number 208"

So I have a replication going on from on prem MSSQL 2012 environment to an Azure Sql environment. Everything had been working just fine for few months since I first set it up. Recently the replication started to fail with this message: Invalid object name . (Source: MSSQL Server, Error number: 2...

This is in the Reopen queue ^^

It doesn't seem to have much useful info. What would they need to supply, in order to be answerable?

"Invalid object name" seems weird. Unless the versions are different (or have changed, I think some Azure installations upgrade the versions automatically) and some table/column name has become reserved?

4 hours later…

Tom V

3:26 PM

@ypercubeᵀᴹ probably because of the edit?

3 hours later…

ypercubeᵀᴹ

5:56 PM

@TomV right. I was asking here because I have no idea what the causes might be. And didn't seem worthy of reopening at the moment.

So in short I was doing a "reverse Paul" ;)

Request for comments

Tom V

6:26 PM

@ypercubeᵀᴹ I'm no expert on the subject but I don't think it's much clearer now

Evan Carroll

7:21 PM

I'm going to rewrite libc

Xymanek

Hello. I'm trying to install sql server express but i get an error: https://i.imgur.com/64NMR84.png
I've tried looking around and it seems to be related to visual studio - i updated it but that didn't help... Any help will be appreciated
System: Windows 10 x64 (afaik all updates are installed). Installed c++ packages: https://i.imgur.com/uuuBYD1.png

All c++ stuff is installed in visual studio: i.imgur.com/2pkcrI2.png

McNets

Hi @EvanCarroll, I'm sorry but I don't understand you comment. dba.stackexchange.com/questions/207976/…

Evan Carroll

7:46 PM

From my reading (and I could be wrong), he's not looking for the min() or max() id, he's looking for whatever that value happens to be when the result set is sorted by an arbitrary column, in this case created_at

Evan Carroll

7:59 PM

I think that question basically boils down to not wanting two SELECT statements on the same table, but I don't know of any database that allows you to run that in a nicer way

Though I could be wrong.

McNets

8:14 PM

@EvanCarroll yes, you're right. first I thought row should be ordered by id, it should by min/max(created_at)

2 hours later…

Evan Carroll

9:58 PM

Very bad answer dba.stackexchange.com/a/9709/2639

(vote to delete, or downvote)

dangerous shouldn't even be allowed here.