In a cluster setup (FCI), any services should be handled through Windows Failover Manager. Starting/stopping services with either SSMS or SSCM (configuration manager) will cause the cluster to believe the...

Do you mean deletes within a job, or deleting the whole job. If it's the whole job, I would think -force would work as it drops all objects in the...

Have you read the dbatools documentation for that process? It's here: https://docs.dbatools.io/#Sync-DbaAvailabilityGroup. I've found they give you so many options and have documented it so well that sometimes it's easy...

Is it intentional to have two DeptCode Parent values for London? That seems to be why you're getting both values back. In your sample data, there isn't a date value...

The...

I've never worked with a DAG before, but when I've encountered this problem with regular AGs, I remove it from the AG (which it sounds like you already have), make...

Have you removed it from all the secondaries of AG1 already? If so, you should be able to just delete the database on AG1. But, if it's still participating in...

Thanks! So it's always good practice to go multiple tempdb data files based on CPUs. So my understanding is since SQL 2016 installation there is a option to configure...

Can you provide some sample data that you have? It should be an implicit conversion from char to datetime. See the following link: https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15

The chart about 1/3 of...

Better option is to make several tempdb data files and place them all on the same tempdb drive. The number of files depends on the number of CPUs on...

• This reply was modified 5 years ago by  SQL_Hacker.

There seems to be a missing variable declaration and set. In the section that starts:

 WHERE s.name = CASE WHEN @eventName = 'BlockingReport' THEN 'Blocking' ELSE @eventName...

Hmmm. Okay, well your question was really about the transaction log, so here's how you can make sure the log file doesn't grow "too much". Please keep in mind that...

Is the data still on the primary replica? Or, is that what you're waiting for the sql text to find out?

The client need to update a big table. the UPDATE will be done in the application and the application is using cursor to update the table. I am worrying...

Is there an Order table? Typically, there is an Order and OrderDetail (or in your case OrderItems) to relate the order to the order items. If not, where does the...