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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

The palette size is causing the problem - if you are selecting portrait with a paper size of 8.5in with margins set to 1in then you only have a palette...

• This reply was modified 2 years, 2 months ago by Jeffrey Williams.

An AG doesn't have a 'Publisher' - directing a connection to a specific node in an AG will connect to that specific node.  If that node is not the primary...

Log File = 716,800GB

If you have 512MB VLFs - that would be 1,400 VLFs.  At only 900 VLFs you have an average of less than 512MB per VLF.  For each...