When creating the Alert - at the top of the dialog box is a button to Script the changes.  Before creating the alert click this button and it will script...

If you are looking for results from the insert - you could use the OUTPUT clause on the INSERT/UPDATE statement itself instead of using a trigger.

You could use sys.dm_io_virtual_file_stats and capture the data every couple of seconds to a table. Then you can query that table for the IO stats specific to the database...

The information does exist in the default trace - the schema change history report will show you the information you are looking for...to get the code open Profiler and have...

donald.mcneill (1/6/2017)

---

Yes - the job has gone from 4 - 10 hours (there are number of update queries called via a stored procedure). Queries that normally completed in a short...

If the query works with a variable - then why would you be concerned about using the literal value? What is happening here is that SQL Server uses the...

Jeff Moden (12/30/2016)

---

BOR15K (12/30/2016)

---

Thank you Jeff,

But I think we have drifted way beyond my original question of where to place WITH (NOLOCK).

With regards to your concern it might always select...

Mystic1287 (12/29/2016)

---

Thanks Jason/Sue...I know it has something to do with the logical file name. I don't have this issue with SQL 2012 and I kinda bit off more than I...

You need to fix this issue:

CONVERT(datetime,PackageActivityDateTime, 120) < CONVERT(datetime,@PackageActivityDateTime, 120)

The column should already be a datetime data type so it should not need to be converted. And why...

Snargables (12/28/2016)

---

98 db's in full recovery. all 98 have full backup every sunday night. 17 of these databases have their trans logs being backud up every 3 hours. All 98...

Snargables (12/28/2016)

---

so let me get this straight. I'm running into this same issue. We have about 90 db's in sql server 2014 enterprise avail group. The drive our transaction logs...

In your version - you have '' as the default value which is not a valid date. An empty string as a date is implicitly converted to a 0...

How did you determine that only 11GB of space is in use? I have seen this kind of issue with one or more tables where LOB data use to...