
Generate and Decode QR Codes with Python
This post discusses how to use Python to generate and decode QR Codes. Learn how to use Python to develop your custom QR Code.
25 views

Why developers should avoid creating SQL Server Stored Procedure prefix SP_
I will show you why developers should avoid creating SQL Server stored procedures that start with SP_. Read More here
87 views

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

SQL Server MeMORY Optimized Table Variables for faster performance
SQL Server memory-optimized tables are a great way to improve performance for table variables. Read More here
302 views

Read Session-Specific data from the memory-optimized temp tables
Convert memory-optimized temp tables into session-specific memory temp tables in SQL Server.
68 views

Use Memory Optimization for Faster temp table performance
Read this article to learn how to optimize your SQL code by using memory-optimized tables instead of SQL Server temporary tables.
201 views

Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
This article discusses how SQL Server locking works with the SQL Server Update Statistic command.
255 views

Explore WITH(NOLOCK)and the difference between NOLOCK and WITH(NOLOCK)SQL Server Table hint
SQL Server Table hint WITH(NOLOCK) and the difference between NOLOCK and WITH(NOLOCK)
* Are you using NOLOCK or WITH(NOLOCK) in SQL Server?
208 views

Error while SQL Server Service Pack or Cumulative Updates: "Cached MSI file is missing”
Are you getting the following Cached MSI file missing error (Error Code 0x84B20002) while trying to do SQL Server Service pack or...
466 views

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