Set Max DOP to 4, create 4 separate equally sized tempdb data files, and set Cost Threshold for Parallelism to like 50

That will make small light queries just use one...

Hopefully you got a create and modify date fields on that table.

Create field for inserts and modify field for updates.

For deletes, if the primary key is unique and sequential without...

I would first try to optimize the report queries before changing the Always On architecture.  From an experienced DBA, most likely table indexes are needed somewhere and/or the overall query...

There shouldn't be an issue with that big of a leap in faith.

The only things to watch out for are the upgraded encryption defaults. If apps accessing the database are...

Hi Brandie, will writing a subquery work for this issue?  Such as the below example?

select sum(count)
from
     ( select servername, count = count(*)
 ...

Hi Stan,

I don't believe the .dll references in your script and GAC entries will be deployed along with your package deployment.  That's something you'll have to set up on the...

Hi Adri

I went through the same domain migration and had to clone existing windows logins/groups to the new domain which looks like you're attempting to do.  Here are 2 steps...

• This reply was modified 2 months, 2 weeks ago by SQL BrainBox.

Personally, I'd separate the user database data and log files into separate volumes.

As for the tempdb database, AWS EC2 uses solid state drives (SSD) so there's no need to create...

• This reply was modified 2 months, 2 weeks ago by SQL BrainBox.

There's usually a maintenance job of some sort that runs nightly.  For example, I have the History Cleanup job running daily at 4am.

I would just add a job step to...

• This reply was modified 1 years, 8 months ago by SQL BrainBox.

Just set all grantor to SA.  Who really minds who granted what permission.  It's going to be a DBA with sysadmin access doing it.

update internal.project_permissions

set grantor_sid = 0x01

Just set all grantor to SA.

Who really minds who granted what permission?  It's going to be a DBA with sysadmin access doing it.

update internal.project_permissions

set grantor_sid = 0x01

Try beefing up your DR with more CPU and RAM so it can restore faster.  Some companies setup DR servers on lower resources from PRD in order to save costs. ...

A server upgrade would just be a once in a while event and not recurring with high frequency.  I'd recommend using SSDT and using the Business Intelligence > Integration Service...

DMK is only needed if you want to maintain sensitive values in your package as you restore the SSISDB database to another server instance.  If DMK is not restored, the...

Try not to specify the idPool column twice in the same Update statement and get rid of the Select statement.

The select statement where criteria is the same as the update...