For a question titled "Why is RDBMS Type not a required field on this exchange?" I find this comment interesting: "It's interesting that you interpreted "hand holding" as Forcing a platform to be selected..."

Uh, because that's what the title suggested

Why is this answer an upvote ? dba.stackexchange.com/a/110844/8783 May be the OP is using 2 accounts - possible ?

@Kin deleted answer, suggested user merge their accounts.

@AaronBertrand thanks a lot ..

Using SQL Server I need to run identical selects across servers and databases which share same data structure, I do have server names and catalog names as string data columns; what's the smart way in general to do things like that? Dynamic SQL? Cursors?

@AaronBertrand same user is posting questions twice dba.stackexchange.com/q/110849/8783

and dba.stackexchange.com/q/110839/8783

@Phrancis you should post that as a question on the DBA.SE site

@Phrancis SQL Server Management Studio has a feature called "Server Groups" where you can run a query against multiple instances.

but there are quite a few ways to do that, including dynamically creating linked servers, etc.

@Phrancis You probably can't avoid dynamic SQL anyway if you don't want to repeat your code.

Although if a tool like SQLCMD or PowerShell is an option, the parametrisation of server names and database names could be done outside Transact-SQL.

OK let me gather my thoughts. SQLCMD is defnitely an option. PowerShell could be as well, though I'd prefer to keep things inside SSMS, if possible :)

I'll post on the DBA.SE site after a while, probably tomorrow

Dynamically creating linked servers sounds like it could be fun too, a bit above my head for now. I have a feeling I might start hanging around here more often

@Phrancis it's not all that difficult once you get your head around dynamic SQL in general.

I've done a small amount of dynamic, mostly at the column/table level though

My initial thought was to create a table var with the server and catalog names each in a column, create a loop or cursor of some kind iterating over each pair, then go through the data processing from there, which will be the same in each case, using dynamic; sound reasonable?

Of course if I could avoid loops and do it set-based would be even better, but I really don't know how I would do that lol

@MikeFal yo. you around?

@Phrancis central management server?

@swasheck 'sup?

Oh, something to add servers automatically to CMS?

@MikeFal i'm still trying to wrap my head around powershell and perfmon

and forgot my question

how frequently do you pull counters?

Not that frequently.

and that's your scientific answer

@MikeFal and do you go with rawvalue or cookedvalue ... do you dump directly to sql table?

do you just pull one reading or do you pull multiple samples?

Cooked value. I don't dump to a SQL table, I gather into a custom PS Object that could be written to a table.

@swasheck github.com/MikeFal/PowerShell/blob/master/SQLBenchmarker/…

@Phrancis I have some code written as a demo of how to run code using dynamically linked servers. If you post the question, I'll add it as an answer.

OK

TTQW for now; getting errors and a headache :)

@Phrancis ahhh the wonders of dynamic SQL. If you think you have a headache now, wait till you start doing dynamic SQL inside dynamic SQL. Have a good night!

I'm a seeing a bunch of "There have been 256 misaligned log IOs which required falling back to synchronous IO" errors. I know what's causing them, but does anyone know if this is going to make the whole log writer thread block while I/Os complete?

It might be a reasonable question for the site or a topic for a blog post I guess.

@MikeFal thanks

@JamesLupolt sounds like a good question to me.