I haven't seen pressure to reach 0% downtime where I work, but we still struggle with some basic issues, so I'm not sure if things are more focused on those...

I wish I better understood dev-ops so I could participate in an intelligent discussion on this topic, but even though the company I work for likes to pretend it follows...

So this weekend I ended up trying to do a repair on the shared components of 2019, but that didn't seem to do it.  I ended up doing a repair...

Jonathan, I like your enthusiasm, but I'm thinking your query will return IDs that don't have any of the 3 key description values where as the OP sounds like they...

Maybe I'm a bit old-school, but I'm still a big fan of dimensional modelling based on the Kimball methodology.  I believe the Kimball group now operates as Decision Works, and...

I think you need to provide some more information about the data in this table.  Is there only 1 row per description per ID?  What is the primary key of...

Just...

another option is to use the great free tool SentryOne Plan Explorer:

https://www.sentryone.com/plan-explorer

It gives you a lot more information than the standard execution plan in Management Studio, including actual I/O,...

And one more thing:  Your dynamic query starts with UNION ALL...  and that's going to cause a syntax error.   Not sure why you have that in there, and maybe...

I think the original SQL has some redundant parts in it, I believe it can be simplified to:

SELECT DATEADD(DAY, -8, DATEADD(WK, DATEDIFF(WK, 0, GETDATE()), 0));

Looking at the...

This is great advice!  All too many times I've seen commit messages that are generic like "fix" or something else fairly useless.  The worst is if you work someplace where...

I think you misunderstood what Grant was telling you to do.  You can't create a VIEW inside of a PROCEDURE, just take your original query and put that in the...

I  have to admit many of the R or Python questions I get right are an educated guess, I don't really know anything about either of those languages.  This one...

ugh, I edited it and made it worse, so I went back to my original post, sorry for any confusion, but glad you found help from this.

• This reply was modified 4 years, 4 months ago by  Chris Harshman.

I think this would work best if you had a separate table already that had a list of asset_name and security_code values, but it looks like all you might need...

• This reply was modified 4 years, 4 months ago by  Chris Harshman.
• This reply was modified 4 years, 4 months ago by  Chris Harshman.