OVER clause: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-2017

If you mean something like this, you can't do this:

declare @i int = 2;
select sum(a) over (partition by b
      ...

I see this, but without any data as well. The platform peridocally saves things itself, but nothing went through with the post. Not sure what's wrong here. Can you type...

Does this happen even if the browser is not maximized?

So it's official. I've been accepted to Grace Hopper 2019 in Orlando to talk about "Imposter Syndrome: Are You Ready To Mentor". WHEEE... Now I have to overcome my...

You can grant rights to the public server role here for access to the database, but be careful here. You might be better using SQL Server auditing instead.

You can also...

This doesn't make sense in how you've written it. Please be more descriptive and format the code so it can be understood. It looks like you intend the commit/rollback to...

These have been found and migrated.

Been a mystery for me as well. It's the big reason why Redgate built SQL Source Control. Not sure if they'll ever change.

Just saw that. Going to be a busy day. Hard choices to make

I love the touchsceen. XPS was on my list, but I think at the time the Spectre was a better deal. I'm not sure I need to 2-in-1 thing. After...

That's likely a default. Having your database as a different collation than the server instance is not a problem. You may have issues if you use temp tables, in which...

This isn't an actual situation, but a contrived one. I have had similar situations, but in this case, the statement is intended to shape the question so you can answer...

So far it's supported. Who knows if that will survive RTM, though I suspect it will. MS wants to get people to upgrade and this is an important feature.

No worries. I'm getting used to scares

I don't get out of the house much, let alone out of the country, but this caught my eye since I'm tentatively planning a wee visit to Scotland: This...