rajendra gupta3 days ago3 minSQLGenerate 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.
rajendra guptaMay 51 minSQLT-SQL script to configure SQL Database for optimal VLF distributionT-SQL script to configure SQL Database for optimal VLF distribution
rajendra guptaMay 42 minSQLSQL Server MeMORY Optimized Table Variables for faster performanceSQL Server memory-optimized tables are a great way to improve performance for table variables. Read More here
rajendra guptaMay 32 minSQLRead Session-Specific data from the memory-optimized temp tablesConvert memory-optimized temp tables into session-specific memory temp tables in SQL Server.
rajendra guptaApr 224 minSQLUse Memory Optimization for Faster temp table performanceRead this article to learn how to optimize your SQL code by using memory-optimized tables instead of SQL Server temporary tables.
rajendra guptaApr 212 minSQLLocks with SQL Server UPDATE STATISTICS WITH FULLSCAN This article discusses how SQL Server locking works with the SQL Server Update Statistic command.
rajendra guptaApr 143 minSQLError 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...
rajendra guptaApr 133 minSQLSQL 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
rajendra guptaMar 311 minSQLQuery to list SQL Server indexes in a specific databaseSometimes 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....
rajendra guptaMar 303 minSQLSQL Server Performance Tuning – Index Scan vs. Index SeekThis article helps you to understand index scans Vs. Index with various examples.