Viewing 15 posts - 991 through 1,005 (of 2,883 total)
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...
July 19, 2021 at 2:02 pm
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...
July 16, 2021 at 7:02 pm
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...
July 16, 2021 at 5:28 pm
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...
July 15, 2021 at 9:26 pm
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...
July 15, 2021 at 7:40 pm
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...
July 15, 2021 at 7:22 pm
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...
July 15, 2021 at 3:57 pm
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...
July 15, 2021 at 2:53 pm
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...
July 15, 2021 at 2:47 pm
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...
July 14, 2021 at 10:02 pm
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...
July 14, 2021 at 9:17 pm
I agree with you there about SSIS. It can run and work happily without much help, but boy does it hate change or inconsistencies. Metadata changes and the package fails. ...
July 14, 2021 at 6:52 pm
Where are you seeing that?
The install instructions state:
Installation for the Existing Users
If you have an existing installation of Express with Tools, SQL Server Management Studio Express, or Express with Advanced...
July 14, 2021 at 3:51 pm
I am not sure if or how SSIS would natively handle working with SharePoint Online, but I know there are addons to SSIS (such as ones from CDATA) that can...
July 14, 2021 at 2:45 pm
My company uses SSIS entirely for our ETL.
Our process is the support request comes in for a report to be made. Next, a data person will determine where that data...
July 14, 2021 at 2:36 pm
Viewing 15 posts - 991 through 1,005 (of 2,883 total)