That might be the reason I never noticed something like that, I tend to raid the Hotel Bar in the evenings and last time I stayed at Olive8 I was...

you can specify the WHERE Clause in both SELECT Statements to limit Date_Time like in a normal Statement e.g. WHERE Date_Time = ' '

if you want both directions...

Might be an issue with the SSMS Release in use, I hope someone will chime in with a link where you could submit such issue.

Well to check the DB Side if everything is OK, you have the Database Upgrade Advisor which gives you a rough estimate if SQL Server will eventually face problems with...

I had an issue once years ago with SSMS when checking many tables for compression savings, the only trick I had was restart SSMS in that case, maybe someone else...

You can do this with EXCEPT, you want to know all the values from the table you know has all the required data definitely which are not in the other...

So, no more "Help me CAST(CONVERT()) my Tinyint to Bigint?" :Whistling: Joking aside, I didn't have the time to attend SQLPass this year myself however I'm aswell surprised as...

If the DB was encrypted when the Backup was taken, the DB is at the point of Restore still encrypted.

In order for YOU to be able to do anything...

Try something like this what you're looking for most likely is the /Par Switch and have a look at this, too

The fundamentals are the reason why I still get new SQL Certifications.

Seriously, certifying for a new SQL Server Version means reading the book you've read oh so many...

If all SQL Servers use Domain Service accounts with proper Service Principal Names configured, you could query Active Directory. If you have a default port for SQL Server and know...

I would leave SQL Server for other type of data. Most likely I would end up with Flow Simulation on Ground Vehicles. If I never started with SQL Server I'd...

ah ok, so I wasn't completely off the right path, now to figure out how to evaluate a BOOL Expression or simply change the parameter. 😉 Thanks in advance

How do I make a variable dependent on a project parameter?