Viewing 15 posts - 721 through 735 (of 49,571 total)
September 29, 2017 at 2:47 pm
kevaburg - Friday, September 29, 2017 8:24 AMand seeing as locks aren't imposed or escalated during a SELECT.
Err.... What?
Nolock is bad practice...
September 29, 2017 at 8:36 am
A row cannot be stored across multiple pages (LOB data types notwithstanding). When you add a column, the data has to be added to each row.
Given that, what...
September 29, 2017 at 6:37 am
September 29, 2017 at 6:27 am
September 28, 2017 at 11:33 pm
How are you checking memory? Where do you see that SQL's only using 2.4GB of memory?
What's your max server memory setting?
September 28, 2017 at 11:18 pm
tony28 - Thursday, September 28, 2017 10:26 PMSo also with two jobs is possible that diff will wait for full backup ?
September 28, 2017 at 11:16 pm
I'm not sure either, there are some funnies with in-memory and execution plans.
Let me consult an expert.
September 28, 2017 at 3:31 pm
89netanel - Thursday, September 28, 2017 6:00 AMI don'r have many experience with partitioning.
and also the instance Edition is Standard 🙁
Partitioning is...
September 28, 2017 at 12:05 pm
September 28, 2017 at 7:35 am
Have you considered table partitioning?
September 28, 2017 at 5:53 am
Have you looked at the execution plan?
September 28, 2017 at 1:41 am
The differential backup will be blocked by the full, and hence will only execute after the full backup has completed, and hence it'll be obvious which diff you'd use to...
September 27, 2017 at 2:21 am
DML triggers on the relevant tables in msdb would be my first guess. Jobs are stored as data in MSDB.
September 26, 2017 at 4:38 pm
September 26, 2017 at 3:09 pm
Viewing 15 posts - 721 through 735 (of 49,571 total)