*= or

=*

Have been depricated since SQL 2005? long time ago ....

They were part of MS dialect of T-SQL, not compliant with Standard, so they had to go

Only when the 'QUOTED_IDENTIFIER' is set as 'ON', can this query run successfully, otherwise, it will fail

According to the txt you posted, mytext with myid =3 meets the predicate of the WHERE clause.

Log back is sequential operations eg one statement at the time.....

Whereas Diff backup is at data page level, so the later is faster than the former for the same...

I agree, tail log back is the very first step to take right after the DB crashing, but ONLY IF the log file was still intact.... ie the disk for...

Theoretically you can use all the log backs after the full backup. But use Diff backup is far more efficient than using a series of log backups.

After all, that's...

In a DB connection string, you can use an ALIEN name for an instance. DNS can resolve it in the domain.... ie the actual server name can be different, sa...

Can you add an alien name as 'NASales' to the existing

instance 'USSales' to achieve the same thing??

ie users will see instance as 'Sales0\USSales', but it points to the original...

Nice digging deep into the root cause & thanks for sharing useful info.

Useroptions DB settings tend to be overlooked some times when optimising code....

sp_helpdb

Restore filelistonly

Restore/backup database

Set statistics io/time on

sp_whoisactive

A columnstore index can be for disk-based tables as well, not just for in-memory table ONLY.

According to your option list, the 'Modify File' is in Query 3, not 2. So the correct answer is 3.