Table definitions (as CREATE TABLE statements) and sample data (as INSERT statements) please

Are you seeing any errors in the error log?

Does the job succeed or fail? If fail, with what messages?

Thread continues http://www.sqlservercentral.com/Forums/Topic1777329-3411-1.aspx

The one that returns the correct results.

IN, along with EXISTS are used when you want to see whether there's a matching row/matching values in the subquery....

SQL doesn't use the page file. Windows may swap SQL's memory out to the page file is the OS is under memory pressure, but SQL doesn't use it directly.

What counter/monitor...

Why write your own index maintenance script when there are so many good ones out there?

https://ola.hallengren.com/

In short. Incorrect...

Then take any such occurrence and replace the ,...

Jeff Moden (4/12/2016)

---

John Mitchell-245523 (4/12/2016)

---

It's the old-style join syntax. These two are equivalent:

...

FROM TableA, TableB

...

FROM TableA CROSS JOIN TableB

... as are these two:

...

FROM TableA, TableB

WHERE TableA.ID = TableB.ID

...

FROM TableA...

ttdeveloper (4/12/2016)

---

A simple incredibly complicated fix with a lot of side effects and additional impacts of allowing RI across DBs still allows SQL to do its job and also provides...

J Good (4/12/2016)

---

How about something like this:

SELECT TOP 1 @@servername AS Servername

,[min server memory (MB)] = (select value from sys.configurations where name = 'min server memory (MB)')

,[max server memory (MB)]...

Start by throwing the cursor away. Triggers should be written in a set-based manor to handle any number of rows in inserted/deleted, not iterate through them. Cursors should be avoided...

Shouldn't be the case. Compat mode is an instruction to the query processor as to how to treat some T-SQL constructs. It doesn't change the format of the data file,...

I'm really not fond of OS upgrades, plus the hardware's probably ancient and in need of replacing.

Besides:

https://technet.microsoft.com/en-us/library/dd979563%28v=ws.10%29.aspx

Could you be a little more specific as to the scenario and problem?