You mean 'database properties'? (there is no options tab, nor any encryption option on the server setting)

Enabling TDE encrypts the database and backups so they cannot be restored or attached...

On shared storage unless you make some unsupported hack (which I am not going to explain).

You're passing NULL as the first parameter so the query is checking all indexes on all tables in all databases on the instance. Look at the database ID that the...

Database files must be on shared storage when you have a clustered SQL Server.

First things first. Is that a problem? Is that query a problem?

If not, why are you worrying about it? The % cost has to be somewhere, it is a...

Restore the last full backup

Restore the 1pm differential

Restore all the log backups since that diff.

Whether or not you can recover that 55 minutes since the last log backup depends...

spin (1/16/2014)

---

a media event is created which has accountId, stockId, startDate, endDate. (it also has some other details about the event).

after insert, delete, update i need

1) to calculate a...

Restore the last full backup (see books online - the SQL help file - for the RESTORE syntax)

Restore the 1pm differential

Restore all the log backups since that diff. You didn't...

This is what's causing the errors

where MediaId = (select MediaId from inserted))

When you delete multiple rows, there are multiple rows in inserted (it's not a for each row trigger)...

If you can post the trigger code, we can probably get it to behave properly.

Yes. Any row for which the EXISTS predicate evaluates to TRUE.

Now, if you don't use a join, that'll be...

Count of all tables meaning what? Number of tables where something to do with created date parameter? Number of rows in those tables with something to do with created date...

Abu Dina (1/15/2014)

---

Your first query is returning two columns: a.AccountId, b.StockId

Then your delete is using the EXISTS operator which is fair enough but the inner query returns multiple rows...

Based on created date of what?

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Yes, so the question is, why are you tracing both if that problem...