| Sr. No |
Article |
| 206 |
SQL SERVER | Disabling INDEXES : Clustered Index – A Good Idea ? | SQL Interview Question |
| 205 |
SQL SERVER | Enable or Disable CONSTRAINTs? | SQL Interview Question |
| 204 |
SQL SERVER | Table-Valued Parameters – Marshal multiple rows of data to SQL |
| 203 |
SQL SERVER | How to import CSV DATA using BULK INSERT? |
| 202 |
SQL SERVER – What is the Maximum Length for creating non-clustered index? |
| 201 |
SQL SERVER | Can you Skip Header Row in BULK INSERT? |
| 200 |
SQL SERVER | Handling Special characters with For XML PATH(”) Puzzle |
| 199 |
SQL Server | Deterministic and Nondeterministic Functions? |
| 198 |
Free Online Utilities to write SQL code – SQL Server, Oracle, mySQL Server, PostgreSQL, MariaDB |
| 197 |
SQL SERVER | SSMS 17.3 New Feature – XE Profiler |
| 196 |
SQL SERVER | SSMS v17.3 New Feature – Import Flat File Wizard |
| 195 |
NEW T-SQL FEATURES IN SQL SERVER 2017- III [ STRING_AGG() ] |
| 194 |
NEW T-SQL FEATURES IN SQL SERVER 2017- II [ TRIM() Function – Remove Leading and Trailing Spaces from a String ] |
| 193 |
NEW T-SQL FEATURES IN SQL SERVER 2017- IV [ DBCC CLONEDATABASE ] |
| 192 |
2017 | New Data Management Tool for SQL Server – SQL Operations Studio |
| 191 |
NEW IN SQL SERVER 2017 – SQL SERVER available in Multiple Operating Systems |
| 190 |
NEW T-SQL FEATURES IN SQL SERVER 2017- V [ CONCAT_WS() ] |
| 189 |
NEW T-SQL FEATURES IN SQL SERVER 2017- IV [ TRANSLATE() ] |
| 188 |
NEW T-SQL FEATURES IN SQL SERVER 2017- VII | Resumable Online Index Rebuild |
| 187 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XVII | JSON_MODIFY() |
| 186 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XV | JSON_VALUE() |
| 185 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XIII | ISJSON() |
| 184 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XII | OPENJSON Function (SQL Server) |
| 183 |
NEW T-SQL FEATURES IN SQL SERVER 2016- X [ FORMATMESSAGE() ) ] |
| 182 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XIX | PolyBase |
| 181 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XVIII | Dynamic Data Masking |
| 180 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XIV | JSON Support in SQL Server 2016 |
| 179 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – XI | Temporal Tables |
| 178 |
NEW T-SQL FEATURES IN SQL SERVER 2016- IX [ SESSION_CONTEXT() ) ] |
| 177 |
NEW T-SQL FEATURES IN SQL SERVER 2016- VIII [ TRUNCATE TABLE WITH ( PARTITIONS ( … ) ) ] |
| 176 |
NEW T-SQL FEATURES IN SQL SERVER 2016- VII [ USE HINT query hint argument ] |
| 175 |
NEW T-SQL FEATURES IN SQL SERVER 2016- VI [ STRING_ESCAPE() ] |
| 174 |
NEW T-SQL FEATURES IN SQL SERVER 2016- V [ DATEDIFF_BIG() ] |
| 173 |
NEW T-SQL FEATURES IN SQL SERVER 2017- IV [ DBCC CLONEDATABASE ] |
| 172 |
NEW T-SQL FEATURES IN SQL SERVER 2016- III [ CREATE OR ALTER ] |
| 171 |
NEW T-SQL FEATURES IN SQL SERVER 2016- II [ STRING_SPLIT() ] |
| 170 |
NEW T-SQL FEATURES IN SQL SERVER 2016 – I |
| 169 |
What you mean by Hot and Cold Data? |
| 168 |
ALTER Table – [ WITH { CHECK | NOCHECK } ] { CHECK | NOCHECK } CONSTRAINT | ALTER Table with CHECK options?? |
| 167 |
SQL Server | SQL SERVER Resource Database – Deep Dive |
| 166 |
SQL Server | SQL Server – Logical and Physical Operators |
| 165 |
SQL Server | Table Variables & Estimated No of Rows |
| 164 |
SQL Server | Types of Spools in Execution Plan – Deep Dive |
| 163 |
SQL Server | How to handle large number of insertions in SQL Server? |
| 162 |
SQL Server | Where CTEs are stored? |
| 161 |
SQL Server | How to write optimized queries |
| 160 |
SQL Server | How SQL SERVER handles duplicate values in an index? |
| 159 |
SQL Server | Execution/Query Plan Operator – The Concatenation |
| 158 |
SQL Server | Why Lookups are bad for performance? |
| 157 |
SQL Server | Spools in Execution Plan. Are they bad? |
| 156 |
SQL Server | What you should look in execution plans? |
| 155 |
SQL Server | How to avoid/eliminate/remove ORDER BY from SQL Queries? |
| 154 |
SQL Server | Table Variable – Estimated no of rows = 1 | No Statistics? |
| 153 |
SQL Server | Execution/Query Plan Operator – The Sort Operator – Part II, Which sorting algorithms used by SQL Server? Is it blocking or non-blocking? |
| 152 |
SQL Server | Execution Plan Operator – Properties, Types – Blocking / Non-Blocking? |
| 151 |
SQL Server | Why Order By is bad in Queries? / Execution/Query Plan Operator – The Sort Operator Basics |
| 150 |
SQL Server | What is Selectivity? How we can use this in creating our indexes? |
| 149 |
SQL Server | What are the internal methods of Physical Operators? How they work? |
| 148 |
SQL Server | What controls an Index Scan to read all pages from leaf level? Or An Index scan operator always reads all pages from leaf level? |
| 147 |
SQL Server | Implicit Conversions are Bad for Performances? Why? |
| 146 |
SQL Server | How to find latest order Id from Orders table for each product? (Top n orders for each product) Let’s write a better query. |
| 145 |
SQL Server | How to properly read an Execution Plan/Query Plan? |
| 144 |
SQL Server | LIKE IS SARGable, How to write better Where Clause –II. Let’s Check? |
| 143 |
SQL Server | CAST IS SARgable, How to write better Where Clause. Let’s Check? |
| 142 |
SQL Server | Update Statistics – Synchronously and asynchronously. Which one is better? |
| 141 |
SQL Server | Why we should update statistics? When one should update statistics? |
| 140 |
SQL Server | Avoid Using Function in WHERE Clause. Why? |
| 139 |
SQL Server | What is Plan Cache? Why it is important? |
| 138 |
SQL Server | Raw SQL Vs Stored Procedures? |
| 137 |
SQL Server | Estimated Execution Plan versus Actual Execution Plan? |
| 136 |
SQL Server | Execution Plans? |
| 135 |
SQL Server | Which one is better | Temp Table or Table Variable? |
| 134 |
SQL Server | Don’t ever do SELECT *. It’s really a bad idea. Why? |
| 133 |
SQL Server | Performance issues due to bad statistics? |
| 132 |
SQL Server | What are Statistics & why they are important |
| 131 |
SQL Server | SQL Server Query Optimizer |
| 130 |
SQL Server | Differences – Clustered & NonClustered , Clustered & Primary Key |
| 129 |
SQL Server | Filtered Index |
| 128 |
SQL Server | NonClustered Index with Included Columns & Covering Index |
| 127 |
SQL Server | Index – Clustered & NonClustered Index |
| 126 |
SQL Server | Different Methods to get Row Numbers WITHOUT Order By Clause in SQL Server |
| 125 |
SQL Server | Multiple ways to convert an Integer value to String |
| 124 |
SQL Server | SQL 2014 In Memory OLTP (Hekaton) |
| 123 |
SQL Server | Find Number of Days in a Year |
| 122 |
SQL Server | Different Methods to Insert multiple rows using single Insert Keyword |
| 121 |
SQL Server | Multiple ways to find distinct rows without using distinct Keyword |
| 120 |
SQL Server | Explicitly inserting data into an IDENTITY column |
| 119 |
SQL Server | GUID causes fragmentation in Clustered Indexes |
| 118 |
SQL Server | Cardinality IN SQL |
| 117 |
SQL Server | SQL SERVER 2014 New Features |
| 116 |
SQL Server | Cast vs Convert |
| 115 |
SQL Server | Find No of Column in a Table |
| 114 |
SQL Server | Difference between Count(1) / Count(1000) |
| 113 |
SQL Server | Len Vs Data Length |
| 112 |
SQL Server | Unique Key |
| 111 |
SQL Server | Query-to-find-last-day-of-a-month-in-sql-server-2005/ |
| 110 |
SQL Server | Getdate VS Sysdatetime |
| 109 |
SQL Server | Stuff VS Replace |
| 108 |
SQL Server | Bulk Insert |
| 107 |
SQL Server | Number of Indexes |
| 106 |
SQL Server | Print Row Numbers |
| 105 |
SQL Server | Explicit Value for Identity Column |
| 104 |
SQL Server | Insert multiple rows using one Insert keyword |
| 103 |
SQL Server | Delete duplicate rows |
| 102 |
SQL Server | Find duplicate rows |
| 101 |
SQL Server | Cast vs Convert |
| 100 |
SQL Server | Find number of columns in a table |
| 99 |
SQL Server | IsNull |
| 98 |
SQL Server | IsDate |
| 97 |
SQL Serve | Remove-date-from-datetime-field |
| 96 |
SQL Server | Add-n-number-of-days-in-current-date |
| 95 |
SQL Server | NULLIF |
| 94 |
SQL Server | Clustered Key Vs Non Clustered Key |
| 93 |
SQL Server | How-to-debug-a-stored-procedure |
| 92 |
SQL Server | Copy-data-from-one-table-to-another |
| 91 |
SQL Server | Remove-extra-multiple-spaces-in-string |
| 90 |
SQL Server | Space Function |
| 89 |
SQL Server | Row Count |
| 88 |
SQL Server | Error |
| 87 |
SQL Server | Exception-handling-in-sql-server-2005-using-try-and-catch/ |
| 86 |
SQL Server | Maximum-no-of-columns-in-a-table-in-sql-server-2005/ |
| 85 |
SQL Server | Use-of-objectproperty-to-find-whether-an-object-is-a-table-or-not-in-sql-server-2005/ |
| 84 |
SQL Server | Object and Column Property |
| 83 |
SQL Server | Insert-data-size-more-than-8000-in-a-column-in-sql-server-2005-and-not-more-than-12000/ |
| 82 |
SQL Server | Keys in Database |
| 81 |
SQL Server | Data Pages and Extent |
| 80 |
SQL Server | Data Files |
| 79 |
SQL Server | Types of Pages |
| 78 |
SQL Server | Query Execution |
| 77 |
SQL Server | Indexes in Detail |
| 76 |
SQL Server | ACID Properties |
| 75 |
SQL Server | Difference between DBMS and RDBMS |
| 74 |
SQL Server | Database |
| 73 |
SQL Server | Codds Rule |
| 72 |
SQL Server | Advantages of Stored Procedures |
| 71 |
SQL Server | Recompile option in a SP |
| 70 |
SQL Server | Delete Vs Truncate |
| 69 |
SQL Server | Basics of Derived Table |
| 68 |
SQL Server | Replicate Function |
| 67 |
SQL Server | Left Function |
| 66 |
SQL Server | Difference between Primary Key and Unique Key |
| 65 |
SQL Server | Right Function |
| 64 |
SQL Server | Updateable Views |
| 63 |
SQL Server | Magic Tables |
| 62 |
SQL Server | Database Paging using row number |
| 61 |
SQL Server | Page Split |
| 60 |
SQL Server | Page Structure |
| 59 |
SQL Server | Coalesce-statement-to-concatenate-all-the-rows-of-a-particular-column |
| 58 |
SQL Server | waitfor-function-in-sql-server-2005/ |
| 57 |
SQL Server | Delete-duplicate-rows-from-a-table |
| 56 |
SQL Server | Generate-a-complex-random-string |
| 55 |
SQL Server | Usage-of-from-clause-in-update-statement |
| 54 |
SQL Server | In-clause-for-multiple-columns |
| 53 |
SQL Server | Find-created-and-last-modified-date of SP |
| 52 |
SQL Server | Recursive-common-type-expression |
| 51 |
SQL Server | Change-table-name-index-name-coumn-name-using-a-query-in-sql-server-2005/ |
| 50 |
SQL Server | Differences-between-stored-procedure-and-function |
| 49 |
SQL Server | Object Id |
| 48 |
SQL Server | Interesting Facts |
| 47 |
SQL Server | System-tables-help |
| 46 |
SQL Server | Information-schema-view |
| 45 |
SQL Server | Ansi_nulls-on-off |
| 44 |
SQL Server | Quoted-identifier-on-off |
| 43 |
SQL Server | Renaming-your-database-in-sql-server |
| 42 |
SQL Server | Difference-between-char-and-varchar-data-type |
| 41 |
SQL Server | Difference-between-nchar-and-nvarchar-data-type |
| 40 |
SQL Server | Difference-between-char-and-nchar-data-type |
| 39 |
SQL Server | Difference-between-char-and-nchar-data-type/ |
| 38 |
SQL Server | Difference-between-numeric-and-decimal-data-type |
| 37 |
SQL Server | Difference-between-varchar-and-nvarchar-data-type |
| 36 |
SQL Server | Difference-between-smallmoney-and-money-data-type |
| 35 |
SQL Server | New-data-types-in-sql-server-2005/ |
| 34 |
SQL Server | Differences-between-smalldatetime-and-datetime |
| 33 |
SQL Server | Differences between Tinyint, smallint , int, bigint |
| 32 |
SQL Server | Execution Plans |
| 31 |
SQL Server | Estimated Vs Actual Execution Plan |
| 30 |
SQL Server | Formats of Execution Plans |
| 29 |
SQL Server | UDF (User defined functions) |
| 28 |
SQL Server | Triggers – Basic Information |
| 27 |
SQL Server | Case-function-and-order-by-clause |
| 26 |
SQL Server | IsNumeric function |
| 25 |
SQL Server |Disadvantages of Stored Procedures |
| 24 |
SQL Server | Views – Basic Information |
| 23 |
SQL Server | Types of Views |
| 22 |
SQL Server | Symmetric key creation |
| 21 |
SQL Server | Why-we-have-to-first-create-unique-Clustered-Key-on-view |
| 20 |
SQL Server | Indexed Views with Schema binding |
| 19 |
SQL Server | Basics of Normalization |
| 18 |
SQL Server | Normal forms |
| 17 |
SQL Server | Data Abstraction |
| 16 |
SQL Server| System Databases |
| 15 |
SQL Server | Transaction Isolation Levels |
| 14 |
SQL Server | Case Statement |
| 13 |
SQL Server | ISNULL Vs NULLIF |
| 12 |
SQL Server | Authentication Mode |
| 11 |
SQL Server | Use Statement |
| 10 |
SQL Server | DDL / DML / DCL / TCL |
| 9 |
SQL Server | Relational Engine |
| 8 |
SQL Server | SQL – TSQL |
| 7 |
SQL Server | Delete Cascade Update Cascade |
| 6 |
SQL Server | Union Vs Union ALL |
| 5 |
SQL Server | Table Scan | Index Scan | Index Seek |
| 4 |
SQL Server | Covering Index |
| 3 |
SQL Server | Set No Count ON |
| 2 |
SQL Server | Collation |
| 1 |
SQL Server | Fetch Status |
Improving my SQL BI Skills 
Pingback: Microsoft SQL Server 2019 | Features added to SQL Server on Linux | Improving my SQL BI Skills
Pingback: Python | Replace NONE by its previous NON None value | Improving my SQL BI Skills
Pingback: Python | How to convert a string to a list | Improving my SQL BI Skills
Pingback: Python | Find unique words from a string | Improving my SQL BI Skills
Pingback: Python | Calculate average word length from a string | Improving my SQL BI Skills
Pingback: Python | Find the number of times a substring present in a string | Improving my SQL BI Skills
Pingback: Python | Find maximum value from a list | Improving my SQL BI Skills
Pingback: Python | How to find GCF of two numbers | Improving my SQL BI Skills
Pingback: Python | How to find LCM of two numbers | Improving my SQL BI Skills
Pingback: Python | How to convert a list to a string | Improving my SQL BI Skills
Pingback: Python | Find common words from two strings | Improving my SQL BI Skills
Pingback: Python | Find un-common words from two strings | Improving my SQL BI Skills
Pingback: Python | How to convert a number into a list of its digits | Improving my SQL BI Skills
Pingback: Python | Print the first non-recurring element in a list | Improving my SQL BI Skills
Pingback: Python | Print the most recurring element in a list | Improving my SQL BI Skills
Pingback: Python | Find the cumulative sum of elements in a list | Improving my SQL BI Skills
Pingback: Python | Check whether an array is Monotonic or not | Improving my SQL BI Skills
Pingback: Python | Check whether a number is prime or not | Improving my SQL BI Skills
Pingback: Python | Print list of prime numbers up to a number | Improving my SQL BI Skills
Pingback: Python | Print elements from odd positions in a list | Improving my SQL BI Skills
Pingback: Python | How to sort an array in ascending order | Improving my SQL BI Skills
Pingback: Python | How to reverse an array | Improving my SQL BI Skills
Pingback: Python | Check a character is present in a string or not | Improving my SQL BI Skills
Pingback: Python | Find the missing number in the array of Ints | Improving my SQL BI Skills
Pingback: Python | How would you delete duplicates in a list | Improving my SQL BI Skills
Pingback: Python | Print positions of a string present in another string | Improving my SQL BI Skills
Pingback: Python | Check whether a string is palindrome or not | Improving my SQL BI Skills
Pingback: Python | Validate an IP Address-IPV6(Internet Protocol version 6) | Improving my SQL BI Skills
Pingback: Python | Count consecutive 1’s from a list | Improving my SQL BI Skills
Pingback: Python | The Print and Divide Puzzle | Improving my SQL BI Skills