As Ed points out, analysing the residual log files does help!

😎

You will find a script for log recovery and analysis in this article

Bringing them back from the dead –...

Happy New Year everyone!

😎

DBA means different things to different people;

Developer: Devil's Bothering Annoyance

Analyst: Data Botching Aggregation

Further suggestions anyone?

Quick question, what operating system are you using?

😎

And out of curiosity, what is the purpose of this exercise? Are you working with FDA approved equipment or such with upgrade limitations?

Quick thought: Do not use the default size and growth property values; rather, use more practical settings that fit the database's usage patterns.

😎

Thinking of Radish Parsnip Oregano, makes "more sense"...

Any vegetarian options?

😎

One has to laugh, RTO no longer stands for Recovery Time Objective, now it means Return To Office

😎

Those ever-changing meanings of common TLAs are giving me a headache.

Does anyone have...

With the ever-evolving IDE's, my thought is that some essential knowledge may morphe into the "magic" sphere...

😎

SQLCMD, OSQL etc. did the job when one knew what the job was 😉

The bottom line is that, once again, they broke something that used to work just fine.  They're motto seems have become "If it ain't broke, fix it 'til it...

I will elaborate Jeff on the subject shortly.

😎

Certain that there is a bug there, the microsecond rounding used to work for the datatime data type, interesting to see if other...

Show your code, ol' friend, so that people don't just look at...

He he, 2022-07-03 13:41:52.0070000 is now unequal to 2022-07-03 13:41:52.007 depending on the data type 😉

😎

I cannot sufficiently nor politely express the growing level of disgust I've developed about Microsoft and SQL Server, especially since 2012 sp3.

I'd written some simple code to determine a...

As it happens, a  lookup table is precisely what I am creating.

The descriptions are supposed to be unique. If the originating organisation puts in duplicates because they cannot decide...

Hi @mark-3,

my concern here is that this exercise will render the data nonsensical and ambiguous.

😎

This free text approach is YASA, yet another SQL antipattern, a better approach is...