If you're going to cite an article, it would be polite to provide the link, as well,

Now... notice that the tip says IF your server has  a lot of...

Index rebuilds won't make a database go offline unless the logfile explodes large enough to fill the disk it's on.

Index rebuilds will make the table data unavailable (which will obviously...

I have to say that it probably won't do much for performance (if anything at all) but it may cause some memory pressure because you're doubling the minimum of every...

Ok... just my 2 cents and, like you, I've not been using them for long and so I could still be missing a nasty caveat or two but, so far,...

I think that a large part of the reason why Access won't die is because it has everything it needs and you don't actually have do any programming to use...

This is pseudo-SQL, but seems like you'd be better off with a start and end parameter, which you set at the start of the batch:

DECLARE...

That sounds dangerous, simply because reduced availability will likely drive customers away, so the efficiencies that are assumed to be gained are really lost completely. Customers pay for their...

I though you said that you understood queries...  😉

As in most languages, you can...

This is because of one of "those" attempts by Microsoft to fix performance issues.  This particular issue is caused by a "performance enhancement that allocates complete extents (up to 4,...

Hi I am trying to get :

if today is Monday then it will show result from Friday to Sunday

Else

if today is not Monday then I will show you result...

Thank you all of you for explaining. If I want to retrieve data from SQL server and Oracle. Is there any difference in query structure between SQL and...

Thanks, Thom.  Understood on the 2019 stuff.  I was under the impression that it wasn't actually a "4th" type... I was under the impression that if SQL Server...

Thank you all of you for explaining. If I want to retrieve data from SQL server and Oracle. Is there any difference in query structure between SQL and Oracle ...

Yeah... confirmed.  It's not something that you can assign.  It just happens if you do things right.  You can, however, prevent it.  I don't know why anyone would want to...

Thanks, Thom.  Understood on the 2019 stuff.  I was under the impression that it wasn't actually a "4th" type... I was under the impression that if SQL Server could run...