Lessons Learned from a Poor-performing VIEW
It is a “common knowledge” among SQL practitioners that VIEWs don’t perform well. Recently during an application’s development I put...
2015-03-20 (first published: 2015-03-12)
8,906 reads
It is a “common knowledge” among SQL practitioners that VIEWs don’t perform well. Recently during an application’s development I put...
2015-03-20 (first published: 2015-03-12)
8,906 reads
Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...
2014-05-01
2,399 reads
In SQL Server 2008, Microsoft added a new SQL query type: the MERGE statement. This flexible query provides the ability...
2014-04-13
5,520 reads
So far in our blogs, we have talked a bit about performance, but today we’re going to show you a...
2014-04-17 (first published: 2014-04-08)
4,538 reads
In SQL 2008, Microsoft introduced some new date and time data types to augment the options available in prior versions....
2014-04-08 (first published: 2014-04-04)
6,704 reads
When I first heard this, it struck me as being a remarkably concise wisdom applicable to virtually any programming task....
2014-04-01
1,135 reads
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
31,313 reads
The Tally (or Numbers) table is one of the most useful constructs in intermediate-level SQL. Have you ever written a...
2014-03-27
45,599 reads
In today’s blog I will attempt to challenge the popularly held notion that LIKE “%string%” wildcard searches must be slow...
2014-03-26
20,670 reads
In SQL Server 2005, Microsoft introduced the Common Table Expression (CTE). CTEs share similarities with VIEWS and derived tables, but...
2014-03-23
1,582 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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