TruDat!

To...

xp_cmdshell is easy to abuse so I use it sparingly.

I also find that any time I am looking to use xp_cmdshell, it is likely because I am trying to...

Just saw this one pop up, not sure if it is a "known" bug or not, but thought I'd report it as I didn't see it in this section.

If...

Thank you all for the help!  Phil's suggestion worked for me, I was trying to avoid it as there is no leading index on the date columns.

I as well...

I can't help with SSRS but I'm still trying to figure out why anyone would want to remove facts that matter from an aggregate.  This appears to be a "only...

As a bit of a sidebar, this is why people need to make sure they have normalized data in their tables instead of "convenient" data.  Table 2 needs to be...

Heh... lordy.  OK... Two more reasons why I'm glad I don't have to deal with Azure.  "Trapped Short Rows" can relatively large decreases in performance.  Now I see why you...

Well the flip side of that question is, if you're passing the information on to a system that wants to read JSON do you store the sqlified...

This site has had the problem of not posting the 1st post on subsequent pages until an additional post is made for...

Perhaps call the folks at Arctic Wolf and ask what they suggest?  Maybe their website has some amplifying information?

Gosh... there are a whole lot of reasons why such a thing may have happened.  The first thing I'd do it hit the "REFRESH" in the Object Explorer window and...

Actually, Just thinking out loud!  Wouldn't a user defined table type (UDT) work in this scenario

It would also eliminate needing the complexity of the JSON be parsed through and...

Ok... the OP is a "No show" on the bit of extra information that I asked.  Moving on.

Understand that I was speaking only from the SQL Server side... there is no...

Weekly or monthly partitions is probably the way to go.  There are a LOT of caveats to partitioning spread quite wide in the MS documentation.  Make sure you read and...