I was not expecting Godwin to apply here...

Thanks for running the tests Gail. I ran the iTVF version too for 1m rows & the times are identical to the NULLIF...

SSDT used to be just the SQL connection & deployment tooling - source control, dacpacs and the like.

Now they've integrated the BI tooling for AS/IS/RS (used to be called SSDT-BI)...

Isn't localDB pretty integral to how SSDT works?

Luis Cazares (9/8/2016)

---

Creating a scalar UDF to handle division by zero is a bad idea. It will only slow down queries.

What's the problem with using NULLIF?

SELECT numerator / NULLIF( denominator,...

As others have said, CTE's are just for easy formatting, they're all run together at execution. What you're effectively running is this...

select *

from (select x,y,z

from Main_Table

inner join...

Ah, well good luck!

Ah well, there may be someone along soon with a better answer, even from the Redgate side - there's plenty of Redgate people around here!

Full snapshots that frequently are definitely...

Is this any help? It's for SQL 2012.

https://social.msdn.microsoft.com/Forums/en-US/098fb5b0-d3ad-4008-b7c5-8d810b89f4f7/sql-server-2012-frequent-system-health-monitor-thread-operating-system-error-exception-0x1?forum=sqldatabaseengine

Error log entries on the screenshot:

System Health Monitor Thread: Operating system error Exception 0x1 encountered.

Error: 17053. Severity 16, State:1

External dump process return...

Sure it's not the transaction log that's 200GB?

sp_cycle_log doesn't delete the old file until it goes over the max number of log files (default is 6) so the 200GB file...

Ok, then no, I don't think there's a way to stop them being logged in msdb. Don't envy you having to deal with it!

Try trace flag 3226 https://msdn.microsoft.com/en-us/library/ms188396.aspx

Although I'm not sure if it works for third party backups.

Don't think you can stop entries going into msdb tables, but they can be purged with...

WHERE a.SQL2 like 'Select%PlanCode%From%'

AND CHARINDEX ('FROM', a.SQL2) > CHARINDEX ('PlanCode', a.SQL2)

Gary Varga (2/12/2013)

---

One of the key parts of this is automation. Automate what you can to make it repeatable. This reduces the possibilities of human error which is something we...

No problem, and good luck!

matthewful3 (9/6/2016)

---

First is the new data automatically written to the new ndf file or how does it determine where to write the data.

Does it matter that one particular table is...