Did you even read any of what was written?

ok, so that's what I thought. In fact often times I'm not even creating the primary key. I simply create 1 or many unique indexes because it was my...

I think you meant this tongue in cheek, but this...

A clustered Primary key is a unique clustered index.

If you aren't clustering your primary key and clustering something else instead, your performance could be worse, it could be better or...

• This reply was modified 1 year, 7 months ago by  CreateIndexNonclustered.

just had a ton of empty space. We did shrink it to get whatever alert in solar winds to stop so we could avoid addressing it and what disabling autogrowth...

I did have an almost 20 tb database a few years ago - 19 Tb anyways that I inherited at a previous job. It stored pictures and tons of metadata...

changing page verification to checksum, widening a column, after an irregular large delete or update, after a sql version upgrade, controlling growth of a VLDB (even 15% fragmentation on a...

Most likely causes:

Bad statistics in production

Parameter sniffing

Production hardware is different than staging or production hardware is oversubscribed. If UAT is in a dev cluster that is lightly used, it could...

For question #1, just do a test.  I think that you'll find that the stats take a lot longer because Index Rebuilds only affect/rebuild the columns they actually use. ...

I did this as a proof of concept on 2017 and it was pretty ugly getting it to work and to keep it working consistently through failover. The replications were...

ChatGPT is DANGEROUS. It always produces results that seem plausible but can be entirely wrong. If you are lucky, it just won't compile. If you aren't it may destroy a...

Having worked with timecard and leave reporting in the past, if you are looking for better accuracy with that additional status, I would expect your results to be mixed at...

They way he/she is doing it, it doesn't need to be unique. It only needs to reduce the number of records that need to be scanned at low cost.

This is...

It depends on the server, but the basic starting point is typically only to do statistics updates every two weeks. Some go more often than that. Dynamics servers I do...

Ok, so you are asking for scheduling start time rather than refreshing every quarter hour.

Its been a while since I worked with that and I don't remember well enough to...