Viewing 15 posts - 1,456 through 1,470 (of 22,215 total)
Literally nothing to go on.
Where are you running backup commands from?
Look there to see what the connection settings are, etc. If necessary, fire up an Extended Events session and watch...
January 27, 2021 at 12:24 pm
Nope.
A restoring database is in the process of moving all the data pages and then recovering any transactions. They just can't be accessed. At all.
To solve this, I'd look outside...
January 26, 2021 at 12:59 pm
Same answer as on 2012. The CU, cumulative update, is what it says, cumulative. Any other patches are individual.
January 22, 2021 at 11:55 am
The security updates are not cumulative, so yeah, you'd need to install them separately. BTW, according to this site, there are three, not two for 2012 SP4.
January 22, 2021 at 11:54 am
Hard to say without details.
It depends.
It could be that you simply have queries running against the table that are filtering on columns where a non-clustered index could help. But, it...
January 21, 2021 at 6:17 pm
Just remember, the first column is the column used to create the histogram in statistics. The histogram is one of the leading drivers for the optimizer to make determinations on...
January 21, 2021 at 1:33 pm
The only way you can tell this is if you have a monitoring system set up. Either one you build yourself using Perfmon counters, or a 3rd party tool. There's...
January 13, 2021 at 1:56 pm
Personally, I'd got the third party route. It's going to be a lot easier. However, yeah, there are tools. First, get PerfMon. Capture the appropriate counters there. You can program...
January 13, 2021 at 1:52 pm
It's completely dependent on the indexes. I know Minion lets you pick lists of indexes & break up the process. I suppose Ola's script must too. Do that. Do the...
January 13, 2021 at 1:47 pm
There's a lot to unpack here, but I'll try to answer some of it.
First question, can you identify which tables have been changed between two dates? Yes. The key to...
January 13, 2021 at 1:45 pm
It's a parallelism deadlock. So, whichever query was involved, it was the only query involved. If you can't see the query from Profiler, you're stuck. Profiler doesn't have a correlation...
January 12, 2021 at 3:02 pm
January 12, 2021 at 2:04 pm
I appreciate all the feedback. No arguments from me on any of it. This all really is a balancing act. Getting it to "just right" is hard.
January 11, 2021 at 2:23 pm
Each restart, yes, but also failovers, detach/attach, all sorts of variation on that data. It is the one place to try to determine if indexes are in use, but, it's...
January 11, 2021 at 12:46 pm
The best way to get detailed information about the behavior of SQL Server is through the use of Extended Events. They are not zero cost, but they are the...
January 11, 2021 at 12:43 pm
Viewing 15 posts - 1,456 through 1,470 (of 22,215 total)