Topic · 10 articles

Database

Articles February 2024

28 Feb 2024

SQL LocalDB: Upgrade to 2022 (15.0.2000)

For me it was quite confusing to find the 2022 version of LocalDB and it is not a streamline process to upgrade your local default instance. The easiest…

17 Dec 2020

SQL LocalDB: Upgrade to 2019 (15.0.2000)

For me it was quite confusing to find the 2019 version of LocalDB and it is not a streamline process to upgrade your local default instance. The easiest…

26 Sep 2018

SQL: Index statistics update date

Simple query can help you get basic insights on when the index statistics where updated: [code lang=”sql” light=”true”] SELECT o.name AS TableName, i.name AS IndexName, STATS_DATE(i.object_id, i.index_id) AS…

4 Sep 2018

SQL LocalDB: Upgrade to 2017 (14.0.1000)

For me it was quite confusing to find the 2017 version of LocalDB and it is not a streamline process to upgrade your local default instance. The link…

19 Feb 2018

Azure SQL: The database ‘tempdb’ has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions. (Microsoft SQL Server, Error: 40544)

On one of the projects I’m involved in, whatever we wanted to do with our Azure SQL DB (V12), we got this error: The database ‘tempdb’ has reached…

15 Dec 2017

SQL Query Store: Compare queries in two periods (execution counts, duration)

If you work with Azure SQL or Microsoft SQL Server 2016+, one of the new features there is the Query Store. It stores useful statistics on queries executed,…

30 Nov 2017

Azure: How to solve Azure SQL “database is not currently available”

Developers sometimes ask me about “database is not currently available” error when using Azure SQL and Entity Framework 6. In this article I explain why happens this error…

28 Nov 2017

Tip: Microsoft LogParser [Studio] superfast SQL-like querying of any log file

LogParser (download) is a command line tool from Microsoft which allows you to query any text-based log file using SQL-like syntax. The basic list of supported formats is quite…

21 Oct 2017

SQL: Padding numbers with leading zeros (15 -> 00015)

You might find a better way, but how about: [code language=”sql” light=”true”] = REPLACE(STR(15, 5, 0), ‘ ‘, ‘0’) [/code] STR(num, length, decimals) function converts the number to…

3 Oct 2017

SQL DMV: Most Expensive Queries, Missing Indexes

Database Management Views and their usage in SQL performance tuning scenarios are well known. There are plenty posts with many different versions of the Most Expensive Queries query.…