Sergey Gigoyan

• Auditing Failed SQL Server Transactions Using Table Variables (last update: 6/14/2019)
  

• Backup Database Task in SQL Server Maintenance Plans (last update: 12/5/2019)
  
• SQL Server Backups and Transaction Log Questions (last update: 12/18/2015)
  

• SQL Server Referential Integrity without Foreign Keys (last update: 3/31/2016)
  

• SQL Server Bit Data Type (last update: 6/29/2020)
  

• Move SQL Server Tables to Different Filegroups (last update: 12/17/2018)
  
• Remove Unnecessary SQL Server Transaction Log Files (last update: 11/18/2015)
  
• Synchronizing SQL Server data using rowversion (last update: 11/9/2016)
  

• Find and Remove Duplicate Rows from a SQL Server Table (last update: 8/16/2019)
  

• Some Tricky Situations When Working with SQL Server NULLs (last update: 11/10/2015)
  
• Using SQL Server Profiler to Capture Stored Procedures Executions (last update: 6/11/2020)
  

• Storing passwords in a secure way in a SQL Server database (last update: 9/29/2015)
  

• SQL Server transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements (last update: 9/14/2015)
  

• Capture Executions of Stored Procedures in SQL Server (last update: 9/16/2020)
  

• Using Global Temporary Staging Tables for SQL Server Data Importing (last update: 2/19/2016)
  

• Difference between SQL Server Unique Indexes and Unique Constraints (last update: 6/13/2016)
  
• SQL Server Maintenance Plan Reorganize Index and Update Statistics Tasks (last update: 12/20/2019)
  
• SQL Server Maintenance Plans Rebuild Index Task (last update: 12/13/2019)
  

• Install SQL Server from Configuration File with Installation Center (last update: 5/12/2020)
  

• Install SQL Server Integration Services in Visual Studio 2019 (last update: 7/9/2020)
  

• Connecting to Integration Services Access is Denied in SQL Server 2016 or 2017 (last update: 11/27/2019)
  

• Joining SQL Server tables using large character type columns (last update: 3/2/2016)
  

• Compare Repeatable Read and Serializable SQL Server Transaction Isolation Levels (last update: 9/1/2016)
  
• Compare SQL Server NOLOCK and READPAST Table Hints (last update: 9/22/2016)
  
• Monitor Deadlocks in SQL Server with system_health Extended Events (last update: 5/27/2020)
  
• SQL Server UPDATE lock and UPDLOCK Table Hints (last update: 1/28/2020)
  

• Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer (last update: 9/30/2019)
  
• Getting Started with SQL Server Maintenance Plans - Part 1 (last update: 7/24/2019)
  
• SQL Server Maintenance Plan Execute T-SQL and SQL Server Agent Job Tasks (last update: 12/27/2019)
  
• SQL Server Maintenance Plan Shrink Database Task (last update: 1/10/2020)
  
• SQL Server Maintenance Plans History Cleanup Task (last update: 2/18/2020)
  
• SQL Server Maintenance Plans Maintenance Cleanup Task (last update: 3/2/2020)
  
• Transfer SQL Server Maintenance Plans Between Servers (last update: 4/20/2020)
  

• SQL Server Interview Questions for Developers on Querying (last update: 8/7/2020)
  

• Solve Common SQL Server Restore Issues (last update: 12/4/2015)
  

• Setting a fixed amount of memory for SQL Server (last update: 3/7/2016)
  

• Debugging T-SQL Code in SQL Server Management Studio (last update: 12/8/2017)
  
• Executing large scripts in SQL Server Management Studio with Insufficient Memory Failures (last update: 1/29/2016)
  
• How to Install SQL Server Management Studio on your Local Computer (last update: 6/29/2017)
  
• SQL Server Database Diagram Index was Outside the Bounds of the Array (last update: 3/13/2020)
  
• SQL Server Management Studio Connection to Integration Services Error Class Not Registered (last update: 7/22/2020)
  
• SQL Server Management Studio Productivity Tips (last update: 7/5/2017)
  
• SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips (last update: 7/11/2017)
  
• SQL Server Management Studio Tips – Generating Scripts (last update: 7/18/2017)
  
• SQL Server Single User Mode Connection with SQL Server Management Studio (last update: 9/2/2020)
  

• Compare SQL Server Features - Decimal vs Numeric, Timestamp vs Rowversion, Unique Index vs Unique Constraint (last update: 7/5/2019)
  
• Comparison of SQL Server Serializable and Snapshot isolation levels (last update: 12/24/2015)
  
• Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters (last update: 9/10/2018)
  
• Exploring SQL Server 2014 Table Variables (last update: 10/16/2015)
  
• Find MAX value from multiple columns in a SQL Server table (last update: 10/20/2015)
  
• Handling Transactions in Nested SQL Server Stored Procedures (last update: 6/8/2017)
  
• READ_COMMITTED_SNAPSHOT and SNAPSHOT_ISOLATION levels in SQL Server (last update: 8/21/2020)
  
• SQL Server CASE Statement Example (last update: 2/11/2020)
  
• SQL Server Global Temporary Table Visibility (last update: 9/22/2015)
  
• Write more compact SQL Server code using new features (last update: 11/20/2018)
  
• Write More Compact SQL Server Code Using New Features - Part 2 (last update: 12/3/2018)
  

• DDL commands in Transactions in SQL Server versus Oracle (last update: 12/9/2016)
  
• Handling SQL Server transactions in nested stored procedures using Savepoints (last update: 6/27/2018)
  
• SQL Server READ_COMMITTED_SNAPSHOT Database Option and READ COMMITED Transaction Isolation Level (last update: 4/1/2020)
  
• Understanding SQL Server Transaction Savepoints (last update: 6/14/2018)