My problem with Query Store and some of the people that use it is that, quite frequently, many of the plans (there's just 2 or there's more) are terrible.  A...

Show me where in Table "A" that you have the value "DEF0002".

I think your example data for Table "A" is incorrect.

Sounds like it's time to...

I know it's been...

I've PM'd you to ask a favor,...

Shift all parameters 1.5 bytes to the left and start the run.  In 30ms, stop the run and then restart it.  Note that you have to do...

DAMMIT!!    I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!

Does anyone still follow this thread, and if so, can you...

Posting to get Johan's answer to show up.  It was the first post on a new page and this forum still has the problem of not showing the first post...

The only time you might want to do a rebuild on a system (or any other database) is if you need to recover a lot of disk space.  You check...

Windows 11 PRO???  You need to have a Windows Server.  I'm surprised that your SQL Standard Edition even runs on that desktop edition.

TBH, I'm thinking it might be automatic reboots...

Does it make any difference with the on-going open transactions to the database? is it better to do during maintenance windows when there are no incoming connections from the...

A shrink that large will take a long time, especially if there's a fair bit of LOBs in the data.  Worse yet, you won't be able to see any progress...

• Have you rebuild all indexes and statistics after migration/upgrade ?
• Did you compare old vs new SQLplans ?
• How many indexes / indexed views are based on the...

I think I'll go to the other extreme. I am waiting for eye surgery right now, so there will be a little delay, but I will develop an article...

After more than 2 decades of having CPU's that have some serious math co-processors, you'd think they change the code for the floating point math that occurs in the NUMERIC...