Viewing 15 posts - 196 through 210 (of 9,208 total)
how are you determining the frag level, are you using the index physical stats DMV?
May 6, 2021 at 9:31 am
I'm guessing your account has the necessary share and ntfs permissions on the remote fileshare, thats why it works through VS.
Setting up an agent proxy would be the best idea...
May 6, 2021 at 9:29 am
the status of 2 for each row returned indicates that VLF is in use, (you get 1 row for each VLF in the log file) that's why you cannot shrink...
May 6, 2021 at 9:12 am
Which version of sql server are you using as there are now a set of DMV’s that expose this info, a lot easier!
September 5, 2020 at 7:49 am
under windows 2016 CIFS shares have changed quite a bit, you now need to setup a new file server role and then provision a redundant fileshare from there.
May 29, 2020 at 8:26 am
You’re missing the point, likely no one will be installing sql 2008 so the post here is irrelevant.
the latest installer clearly picks but then offers the choice to pick an...
May 13, 2020 at 8:12 am
The installer has changed drastically since 2008 so the post here, could be argued, is now irrelevant
May 12, 2020 at 8:32 am
As I said this thread is 10 years old
most people, whether ignorant or lazy, seem to rely on the installer choosing the correct collation.
it is important to set the regional...
May 12, 2020 at 8:14 am
This thread is 10 years old
May 12, 2020 at 5:29 am
Thanks for the notes. I've never seen the certificate protected by password in TDE, just the DMK. I assume doing so would ensure that the whenever the instance started...
August 29, 2019 at 4:16 pm
It’s a good article but needs the following pointers
In the hierarchy section you stated that the DMK protects the certificate stored in the master database, this is not completely correct.The...
August 29, 2019 at 7:59 am
What is the windows OS version and edition you are using for these cluster nodes?
July 26, 2019 at 1:00 am
look after your stats is probably the best effort
June 27, 2019 at 11:59 am
I would say it's likely easier to deploy a new system in AWS and then migrate the database(s) to the new system, is this not an option for you?
June 27, 2019 at 11:55 am
What is it you are attempting to do exactly
June 27, 2019 at 5:41 am
Viewing 15 posts - 196 through 210 (of 9,208 total)