Simone Bizzotto
Simone Bizzotto
ah right, it's the other way around. But then .... is Get-DbaDbTable not working with the unescaped table ?
ok, now I get it. I think it should be doable give we already abstracted away the parsing on Get-ObjectNameParts .
I suffered this problem in get-dbadatabaseState and already tried a workaround: worked well. Was thinking to add the same to get-dbadatabase as well because more and more commands are impacted...
the approach would benefit ALL commands running get-dbadatabase, for starters, both for tests and every other usecase. IMHO it'll solve a big part of the issues, then we can find...
let's start small with an example back in dbatools, then go from there ? fortunately what I though about is "incremental" and not disruptive.
That being said, get-dbadatabase is going to have a speedup when "preselecting" databases, but if downlevel you need the full SMO for each and every database .... it's going to...
see https://github.com/sqlcollaborative/dbatools/pull/3303
not to push this down but maybe wait a day or two for that PR to be in. Get-DbaDatabase showed "exponential" resource usage for instances with a lot of databases...
ahum, the only bit I can remember is that previous ola's jobs launched sqlcmd within the step rather than the stored proc itself .... the parser here reads the "sqlcmd"...
just for test's sake: try running it with a cmdexec step and ` sqlcmd -E -S .... -d ..... -Q "EXECUTE [dbo].[IndexOptimize] ...." -b ` if then the logs are...