Viewing 15 posts - 1 through 15 (of 9,023 total)
just one note to add here, if you do restore the DMK from another server, and i recommend you don't, you will need to take extra steps in order for...
August 5, 2021 at 8:07 am
wow , been a short while since I touched ssrs, it seems they have withdrawn multi instance support in favour of virtualisation of ssrs nodes
May 6, 2021 at 11:09 pm
I didn't think you can install multiple instances on the same Windows host anymore, at least that's what I'm reading for SQL 2019.
where are you reading this, what...
May 6, 2021 at 10:59 pm
so it was, apologies, did not see that in the line of code.
Best to mention it anyway
May 6, 2021 at 6:41 pm
a mapped drive is user profile specific, one user mapping H: to a share wont be the same for other users logging on.
Use the UNC path and just ensure the...
May 6, 2021 at 6:39 pm
to be able to grant others permission you need to be assigned the GRANT WITH GRANT option, this defaults if you own the object
May 6, 2021 at 10:24 am
We have 4 SQL instances (2014, 2016, 2017, 2019) all using AOAG.
What's the score with SSRS connecting to these instances? I'm thinking for every SQL version we have,...
May 6, 2021 at 10:18 am
Never seen this behaviour before (maybe it has happened and I haven't been bitten yet!) I have some new DBs (SQL 2012) and these have been created by...
May 6, 2021 at 10:15 am
Check my stairway, already linked above.
Although written for 2012\2014 it's still relevant in most respects apart from later features like distributed AGs and cross domain\workgroup clusters.
May 6, 2021 at 10:08 am
but MAXDOP 1 hint would have solved that as well (or adjusting the cost threshold for parallelism) and was a "better" option.
These are always over looked in favour...
May 6, 2021 at 10:05 am
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