I  just wonder how this even could happen. Did all the companies not install the patches on the testing / dev environment before? And do they not have a cluster...

the problem is, that DATETIME is not an exact datatype (similar to float vs. decimal). DATETIME suppots only about 0.003 accuracy, so a DATETIME2 = '20240708 23:59:59.998' would be converted...

The two statements in the chapter More details of JOINs are equal.

And both are wrong, since you need to put the SUM(o.Amount) > 1000 into the HAVING and not the...

Can't you use Redgate SQL Backup to do restores that are no longer possible with native SQL backups? I think, I did this some years ago with SQL 2005 to...

Still using SSMS 18.x since my second most important Addon (besides Redgate SQL Prompt) with the name SSMSBoost seems to be deprecated and there is no version that works with...

With

SET ARITHABORT OFF; -- or ON, it doesn't matter 
SET NUMERIC_ROUNDABORT OFF;

I will not get a warning (contrary to the explanation). But with NUMERIC_ROUNDABORT ON I will...

Parthprajapati wrote:

Appreciate the feedback! While MIXED extents have limitations, they can still offer performance & storage benefits in specific cases like TEMPDB management. I'm open to further discussion & exploring...

• This reply was modified 2 years, 8 months ago by Thomas Franz.

In my opinion this article was written by ChatGPT or another KI tool with no real knowlegde. Besides the errors mentioned by Uwe Ricken it is not more than a...

• This reply was modified 2 years, 8 months ago by Thomas Franz.

Regarding the fact, that people are fired but other companies can't find candidates:

Besides the skill mismatch problem it may be a quality problem too. The IT was booming the last...

Regarding:

However, if I were carrying around data that was more important than the work I do now or data worth a lot of money, I don't know I'd ever enable...

we have a ton of stuff local saved (as developer), but the disks of our notebooks are encrypted. Of course this is not 100% secure, if the police storms my...

2 minutes is too few in my opinion - it happens regularly that I do something else than typing / moving the mouse (even seeing a training video could theoretical...

• This reply was modified 2 years, 11 months ago by Thomas Franz.

take the database offline (or at least ensure, that nobody writes to it by executing another RESTORE DATABASE on it) and make a file copy / backup of it and...

Very old article / discussion, but I disagree with the tip to set another database than master as default too

• problems (or manual modifications of settings) when the database is...

My colleague uses this in a database where the analysts could run several simulations.

Each analyst has his own user + schema (which is the default schema for this user) with...