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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:24 am
Hi,
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2021 at 10:05 am
how are you determining the frag level, are you using the index physical stats DMV?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2020 at 8:26 am
Viewing 15 posts - 1 through 15 (of 9,023 total)