| 199 |
How to get Day of Year from date in Sql Server |
| 198 |
Do we need to include a Clustered Index Column too in a Non-Clustered Index to make it as a Covering Index for a Query? Tip 7: Sql Server 101 Performance Tuning Tips and Tricks |
| 197 |
How to Inspect the content of a DATA PAGE or INDEX PAGE ? Tip 6: Sql Server 101 Performance Tuning Tips and Tricks |
| 196 |
How to get an Index’s Root Page, Intermediate Pages and Leaf Pages Information? Tip 5: Sql Server 101 Performance Tuning Tips and Tricks |
| 195 |
How to find the list of all Pages that belongs to a Table and Index? Tip 4: Sql Server 101 Performance Tuning Tips and Tricks |
| 194 |
Does the order of Columns in a Composite Index matters? Tip 3: Sql Server 101 Performance Tuning Tips and Tricks |
| 193 |
Evils of using function on an Index Column in the WHERE clause– Tip 2: Sql Server 101 Performance Tuning Tips and Tricks |
| 192 |
Implicit conversion an evil for Index – Tip 1: Sql Server 101 Performance Tuning Tips and Tricks |
| 191 |
Difference between INT and BIGINT data type in Sql Server |
| 190 |
Difference between SMALLINT and INT data type in Sql Server |
| 189 |
Difference between TINYINT and SMALLINT data type in Sql Server |
| 188 |
Difference between TINYINT and INT data type in Sql Server |
| 187 |
How to Split a String in Sql Server without using a function |
| 186 |
CREATE OR ALTER DDL Statement in Sql Server 2016 SP1 |
| 185 |
OUTER APPLY in Sql Server |
| 184 |
CROSS APPLY in Sql Server |
| 183 |
SQL Server APPLY operator |
| 182 |
Difference between LEFT JOIN and LEFT OUTER JOIN in Sql Server |
| 181 |
Difference between RIGHT JOIN and RIGHT OUTER JOIN in Sql Server |
| 180 |
Difference between JOIN and INNER JOIN in Sql Server |
| 179 |
Sql Server Error: Incorrect time syntax in time string used with WAITFOR |
| 178 |
SLEEP Command in Sql Server |
| 177 |
Sql Server Error: A fatal scripting error occurred. Incorrect syntax was encountered while parsing GO |
| 176 |
GO Statement in Sql Server |
| 175 |
Difference between SMALLDATETIME and DATETIME Data Types in Sql Server |
| 174 |
Error Logs Maintenance in Sql Server |
| 173 |
How to get User, System and All Databases name in Sql Server |
| 172 |
How to change Sql Server ErrorLog files location |
| 171 |
How to find the location of the Sql Server Error Log File |
| 170 |
How to get Sql Server Version, Edition, Product Level etc |
| 169 |
How to get current TIME in Sql Server |
| 168 |
How to get Current DATE and TIME in Sql Server |
| 167 |
TRIM function in Sql Server |
| 166 |
How to Split comma or any other character delimited string into a Table in Sql Server |
| 165 |
100 Frequently used queries in Sql Server – Part 1 |
| 164 |
PRINT Statement in Sql Server |
| 163 |
Differences Between Sql Server TEXT and VARCHAR(MAX) Data Type |
| 162 |
How to check if an Index exists in Sql Server |
| 161 |
How to check if a Trigger exists in Sql Server |
| 160 |
How to check if a Function exists in Sql Server |
| 159 |
Page allocation changes in Sql Server 2016 |
| 158 |
Query Store in Sql Server 2016 |
| 157 |
JSON_MODIFY Function in Sql Server 2016 |
| 156 |
STRING_SPLIT function in Sql Server 2016 |
| 155 |
Logon Triggers in Sql Server |
| 154 |
Data Definition Language (DDL) Triggers in Sql Server |
| 153 |
Data Manipulation Language (DML) Triggers in Sql Server |
| 152 |
Triggers in Sql Server |
| 151 |
INSERTED and DELETED Logical Tables in Sql Server |
| 150 |
Dynamic Data Masking in Sql Server 2016 |
| 149 |
Row level security in Sql Server 2016 |
| 148 |
New Features in Sql Server 2016 |
| 147 |
Temporal Tables in Sql Server 2016 Part 4: DDL operations on the System-Versioned Temporal Table |
| 146 |
Temporal Tables in Sql Server 2016 Part 3: Enabling System Versioning for an Existing Regular Table |
| 145 |
Temporal Tables in Sql Server 2016 Part 2: Querying System-Versioned Temporal Table |
| 144 |
Temporal Tables in Sql Server 2016 Part 1: Introduction to Temporal Tables and DML operations on the Temporal Table |
| 143 |
GZIP COMPRESS and DECOMPRESS functions in Sql Server 2016 |
| 142 |
SESSION_CONTEXT in Sql Server 2016 |
| 141 |
Difference between DATEDIFF and DATEDIFF_BIG functions in Sql Server |
| 140 |
DATEDIFF_BIG Function in Sql Server 2016 |
| 139 |
Live Query Statistics in Sql Server 2016 |
| 138 |
Compare Execution Plans in Sql Server 2016 |
| 137 |
Indexing Strategy for JSON Value in Sql Server 2016 |
| 136 |
OPENJSON Function in Sql Server 2016 |
| 135 |
Sql Server 2016 |
| 134 |
ISJSON Function in Sql Server 2016 |
| 133 |
FOR JSON Clause in Sql Server 2016 |
| 132 |
lax and strict JSON Path modes in Sql Server 2016 |
| 131 |
JSON_QUERY Function in Sql Server 2016 |
| 130 |
JSON_VALUE Function in Sql Server 2016 |
| 129 |
DROP IF EXISTS Statement in Sql Server 2016 |
| 128 |
Native JSON Support in Sql Server 2016 |
| 127 |
Data Paging by OFFSET…FECTCH and CTE – Sql Server |
| 126 |
Nested Common Table Expressions (i.e. CTE) – Sql Server |
| 125 |
Multiple CTEs in a Single Query – Sql Server |
| 124 |
Recursive CTE – Sql Server |
| 123 |
Introduction to Common Table Expression (a.k.a CTE) in Sql Server |
| 122 |
How to check if a Database exists in Sql Server |
| 121 |
Difference between Sequence and Identity in Sql Server |
| 120 |
How to get all the Tables with or without an Identity column in Sql Server? |
| 119 |
Difference between Len() and Datalength() functions in Sql Server |
| 118 |
How to get difference between two dates in Years, Months and days in Sql Server |
| 117 |
How to get Yearly data in Sql Server |
| 116 |
How to get Daily data in Sql Server |
| 115 |
How to get Hourly data in Sql Server |
| 114 |
How to check if a VIEW exists in Sql Server |
| 113 |
How to check if a record exists in table in Sql Server |
| 112 |
Must declare the scalar variable – Error Message 137 |
| 111 |
Msg 128, Level 15, State 1, Line 1 The name “%.*s” is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitte |
| 110 |
WHILE loop in Sql Server |
| 109 |
Looping through table records in Sql Server |
| 108 |
How to rename column name in Sql Server |
| 107 |
How to Subtract Days, Weeks, Months, Quarters or Years from Date in Sql Server |
| 106 |
How to get Day or Weekday name from date in Sql Server |
| 105 |
How to get month name from date in Sql Server |
| 104 |
How to replace NULL value by 0 in the Dynamic Pivot result – Sql Server |
| 103 |
How to STOP or ABORT or BREAK the execution of the statements in the current batch and in the subsequent batches separated by GO Statement based on some condition in SQL SERVER |
| 102 |
ERROR: ‘INT’ is not a recognized CURSOR option -Sql Server |
| 101 |
STUFF Function in Sql Server |
| 100 |
A-Z of Filtered Indexes with examples in Sql Server |
| 99 |
Truncate all/all except few/specified Tables of a Database in Sql Server |
| 98 |
Cannot truncate table ‘xyz’ because it is being referenced by a FOREIGN KEY constraint – Sql Server |
| 97 |
How to check if Temp table exists in Sql Server? |
| 96 |
SINGLE_USER, RESTRICTED_USER and MULTI_USER user access modes in SQL SERVER |
| 95 |
EXECUTE/EXEC Stored Procedure/Function Statement may raise an error like: ‘Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’.’ if GetDate() like function is used in it – Sql Server |
| 94 |
How to add Hours, Minutes, Seconds to a DateTime in Sql Server |
| 93 |
How to add Days, Weeks, Months, Quarters or Years to a Date in Sql Server |
| 92 |
How to find whether a Table is referenced by the Foreign Key constraint defined in another Table – sql server |
| 91 |
How to check if a Stored Procedure exists in Sql Server |
| 90 |
How to check if a Table exists in Sql Server |
| 89 |
Dynamic PIVOT in Sql Server |
| 88 |
PIVOT and UNPIVOT in Sql Server |
| 87 |
How to get Monthly Data in Sql Server |
| 86 |
How to get Quarterly Data in Sql Server |
| 85 |
How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server |
| 84 |
Comparative Analysis of Temporary Table and Table Variable based on the aspects like User Defined Functions, Indexes and Scope in Sql Server |
| 83 |
Comparative Analysis of Temporary Table and Table Variable based on the aspects like Syntax, Storage Location and Transactions in Sql Server |
| 82 |
Difference Between Temporary Table and Table Variable in Sql Server |
| 81 |
Querying Data Using SELECT In Sql Server |
| 80 |
How to get Day, Month and Year Part from DateTime in Sql Server |
| 79 |
Joins In Sql Server |
| 78 |
Working with Tables in Sql Server |
| 77 |
Working with Databases in Sql Server |
| 76 |
Variables and Data Types in Sql Server |
| 75 |
Sql Server Tutorial |
| 74 |
Exception Handling Template for Stored Procedure – In Sql Server |
| 73 |
TRY…CATCH In Sql Server |
| 72 |
Exception Handling in Sql Server |
| 71 |
Working with In-Memory OLTP (a.k.a. Hekaton) enabled Databases, Memory Optimized Tables and Natively Compiled Stored Procedures and it’s Internals with extensive list of Examples – Sql Server 2014 |
| 70 |
Myths and Facts about In-Memory OLTP (a.k.a. Hekaton) – Sql Server 2014 |
| 69 |
Sql Server 2008 |
| 68 |
Sql Server 2014 |
| 67 |
Sql Server 2012 |
| 66 |
Why the prefix N is used for literal strings in Sql Server? |
| 65 |
Introduction to In-Memory OLTP (a.k.a. Hekaton) – Sql Server 2014 |
| 64 |
PRINT/SELECT Statement messages within WHILE LOOP or BATCH of statement is not displayed immediately after it’s execution- Sql Server |
| 63 |
How to Check if a String Contains a Substring in it in Sql Server |
| 62 |
How to get All the Tables which are Modified in last few days in Sql Server? |
| 61 |
How to get all the records which contain double byte data or all the records which contain single byte data in Sql Server? |
| 60 |
Joining Two Tables without any Common Column between them – Sql Server |
| 59 |
Sequence Cache management and Internals – Sql Server 2012 |
| 58 |
SEQUENCE Limitations and restrictions – Sql Server 2012 |
| 57 |
How to get all the Tables with or without Non-Clustered Indexes in Sql Server? |
| 56 |
How to find all the tables with no indexes at all in Sql Server? |
| 55 |
How to get all the Tables with or without Primary Key Constraint in Sql Server? |
| 54 |
How to get all HEAP Tables or Tables without Clustered Index in Sql Server? |
| 53 |
How to find all the filtered indexes or all the tables having filtered indexes in Sql Server? |
| 52 |
How to find all the indexes that have included columns in it and the name of the table to which the index belongs to? |
| 51 |
How to get Quarter’s Start and End Date for a given date in Sql Server |
| 50 |
How to get Date Part only from DateTime in Sql Server |
| 49 |
New Features in Sql Server 2012 |
| 48 |
EXECUTE WITH RESULT SETS IN SQL SERVER 2012 |
| 47 |
Differences Between RAISERROR and THROW in Sql Server |
| 46 |
DATETIMEFROMPARTS FUNCTION IN SQL SERVER 2012 |
| 45 |
SMALLDATETIMEFROMPARTS FUNCTION IN SQL SERVER 2012 |
| 44 |
DATEFROMPARTS FUNCTION IN SQL SERVER 2012 |
| 43 |
FORMAT STRING FUNCTION IN SQL SERVER 2012 |
| 42 |
EOMONTH FUNCTION IN SQL SERVER 2012 |
| 41 |
CHOOSE LOGICAL FUNCTION IN SQL SERVER 2012 |
| 40 |
IIF() LOGICAL FUNCTION IN SQL SERVER 2012 |
| 39 |
Microsoft Announces SQL Server 2014 |
| 38 |
TRY_PARSE CONVERSION FUNCTION IN SQL SERVER 2012 |
| 37 |
PARSE CONVERSION FUNCTION IN SQL SERVER 2012 |
| 36 |
TRY_CONVERT CONVERSION FUNCTION IN SQL SERVER 2012 |
| 35 |
Difference Between Primary Key and Unique Key In Sql Server |
| 34 |
How to find all tables that have specified column name in Sql Server? |
| 33 |
How to find all dependencies of a table in Sql Server? |
| 32 |
How to find referenced/dependent objects (like Table, Function etc) of a Stored Procedure/Function in Sql Server? |
| 31 |
sp_depends results are not reliable |
| 30 |
How to Insert Stored Procedure result into a table in Sql Server? |
| 29 |
Sequence in Sql Server 2012 |
| 28 |
Difference Between Sql Server VARCHAR and VARCHAR(MAX) Data Type |
| 27 |
CONCAT() STRING FUNCTION IN SQL Server 2012 |
| 26 |
Difference between Stored Procedure and User Defined Function in Sql Server |
| 25 |
SET Options with their setting values required while working with filtered index |
| 24 |
How to set default database in Sql Server Mangement Studio. A Time Saving Tip |
| 23 |
How to Calculate Age in Sql Server |
| 22 |
Simple Quiz On Sql Server Select statement |
| 21 |
INSERT/UPDATE failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’ … |
| 20 |
Sql Server’s DATEADD function may return different result in a scenario where we are adding one month at a time from adding multiple months at a time to the date. |
| 19 |
SET ANSI_NULLS ON/OFF Setting in Sql Server |
| 18 |
Difference Between Sql Server VARCHAR and NVARCHAR Data Type |
| 17 |
Difference Between SET QUOTED_IDENTIFIER ON and OFF setting in SQL Server |
| 16 |
SET QUOTED_IDENTIFIER ON/OFF Setting in Sql Server |
| 15 |
Sparse Columns in SQL Server 2008 |
| 14 |
Difference between Sql Server Char and Varchar Data Type |
| 13 |
GO Statement can also be used to excute batch of T-Sql statement multiple times |
| 12 |
How to find all the Stored Procedures having a given text in it? |
| 11 |
Merge Statement in Sql Server 2008 |
| 10 |
Difference between DateTime and DateTime2 DataType |
| 9 |
New Features in Sql Server 2008 |
| 8 |
Table-Valued Parameters in Sql Server |
| 7 |
UNION AND UNION ALL Operator |
| 6 |
Usage of OR Boolean Operator/CASE Statement in WHERE Clause Leads to Index/Table Scan |
| 5 |
Usage of Function on Index Column in WHERE Caluse Leads to Index/Table Scan |
| 4 |
Implicit Conversion Leading to Index/Table Scan |
| 3 |
Views in Sql Server |
| 2 |
Stored Procedure |
| 1 |
User-Defined Functions |