SQL SERVER

This post discusses how to use Python to generate and decode QR Codes. Learn how to use Python to develop your custom QR Code.

T-SQL script to configure SQL Database for optimal VLF distribution

SQL Server memory-optimized tables are a great way to improve performance for table variables. Read More here

Convert memory-optimized temp tables into session-specific memory temp tables in SQL Server.

Read this article to learn how to optimize your SQL code by using memory-optimized tables instead of SQL Server temporary tables.

This article discusses how SQL Server locking works with the SQL Server Update Statistic command.

Are you getting the following Cached MSI file missing error (Error Code 0x84B20002) while trying to do SQL Server Service pack or...

SQL Server Query Optimization- Learn about the use of functions (DateDiff) in the Where clause. Learn how to tune these queries to run fast

Sometimes you need to know the list of SQL Server indexes available in the SQL database. There are many ways to get the list of indexes....

This article helps you to understand index scans Vs. Index with various examples.