When job hunting, I'm point blank with potential employers or recruiters about what my current salary is. The way I see it, if either party can't match the...

Well, I would help but you haven't provided the DDL (CREATE TABLE) script(s) needed, nor the necessary INSERT statements to populate the table(s) with sample data.  If we had those...

Check the compatibility level of the databases where you are having an issue.  It may not be set to SQL Server 2016 or newer.

Is there a question here?  Making a guess, it is possible that the transaction log file has grown to 50GB based on activity.  One thing I would also look at...

Interesting.  I just did a direct copy/paste to my SQL Server 2017 instance and both worked with no error.

My question is why are you shrinking the transaction log?  If properly managed it should grow to a specific point then remain static.  I saw this while deployed and made...

Had a very pleasant surprise on Saturday!!!

I spoke in Providence on Saturday.  Among my audience were these two gentlemen, one of whom was Jeff Moden.  (Hi, Jeff! ...

You also could simply look up the functions in Microsofts online documentation.

Heh... just...

I hae had this same issue a few years ago and solved it.  Only problem I have is remembering the issue I had and how I solved it.  I will...

Heh... just one of...

• This reply was modified 6 years ago by Lynn Pettis.

Heh... just one of the many...

I am slightly confused.  Are you doing restores to the same point in time each time you do a restore?  Also, what are you attempting to achieve with these restores?

>> I have sadly run into the issue where I don't actually know the question to ask to get the answer I need or to be able to formulate...

>> I have a database with three tables linked [sic] together by 'DocumentNo'. Two main linked [sic] tables which output all rows with a full outer join. These...