Looking at those waits, the ones in hours are the ones I would be more concerned about!  If I am reading things right on that, the AVERAGE column is showing...

For that particular query (experts correct me if I am wrong), but I see 4 indexes being needed - 1 per table.  The query looks broken to me on that...

Any column in the SELECT result list that is NOT used in an aggregate (or windowing function) MUST be included in your GROUP BY UNLESS no aggregate operations are taking...

This forum, being called "SQL Server Central", is mostly focused around SQL Server.  The Powershell component of the forum is, for the most part, how to do stuff with SQL...

• This reply was modified 4 years, 1 month ago by Mr. Brian Gale.

William, that was my thought as well.  But as you can see with my test scenario, adding nullable columns doesn't seem to affect table size until a fixed-width column is...

When you go to install the upgrade, it should have listed all of the applicable instances that it can be applied to.

If I had to venture a guess, the MAMUT...

I am not sure I understand the question... Are you asking about SQL Server 2019 (as is in the question) or about SQL Server 2019 Reporting Services (the topic)?

Or is...

If it is a single threaded application, having a 16 core, 32 thread processor isn't going to help too much.  If you have really good multi-core processing but poor single...

If SSMA is a single threaded application (likely), then it may stop responding while it is gathering information and doing calculations.  Also, all of the information is attempting to be...

Did you click on the text 'Failed"?  That should explain what is wrong.

If I had to guess - you have a 64-bit version of SQL Server installed and are trying...

Yeah... step 2 in what I posted above:

"Step 2: Run the file, and follow the instructions in the setup wizard to install. On the Installation Type page, select Add features...

At first I was going to say "SQL Server Migration Assistant is deprecated and replaced with Data Migration Assistant", but that is only true for SQL to SQL migrations, not...

If I remember right, SSRS is one of the "Shared" services.  So, when you applied the update, the shared stuff was likely updated at the same time.

If you browse to...

I see your point Jeff, and that makes sense.  You can't just assume that the missing column is the last one or that new columns will always end up at...

My opinion - I would try to restrict access to profiler and extended events down as far you as possibly can.  If the end user can't run profiler or extended...