That is odd that it is only system databases that are causing the slowness.  My first thought would be to get an estimated execution plan on the system databases and...

This query is close.  The only thing it isn't doing QUITE right is the ordering for the Quarters:

USE [Admin];
GO
CREATE TABLE [#temp]
(
[country]  VARCHAR(20)
, [ship]   VARCHAR(20)
,...

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.

Pretty sure that is baked into SSRS.  If you want to change it, you'd need to build a custom report wrapper page.

Source:

https://stackoverflow.com/questions/13922932/how-to-set-ssrs-parameter-panel-on-the-top

Phil got you most of the way there and your attempts were close.

In the first one, your REPLACE call is missing the values that should be replaced.  If you count...

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.

Your watch has more features than mine.  And mine does have some limitations (screen brightness isn't that bright so it is hard to read on sunny days, is a black...

I read that your watch lasts 4-5 days.  That's crazy.  My smartwatch gets me a month on average.

I think part of the problem is if battery life improves, device manufacturers...

SELECT name, SUSER_SNAME(owner_sid)
FROM [sys].databases

That query should do it.   Is that what you were looking for?

So, to fix your JSON, you need [ ] around the whole thing as it is an array.

Something like this:

SET @SampleJSON = '[
{
    "name":...

My approach is I want the document to be idiot proof and to cover the exact steps to recover from a disaster.

If I get woke up at 2:00 AM, I...

I have never used the tool azcopy.exe before, but as a thought, does your SQL Server Agent account have permission to the Azure site and have access to the files...

My advice is to not do an in-place upgrade.  The benefits of an in-place upgrade are that you don't need to change any connection strings in your applications and it...

Thanks Jeffrey!  You are right.  My query is not going to work due to the comparison on Column1.  My query would have only returned rows that had Column3 = MAX(Column3)...

I think this may be by design.  A normal user generally shouldn't need to run any sys stored procedures as those are more aimed at a DBA.

If you REALLY need...

Ken, get well soon!

You need to get to HAL9000!  Only 8996 more HAL's to go.

My opinion - those are 2 distinct problems.  First being searching of Word documents and the second being searching user text stored in MySQL DB.  If the word document is...