In my case, I had to right click the icon in the actual windows menu, then click on "More", and then click on "Open File Location" and that took me...

Please see the following article if you want to know more about CROSSTAB queries and how they work.

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

@olegserdia

Check the page density on the Clustered Index for your big table that you deleted images from.  Because you used the IMAGE datatype, they should have gone "out-of-row" but it's...

This is a recurring pain for many regardless of the version of SSMS!  After struggling with this inconvenience for too long and striking out in Google, I found a...

Please consider the possibility of SQL Injection, especially on @Table2.

It looks to me like you're forming a ton of accidental cross joins in the form of many-to-many joins because of the insufficient join criteria of partid = partid.

Heh... he's late.  The document says that it was due in October...

I think what concerns me most about the IoT is security.  They have lightbulbs and thermostats that connect to your wireless network.  They call to their home server and...

Thanks, Johan.  That sounds like one of the many reasons why I stopped working in the front-end world.  Having been one long ago, I appreciate what they actually have to...

Thanks for the explanation, Steve.  I appreciate it.

But, aren't notifications working "just fine now"?

If you've not had scale issues, then why all the business about limiting notations and shutting down notifications on old posts?

Perhaps you should read the article 

I know it was mentioned in the article but it needs to be stressed a bit.  One of the biggest reasons for massive log file sizes IS index maintenance and,...

Where?  I see no attachments anywhere on this thread,

Also the trigger is to add logs to another table. This is usually used when user change address from user interface web site, so it is usually one record...