My understanding is that with write heavy databases, RCSI can help as the read operations are no longer blocked by the writes. That being said, you are going to see...

"The maintenance installation script that creates all of the stored procedures is over 9000 lines. I am not going to spend the hours reviewing that "

I dont review the 9000...

Now, nothing against Ola Hallengren's script, but I prefer something I can support and that is more targeted to my environment. I also prefer small, specific scripts...

Just because I was curious, I looked into this and I am a bit skeptical on it.

I found this website with more information on it:

https://en.wikiversity.org/wiki/Experimental_Verification_of_the_NKTg_Law_Using_NASA_Neptune_Data_(2023%E2%80%932024)

Where some assumptions are being made...

Just to add to the advice - I would advise against SELECT * unless it is absolutely necessary. The reason being if the source metadata changes (column added or column...

interesting.   i generally rdp into that machine and more often than not when i disconnect, ssms is still left running under my creds.   let me see if that makes...

Another thing it can be that I have seen is if I leave SSMS open and connected to a system for a long period of time, SSMS gets slow. If...

As a guess - how much free resources (memory specifically) do you have when it gets into the funk and what is your max memory configuration? I am thinking it...

To add to what Thomas Franz said, there are also risks with indexes. In some cases, indexes can hurt SELECT performance. Also, the different types of indexes is a bit...

My advice - reach out to your licensing contact as they will be able to help you more than a random forum.

But according to Microsoft:

Client access licenses (CALs) are required...

I think log shipping should work. Found a blog post where someone did that with a 60TB database:

https://johnsterrett.com/2015/08/18/adding-a-vldb-database-to-an-sql-server-availability-group-in-60-seconds/

And they had basically no downtime!

I've not done anything that big before, but there are tools that make failovers nice and easy without the need for AG's. We use DxEnterprise for our failover and it...

As a thought - any way you can reduce the database size? Is there some data you could archive to get it to a more manageable size or is all...

My opinion, AI is great for handing tasks that are slow and error-prone by users. Hand me a 1 GB log file and ask me to find the problem OR...

One way to handle removing linked servers is to handle...