have you set your max server memory to a low threshold, so it ends up clearing the procedure cache?

in my experience, most performance problems come from coding that works, but performs poorly on large data sets.

as a result, i look at the code, here are some of the...

• This reply was modified 5 years, 1 month ago by  Lowell. Reason: added FOR XML hint

ok the forum converts to varchar as  well! so my  nvarchar string characters got converted to question marks!

your query did not appear, but i suspect it has to do with implicit conversions.

you have to use the N'' denotation to make sure SQL knows it is nvarchar data.

here...

are you using a sliding partition strategy for archiving?

don't look at the file groups. file groups is how it is stored, and potentially archived. that is independent from the logical...

when the job fails.

if you change it to when the job completes, you gent both success and failure emails.

a simple basic example of cross applying a datamath function to get your 36 values based on one date.your example did not go by date, it seemed, though; are you...

Roland are you creating the SPN's manually?

typically, the service account running the SQL service creates the SPN on restart of the SQL service.

That means it needs the Trusted for Delegation...

Incorrect syntax near '@CheckSum' to me implies a missing comma before, or an equals sign after;

as others had posted, if we see the whole command you executed, it might be...

right , the procedures are only part of the settings you need to use.

you need to use both WHERE [arr].Groups LIKE @GroupSearchTerm AND [arr].Users LIKE @UserSearchTerm" in the proc, not...

you wnat your SSRS report to have two text boxes or dropdowns for the  parameters, and to call a procedure.

the procedure then might look something like this, so if they...

not to that level of granularity, but there is a way to code around that.

take a look at this post from a while back where i posted a complete solution...

i hope i am not reading this wrong, but it looks like what you want to do is instead of using SELECT *, to select explicit column names.

good job on...

then in that case, why don't you simply put all of the servers in Central Management Servers, and execute then via SSMS all together?

stick with the tools you know, isntead...

with powershell, here is how i would do it.

Assuming instances_list.txt is a single column list with no header.

also assuming the script has USE [somedb] or fully qualified names so it...