If you specify different paths with MOVE, it will ignore the existing paths & use the paths specified.

It sounds like you will need to generate dynamic SQL for the restores...

Is buffer pool extension enabled?

SQL Server Standard edition allows a maximum buffer pool extension size of four times the value of max server memory.

Why create or use the empty database to start with? Why not just define the new database name in the restore, avoiding any risks of database being in use by...

You said grouped index... Does that mean clustered index? Are there other indexes?

What is the compatibilbity level?

How does the execution plan compare between the two?

Can you share w/ https://www.brentozar.com/pastetheplan/?

You could preface every script w/

SELECT @@SERVERNAME, DB_NAME()

to force you to verify the environment before running anything.

If there a few server/databases you most use, you could create...

Why are you still planning to run SQL Server from a laptop instead of an actual server or at least a regular (desktop) PC?

Did you install SQL Server Express Advanced or LocalDB package (rather than "regular" Express)? They appear to be the only ones that actually install LocalDB.

On command line, what does

' A' is not equal to 'A' -- leading space in the in example):

SELECT * FROM #Results
WHERE 1=1 AND [Column1] in ('A') AND [Column2] = 'B'

What discrepancy?

Both queries should return nothing (if AnotherColumn is in SomeView), since AnotherColumn can't equal both 'XYZ' and '1'.

Is the leading space intended in 'XYZ'?

Negated/clarified by example

• This reply was modified 1 years, 6 months ago by ratbak.

The change in database focus only occurs within the scope of the dynamic sql session. Your "outer" session is still using whatever database you were using prior to executing sp_executesql.

You could use a parameter to let user choose server, & programmatically derive the connection string & dataset. See links below

Or -- not recommended -- you could embed all 100...

They are probably right. There is probably no value in that column (not to mention the ambiguous "ID" name) unless you are using an ORM or other tool/framework that insists...

What do you mean by "Update routine"? A stored procedure? A script? Or ORM or other C# code

If SQL code add something like

SELECT @@ROWCOUNT AS UpdatedCount

directly after...

• This reply was modified 1 years, 8 months ago by ratbak.

Just exclude first_name & last_name from the constraint -- per your new requirement, they are no longer part of the definition of unique.  e.g.,

CREATE UNIQUE INDEX ix_unique_email
ON...

4 versions of this post -- reply to https://www.sqlservercentral.com/forums/topic/between-datetime-statement-not-working-4 which seems to be the one being updated.