Quantifier predicates
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
2022-01-14
This article explains which Python library provides create, read, update, and delete (CRUD) operations on a SharePoint list along with examples.
2021-11-19
In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.
2021-11-10
This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well as exponential moving averages with different period lengths.
2021-10-15
Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.
2021-09-29
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
2021-09-24
When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. Read Brent's blog to see him demo it by writing a stored procedure in the Stack Overflow database.
2021-07-05
This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.
2021-05-14
In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.
2021-04-26
In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.
2021-03-31
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers