Viewing 15 posts - 1 through 15 (of 6,598 total)
So either this is a very bad interview question - or there are missing details from the question. There is no way you can answer the question correctly - so...
May 5, 2024 at 3:42 pm
AG group is in synronus- automatic with windows failover setup
Can any one reply on this when primary is down not accessible, also automatic failover not occurred to secondary and...
May 4, 2024 at 4:21 pm
The problem here is the $ in the PS script. SQL Server Agent is attempting to use that as a token - and that is causing the failure. The only...
May 2, 2024 at 9:55 am
Hi, yes that is my concern that BEGAN TRAN; and COMMIT TRAN; might not be improving things and could expose the query to holding a lock should something go...
April 27, 2024 at 4:53 pm
I tried incorporating Jeffrey's suggestion, but the ancient VS version I have to work with keeps crashing in the expression builder.
So, I decided to use the hardcoded solution and...
April 24, 2024 at 7:01 pm
Since all of the joins to the derived tables (selects in the from/join) - there is no benefit to even using the sub-queries. Removing the sub-queries and refactoring to simple...
April 24, 2024 at 6:25 pm
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
Viewing 15 posts - 1 through 15 (of 6,598 total)