SQL Puzzle: SQL Advance Query – Calculate SUM between Two Tables

Check the below input data and expected output for calculating SUM between two tables in SQL Server. Input Data for table T1: [crayon-673aa6df7a488402670914/] Input Data for table T2: [crayon-673aa6df7a493499909045/] Expected Output: [crayon-673aa6df7a495677442776/] Create two sample tables: [crayon-673aa6df7a496102899971/] Insert sample records: [crayon-673aa6df7a498102613648/] Solution: [crayon-673aa6df7a499597856971/] Please try the different solution for this puzzle and share it via […]

January 16, 2018 3 SQL Puzzle

January 15, 2018

SQL Server 2014: Buffer Pool Extension to improve I/O throughput and Query Cache

January 14, 2018 5

SQL Server: Frequently Restart a SQL Server is a bad practice

January 13, 2018

SQL Server 2016: Introduced Live Query Statistics, Monitor Live Query Execution

January 12, 2018

SQL Server 2016: sys.dm_db_column_store_row_group_physical_stats to find fragmentation of Columnstore Indexes

January 11, 2018

SQL Server 2016: sys.dm_column_store_object_pool to find memory pool usage by Columnstore Indexes

January 10, 2018

SQL Server 2014: sys.column_store_row_groups to find information on Columnstore row groups

January 9, 2018 2

SQL Server 2012: SORT_IN_TEMPDB used to Improve the Index Rebuild Performance

January 8, 2018

SQL Server: Easy way to get the Table Difference For Data

January 7, 2018

SQL Server 2016: Columnstore Index on Memory Optimized In Memory OLTP Tables

Older posts Newer posts

About Me!