Technology

SQL Server Snapshot Creation Error – “All files must be specified for database snapshot creation”

There are several reasons where you will get this error, but I’m going to talk about the one I faced and can be fixed in seconds. I was working with an IMDB dataset. The reason for my error was a database rename. I created the database initially with the name… Read More »SQL Server Snapshot Creation Error – “All files must be specified for database snapshot creation”

VS Code Won’t Open After Unplanned Restart (Failed to deserialize the V8 snapshot blob)

The visual studio was running fine in my machine till an unplanned restart happened. Soon after restart VS didn’t open giving me the below error. I reinstalled the Visual Studio Code without uninstalling which fixed the issue. In addition, it started without any loss to previous plugins and open projects.… Read More »VS Code Won’t Open After Unplanned Restart (Failed to deserialize the V8 snapshot blob)

PostgreSQL – BULK INSERTING from a delimited file, Most common errors in Windows

PostgreSQL alternative for MS SQL Server BULK INSERT is the equally simple COPY command. In this article, we are going to take a step by step look at how to use this and possible errors. So I tried below command, which is completely correct. I faced a couple of issues… Read More »PostgreSQL – BULK INSERTING from a delimited file, Most common errors in Windows

PostgreSQL – How to get the total index size used by each table in a database

As per the documentation, To get the total size of all indexes attached to a table, you use the function. The pg_indexes_size() function accepts the OID or table name as the argument and returns the total disk space used by all indexes attached to that table. We will use this… Read More »PostgreSQL – How to get the total index size used by each table in a database

DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees

Abstract: “Automating physical database design has remained a long-term interest in database research due to substantial performance gains afforded by optimised structures. Despite significant progress, a majority of today’s commercial solutions are highly manual, requiring offline invocation by database administrators (DBAs) who are expected to identify and supply representative training… Read More »DBA bandits: Self-driving index tuning under ad-hoc, analytical workloads with safety guarantees

Index Physical Structure Example; Multi-column Non-Clustered Index with Includes

This article demonstrates the physical design of a multi-column non-clustered index with include-columns. Many examples on the internet only demonstrate the most simple version of an index with a single column. This article gives a proper view of an index with multiple columns through a simple example. Furthermore, you can… Read More »Index Physical Structure Example; Multi-column Non-Clustered Index with Includes

Last updated by .