Viewing 15 posts - 1 through 15 (of 6,592 total)
Well, hardcoding would be an option, though this would require some maintenance issues if customers decides to need to look further into the past.
The source system is an Axapta...
April 23, 2024 at 6:46 pm
As a starting point - to insert into a table that has an IDENTITY column you MUST specify the column list excluding the IDENTITY column and cannot use SELECT *...
April 22, 2024 at 10:02 pm
The issue with partitioning is that the archive table must reside in the same filegroup as the main table - in the same database. If the goal is to move...
April 22, 2024 at 9:46 pm
This could just be normal parameter sniffing issues - there are a couple ways to handle this from SSIS.
First - unless you really need to be able to parameterize the...
April 22, 2024 at 9:24 pm
There could be many reasons why the update takes longer some times vs other times - some of which have already been discussed. With that said I would avoid the...
April 22, 2024 at 8:20 pm
For the cluster to be healthy - you need more than 50% quorum votes. With 3 nodes and a witness you have a total of 4 votes - so you...
April 12, 2024 at 7:54 pm
With everything that has been stated so far - I want to touch back on the DBA recommending adding storage to the drive and expanding the transaction logs.
Basically, that is...
April 8, 2024 at 6:02 pm
Even if your calculate of needing only 18GB for that one transaction is true - you are not accounting for all of the other transactions that can occur at the...
April 7, 2024 at 4:36 pm
Thank you everyone.
This is very interesting. Is this a bug within SS that you cannot drop a #temp table inside a SP using the DROP TABLE command? Or is...
April 2, 2024 at 9:22 pm
As @Ant-Green stated - no, you do not need a listener for a read-only secondary. Users can connect directly to that instance to run queries.
You will need to setup a...
March 28, 2024 at 6:28 pm
The cost doesn't really tell you how long a query is going to take - or should take. When reviewing an execution plan - you want to look at each...
March 22, 2024 at 7:35 pm
Hold up - why are you restoring the database and then moving the files? You should be performing the restore and placing the files in the new location(s) as needed.
But...
March 22, 2024 at 7:27 pm
I already outlined the logic for how VLFs are created - and it all depends on how large the growth and whether or not that growth is smaller than 1/8...
March 20, 2024 at 8:02 pm
No - the palette is the white box where you can place your tablix/list/etc.
When you define the page layout, you can set the properties and define the margins. The palette...
March 20, 2024 at 7:49 pm
How can you be sure you are on the primary?
If you have permissions - you can query the DMV's: SELECT * FROM OPENQUERY(qahubservername, 'SELECT sys.fn_hadr_is_primary_replica(''dbname'')' where dbname is the name...
March 19, 2024 at 11:38 pm
Viewing 15 posts - 1 through 15 (of 6,592 total)