Viewing 15 posts - 10,381 through 10,395 (of 49,566 total)
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...
January 16, 2014 at 7:40 am
On shared storage unless you make some unsupported hack (which I am not going to explain).
January 16, 2014 at 7:37 am
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...
January 16, 2014 at 7:36 am
Database files must be on shared storage when you have a clustered SQL Server.
January 16, 2014 at 6:59 am
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...
January 16, 2014 at 6:43 am
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...
January 16, 2014 at 5:32 am
spin (1/16/2014)
after insert, delete, update i need
1) to calculate a...
January 16, 2014 at 5:22 am
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...
January 16, 2014 at 5:21 am
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)...
January 16, 2014 at 4:25 am
If you can post the trigger code, we can probably get it to behave properly.
January 16, 2014 at 3:29 am
Abu Dina (1/16/2014)
No. It knows exactly which ones to delete.
Does it?
Yes. Any row for which the EXISTS predicate evaluates to TRUE.
Now, if you don't use a join, that'll be...
January 16, 2014 at 3:03 am
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...
January 16, 2014 at 2:28 am
Abu Dina (1/15/2014)
Then your delete is using the EXISTS operator which is fair enough but the inner query returns multiple rows...
January 16, 2014 at 2:09 am
Based on created date of what?
January 16, 2014 at 12:36 am
Because for example, for ONE RECORD for RPC:Completed event there may be 3 records for SP:StmtCompleted event, right?
Yes, so the question is, why are you tracing both if that problem...
January 16, 2014 at 12:33 am
Viewing 15 posts - 10,381 through 10,395 (of 49,566 total)