Database Journal

@DatabaseJournal

Daily Database News, Information and Tutorials for the Database Professional

Database Journal
@DatabaseJournal
May 18, 2020
Is COUNT(rowid) Faster Than COUNT(*)?: It is believed that count(*) expands to all columns and that count(rowid) is faster. Read on to see why the opposite might be true. dlvr.it/RWtWXN
Database Journal
@DatabaseJournal
May 11, 2020
How Many Databases Can You Name?: There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases! dlvr.it/RWR4bV
Database Journal
@DatabaseJournal
May 4, 2020
How to Find the Estimation Cost for a Query: Discover how to estimate the cost of a query. Read on to see an example of how to extract the Estimated Cost for execution plans stored in the procedure cache. dlvr.it/RVzvYz
Database Journal
@DatabaseJournal
Apr 27, 2020
Understanding Views in SQL: Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views. dlvr.it/RVYC6L
Database Journal
@DatabaseJournal
Apr 20, 2020
Introduction to Azure SQL Database Instance Pools: Learn about Azure SQL Database Instance Pools and how they they set to provide more flexibility and agility than other Platform-as-a Service SQL Server-based offerings in Azure. dlvr.it/RV6YWC