We just had Software Assurance. Made things easier when dealing with a large(ish) enterprise, especially DR, etc.

Wayne's explanation is excellent.

Just remember, similar is not same. Just because a query has similar structures doesn't mean it has the same structures. Those differences really do matter.

Sounds like it might be hitting a timeout on the DataStage side of things. I don't know how to adjust that in DataStage. But the description is how a client-side...

I'd use Kristen's approach for showing data without NULL values. Just don't use the same thing in the WHERE, HAVING or ON clauses because you'll cause table scans since that's...

Shelley Allen (9/21/2015)

---

yes,

But if it's set to 'secondary'. How do I just exit? I don't want the job to run if the DB is marked 'secondary'

(Sorry. ...

Assuming it's a trigger, because that makes the most sense. It has to exist somewhere on the system. It's attempting to make calls to the missing database.

I'm with NJ-DBA. What is AHCAuditAllObjects?

That procedure seems to be giving you issues. I can't find it in a search, so it looks like it's something you've created locally.

For more on sqldiag, check out this information from Microsoft.

It's a monitoring tool. Like all monitoring tools, it will cause additional overhead on your system. I would only turn it...

Check out the function fn_hadr_backup_is_primary. That will tell you if your server is currently the primary. Then, you enable the jobs on all the servers, but it will only run...

Eirikur Eiriksson (9/21/2015)

---

Grant Fritchey (9/21/2015)

---

There are only 38k distinct values in a data set of 25 million. Add to that the fact that you're selecting a broad swath of those...

Without seeing the queries, it's just general advise. Make sure the objects are accessed in the same order. If you're doing reads then updates, possibly try using UPDLOCK on the...

And you can check the wait statistics yourself to see why the backups are taking time. Query sys.dm_os_wait_stats before and after the backup. See what the issue is there.

Please don't cross-post questions. It just leads to confused conversations. Please use this thread for further comments. It looks like you might be happy with one of the answers on...

There are only 38k distinct values in a data set of 25 million. Add to that the fact that you're selecting a broad swath of those values. Assuming an even...

Jack Corbett (9/18/2015)

---

Just got a deadlock alert from Idera DM and this is the query(anonymized):

'

SELECT

*

FROM

"database"."dbo"."table" WITH (UPDLOCK, REPEATABLEREAD)

WHERE

...