Voting forces a choice. Do I want A, B, or C. consensus allows me to say A, but not B, C is OK. We can come to a choice...

I would like to know the difference of usage and syntax of if statement between T-SQL vs PL-SQL.

I noticed the T-SQL often uses Begin end after If statement, but...

Use LIKE with leading and trailing wildcards with the understanding that it will always cause a table or index scan (i.e. Non-SARGable query criteria).  If you want a coded answer,...

• This reply was modified 5 years, 5 months ago by Jeff Moden. Reason: Edited for clarification

Heh... its easy.  Voting is structured... concensus is a lynch mob....

From the article:

---

One of the main things that many scientists and governments have desired to help control the spread of disease is contact tracing.

I wish they had the same thing...

Now we know why I've never bothered with certifications.  It's like trying to take a bite out of a rolling donut.  And the one cert that I trusted (MCM), they...

Why Microsoft released a less performant FORMAT function to make SQL server look bad? I am sure Microsoft released it from requests by SQL server community.

If it's so...

Perhaps paging using OFFSET/FETCH in the ORDER BY clause will work better than using ROW_NUMBER().

@luissantos ,

Joe's response brings up an excellent point... why not simply buy a proven product that does all of what you've asked plus so much more?  For example (although I've...

are you producing striped backup files ?  (  Backup database - working with a striped media set ) That may also help to reduce the time needed. (...

But I still can't fathom why you want to send out notices just as their policies expire.  What is the business case for that?  What is the insured supposed...

Thanks, I'm going to try removing the nonclustered indices. But my problem, I think it is that it is not possible to shrink the mdf file below its initial...

Totally agreed, especially for a database that is becoming "Read Only".  Still, row and page compression will not...

Ok.  Thank you, Grant.

I previously provided you with a link to the Temporal Tables documentation and it has examples, etc, with different links for different things.  Of course, if you want the quick'n'dirty...