All Articles

Below is the list of all the articles posted by me. Click on the links to read the complete article.

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