Viewing 15 posts - 946 through 960 (of 49,571 total)
Only the session that created a temp table can drop it, or look at it in any way.
They're probably cached temp tables, not ones in use. SQL caches...
August 11, 2017 at 1:11 am
coolchaitu - Thursday, August 10, 2017 10:42 PMIs this the reason why we cannot take log backups in simple recovery mode
Yes.
August 11, 2017 at 1:10 am
Checkpoint marks VLFs that are not needed for anything (replication, transactions, full backups, etc) as reusable.
August 11, 2017 at 1:09 am
It's not an instance-level setting. It's a session-level setting.
The user options is, afaik, a default for clients that don't specify the setting, and SSMS does specify it.
August 11, 2017 at 1:08 am
Neither.
When a query needs a statistic (for optimisation), the row modification count is checked. If it exceeds the threshold, then that statistic (and only that statistic) is updated.
August 10, 2017 at 4:45 pm
August 10, 2017 at 8:09 am
August 10, 2017 at 7:51 am
Does the database have read_committed_snapshot or allow_snapshot_isolation enabled on it?
August 10, 2017 at 7:49 am
August 10, 2017 at 7:09 am
Right thanks yes. I'll ensure they only have the db_reader etc. Thanks for...
August 10, 2017 at 6:32 am
2 bytes for the row header, 2 bytes for the slot array index, 2 bytes for the null bitmap offset, then one bit per column (minimum 1 byte) for the...
August 10, 2017 at 6:13 am
August 10, 2017 at 5:48 am
August 10, 2017 at 5:46 am
Possible, yes. In violation of licensing terms, yes.
That's a production environment (since it's the replica of your production environment) and hence it violates the Developer edition license terms...
August 10, 2017 at 5:42 am
Viewing 15 posts - 946 through 960 (of 49,571 total)