SqlHints.com By Basavaraj Biradar
follow
https://sqlhints.com/
Skip to content
follow
#content
Performance Tuning
follow
https://sqlhints.com/performance-tuning/
Sql Server Tutorial
follow
https://sqlhints.com/tutorialsqlserver/
Sql 2008
follow
https://sqlhints.com/sql-server-2008/
Sql 2012
follow
https://sqlhints.com/sql-server-2012/
Sql 2014
follow
https://sqlhints.com/sql-server-2014/
Sql 2016
follow
https://sqlhints.com/sql-server-2016/
All Articles
follow
https://sqlhints.com/all-articles/
ABOUT BASAVARAJ
follow
https://sqlhints.com/about/
Indexes in Sql Server – Part I
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/
June 29, 2020
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/
101 Performance Tuning Tips and Tricks
follow
https://sqlhints.com/category/101-performance-tuning-tips-and-tricks/
Index
follow
https://sqlhints.com/category/index/
Performance Optimization
follow
https://sqlhints.com/category/sql-server/performance-optimization/
Sql Server
follow
https://sqlhints.com/category/sql-server/
Sql Server Tutorial
follow
https://sqlhints.com/category/sql-server/sql-server-tutorial/
Actual Execution Plan
follow
https://sqlhints.com/tag/actual-execution-plan/
Execution Plan
follow
https://sqlhints.com/tag/execution-plan/
HEAP TABLE IN SQL SERVER
follow
https://sqlhints.com/tag/heap-table-in-sql-server/
Indexes
follow
https://sqlhints.com/tag/indexes/
Indexes in Sql Server
follow
https://sqlhints.com/tag/indexes-in-sql-server/
Performance optimization
follow
https://sqlhints.com/tag/performance-optimization/
SET STATISTICS IO
follow
https://sqlhints.com/tag/set-statistics-io/
SET STATISTICS TIME ON
follow
https://sqlhints.com/tag/set-statistics-time-on/
Sql
follow
https://sqlhints.com/tag/sql/
Sql Server
follow
https://sqlhints.com/tag/sql-server/
Sql Server Indexes
follow
https://sqlhints.com/tag/sql-server-indexes/
Sql Server Tutorial
follow
https://sqlhints.com/tag/sql-server-tutorial/
Basavaraj Biradar
follow
https://sqlhints.com/author/sqlhints/
Click to share on Facebook (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=facebook
Click to share on LinkedIn (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=linkedin
Click to share on Twitter (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=twitter
Click to email this to a friend (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=email
Click to print (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/
Click to share on Reddit (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=reddit
Click to share on Tumblr (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=tumblr
Click to share on Pocket (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=pocket
Click to share on Pinterest (Opens in new window)
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/?share=pinterest
Leave a comment
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/#respond
How to get the Length of a String in Sql Server?
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/
February 29, 2020
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/
Sql Server
follow
https://sqlhints.com/category/sql-server/
LEN Function
follow
https://sqlhints.com/tag/len-function/
Length of a string
follow
https://sqlhints.com/tag/length-of-a-string/
Length of a string in Sql Server
follow
https://sqlhints.com/tag/length-of-a-string-in-sql-server/
Number of characters in a string
follow
https://sqlhints.com/tag/number-of-characters-in-a-string/
Number of characters in a string Sql Server
follow
https://sqlhints.com/tag/number-of-characters-in-a-string-sql-server/
Sql
follow
https://sqlhints.com/tag/sql/
SQL LEN() Function
follow
https://sqlhints.com/tag/sql-len-function/
Sql Server
follow
https://sqlhints.com/tag/sql-server/
Basavaraj Biradar
follow
https://sqlhints.com/author/sqlhints/
Difference between Len() and Datalength() functions in Sql Server
follow
https://sqlhints.com/2015/07/18/difference-between-len-and-datalength-functions-in-sql-server/
Click to share on Facebook (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=facebook
Click to share on LinkedIn (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=linkedin
Click to share on Twitter (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=twitter
Click to email this to a friend (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=email
Click to print (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/
Click to share on Reddit (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=reddit
Click to share on Tumblr (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=tumblr
Click to share on Pocket (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=pocket
Click to share on Pinterest (Opens in new window)
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/?share=pinterest
One comment so far
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/#comments
How to get Day of Year from date in Sql Server
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/
September 1, 2018
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/
Sql Server
follow
https://sqlhints.com/category/sql-server/
Day of Year
follow
https://sqlhints.com/tag/day-of-year/
Day of Year From Date
follow
https://sqlhints.com/tag/day-of-year-from-date/
Day of Year From Date in Sql Server
follow
https://sqlhints.com/tag/day-of-year-from-date-in-sql-server/
Day of Year in Sql
follow
https://sqlhints.com/tag/day-of-year-in-sql/
Sql
follow
https://sqlhints.com/tag/sql/
Sql Server
follow
https://sqlhints.com/tag/sql-server/
Basavaraj Biradar
follow
https://sqlhints.com/author/sqlhints/
follow
https://sqlhints.com/wp-content/uploads/2018/09/Day-of-Year-using-DatePart-function-in-Sql.jpg
follow
https://sqlhints.com/wp-content/uploads/2018/09/Day-of-Year-using-DATENAME-function-in-Sql.jpg
follow
https://sqlhints.com/wp-content/uploads/2018/09/Example-Day-of-Year-using-DatePart-function-in-Sql.jpg
Click to share on Facebook (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=facebook
Click to share on LinkedIn (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=linkedin
Click to share on Twitter (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=twitter
Click to email this to a friend (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=email
Click to print (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/
Click to share on Reddit (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=reddit
Click to share on Tumblr (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=tumblr
Click to share on Pocket (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=pocket
Click to share on Pinterest (Opens in new window)
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/?share=pinterest
Leave a comment
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/#respond
← Older posts
follow
https://sqlhints.com/page/2/
follow
https://www.facebook.com/sqlhints
Sqlhints.com Privacy Policy
follow
https://sqlhints.com/privacy-policy/
Varchar vs NVarchar
follow
https://sqlhints.com/2011/12/23/difference-between-varchar-and-nvarchar/
Varchar vs Varchar(MAX)
follow
https://sqlhints.com/2013/03/10/difference-between-sql-server-varchar-and-varcharmax-data-type/
Char vs Varchar
follow
https://sqlhints.com/2011/10/23/difference-between-sql-server-char-and-varchar-data-type/
Text vs Varchar(Max)
follow
https://sqlhints.com/2016/05/11/differences-between-sql-server-text-and-varcharmax-data-type/
Union vs Union All
follow
https://sqlhints.com/2011/09/04/union-and-union-all-operator/
DateTime vs DateTime2
follow
https://sqlhints.com/2011/09/17/difference-between-datetime-and-datetime2-datatype/
SET QUOTED_IDENTIFIER ON vs SET QUOTED_IDENTIFIER OFF
follow
https://sqlhints.com/2011/12/22/difference-between-set-quoted_identifiers-on-and-off-settings/
Stored Procedure vs User Defined Function
follow
https://sqlhints.com/2012/06/16/difference-between-stored-procedure-and-user-defined-function-in-sql-server/
Primary Key vs Unique Key
follow
https://sqlhints.com/2013/06/02/difference-between-primary-key-and-unique-key-in-sql-server/
RAISERROR vs THROW
follow
https://sqlhints.com/2013/06/30/differences-between-raiserror-and-throw-in-sql-server/
Temporary Table vs Table Variable
follow
https://sqlhints.com/2014/02/10/difference-between-temporary-table-and-table-variable-in-sql-server/
Len() vs Datalength()
follow
https://sqlhints.com/2015/07/18/difference-between-len-and-datalength-functions-in-sql-server/
Sequence vs Identity
follow
https://sqlhints.com/2015/08/01/difference-between-sequence-and-identity-in-sql-server/
DATEDIFF vs DATEDIFF_BIG
follow
https://sqlhints.com/2015/12/12/difference-between-datediff-and-datediff_big-functions-in-sql-server/
LEFT JOIN vs LEFT OUTER JOIN
follow
https://sqlhints.com/2016/10/15/difference-between-left-join-and-left-outer-join-in-sql-server/
RIGHT JOIN vs RIGHT OUTER JOIN
follow
https://sqlhints.com/2016/10/15/difference-between-right-join-and-right-outer-join-in-sql-server/
JOIN vs INNER JOIN
follow
https://sqlhints.com/2016/10/14/difference-between-join-and-inner-join-in-sql-server/
LEFT OUTER JOIN vs RIGHT OUTER JOIN
follow
https://sqlhints.com/2016/10/15/difference-between-left-outer-join-and-right-outer-join-in-sql-server/
SMALLDATETIME vs DATETIME
follow
https://sqlhints.com/2016/10/10/difference-between-smalldatetime-and-datetime-data-types-in-sql-server/
101 Performance Tuning Tips and Tricks
follow
https://sqlhints.com/category/101-performance-tuning-tips-and-tricks/
C#
follow
https://sqlhints.com/category/c/
Index
follow
https://sqlhints.com/category/index/
Sql Server
follow
https://sqlhints.com/category/sql-server/
CONSTRAINTS
follow
https://sqlhints.com/category/sql-server/constraints-sql-server/
Differences
follow
https://sqlhints.com/category/sql-server/differences/
DMVS
follow
https://sqlhints.com/category/sql-server/dmvs/
Errors
follow
https://sqlhints.com/category/sql-server/errors/
Exception Handling
follow
https://sqlhints.com/category/sql-server/exception-handling/
Performance Optimization
follow
https://sqlhints.com/category/sql-server/performance-optimization/
Common Mistakes
follow
https://sqlhints.com/category/sql-server/performance-optimization/common-mistakes/
Scripts
follow
https://sqlhints.com/category/sql-server/scripts/
Sql Server 2005
follow
https://sqlhints.com/category/sql-server/sql-server-2005/
SQL Server 2008 What"s New
follow
https://sqlhints.com/category/sql-server/sql-server-2008-whats-new/
Sql Server 2012
follow
https://sqlhints.com/category/sql-server/sql-server-2012-sql-server/
Functions
follow
https://sqlhints.com/category/sql-server/sql-server-2012-sql-server/functions/
Conversion Functions
follow
https://sqlhints.com/category/sql-server/sql-server-2012-sql-server/functions/conversion-functions/
Date and Time Functions
follow
https://sqlhints.com/category/sql-server/sql-server-2012-sql-server/functions/date-and-time-functions/
Logical Functions
follow
https://sqlhints.com/category/sql-server/sql-server-2012-sql-server/functions/logical-functions/
String Functions
follow
https://sqlhints.com/category/sql-server/sql-server-2012-sql-server/functions/string-functions-functions/
Sql Server 2014
follow
https://sqlhints.com/category/sql-server/sql-server-2014/
Hekaton
follow
https://sqlhints.com/category/sql-server/sql-server-2014/hekaton/
In-Memory OLTP
follow
https://sqlhints.com/category/sql-server/sql-server-2014/in-memory-oltp/
Sql Server 2016
follow
https://sqlhints.com/category/sql-server/sql-server-2016/
Sql Server Tutorial
follow
https://sqlhints.com/category/sql-server/sql-server-tutorial/
Stored Procedure
follow
https://sqlhints.com/category/sql-server/stored-procedure/
System Stored Procedures
follow
https://sqlhints.com/category/sql-server/system-stored-procedures/
Tips/Tricks
follow
https://sqlhints.com/category/sql-server/tipstricks/
User Defined Function
follow
https://sqlhints.com/category/sql-server/user-defined-function/
Views
follow
https://sqlhints.com/category/sql-server/views/
Variables and Data Types
follow
https://sqlhints.com/2014/01/26/variables-and-data-types-in-sql-server/
Working with Databases
follow
https://sqlhints.com/2014/01/26/working-with-databases-in-sql-server/
Working with Tables
follow
https://sqlhints.com/2014/01/27/working-with-tables-in-sql-server/
Constraints - PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK, and DEFAULT
follow
https://sqlhints.com/2013/06/02/difference-between-primary-key-and-unique-key-in-sql-server/
UNION AND UNION ALL
follow
https://sqlhints.com/2011/09/04/union-and-union-all-operator/
Stored Procedures
follow
https://sqlhints.com/2011/08/14/stored-procedure/
User Defined Functions
follow
https://sqlhints.com/2011/08/14/user-defined-functions/
Views
follow
https://sqlhints.com/2011/08/20/views-in-sql-server/
Exception Handling
follow
https://sqlhints.com/2014/01/20/exception-handling-in-sql-server/
New Features in Sql Server 2008
follow
https://sqlhints.com/2011/09/11/new-features-in-sql-server-2008/
New Features in Sql Server 2012
follow
https://sqlhints.com/2013/07/07/new-features-in-sql-server-2012/
New Features in Sql Server 2014
follow
https://sqlhints.com/sql-server-2014/
Indexes in Sql Server – Part I
follow
https://sqlhints.com/2020/06/29/indexes-in-sql-server-part-i/
How to get the Length of a String in Sql Server?
follow
https://sqlhints.com/2020/02/29/how-to-get-the-length-of-a-string-in-sql-server/
How to get Day of Year from date in Sql Server
follow
https://sqlhints.com/2018/09/01/how-to-get-day-of-year-from-date-in-sql-server/
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
follow
https://sqlhints.com/2018/05/06/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/
How to Inspect the content of a DATA PAGE or INDEX PAGE ? Tip 6: Sql Server 101 Performance Tuning Tips and Tricks
follow
https://sqlhints.com/2018/05/05/how-to-inspect-the-content-of-a-data-page-or-index-page-tip-6-sql-server-101-performance-tuning-tips-and-tricks/
How to get an Index’s Root Page, Intermediate Pages and Leaf Pages Information? Tip 5: Sql Server 101 Performance Tuning Tips and Tricks
follow
https://sqlhints.com/2018/05/03/how-to-get-an-indexs-root-page-intermediate-pages-and-leaf-pages-information-tip-5-sql-server-101-performance-tuning-tips-and-tricks/
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
follow
https://sqlhints.com/2018/04/30/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/
Does the order of Columns in a Composite Index matters? Tip 3: Sql Server 101 Performance Tuning Tips and Tricks
follow
https://sqlhints.com/2017/10/01/does-the-order-of-columns-in-a-composite-index-matters-tip-3-sql-server-101-performance-tuning-tips-and-tricks/
Evils of using function on an Index Column in the WHERE clause– Tip 2: Sql Server 101 Performance Tuning Tips and Tricks
follow
https://sqlhints.com/2017/09/10/evils-of-using-function-on-an-index-column-in-the-where-clause-tip-2-sql-server-101-performance-tuning-tips-and-tricks/
Implicit conversion an evil for Index – Tip 1: Sql Server 101 Performance Tuning Tips and Tricks
follow
https://sqlhints.com/2017/09/02/implicit-conversion-an-evil-for-index-tip-1-sql-server-101-performance-tuning-tips-and-tricks/
APPLY in SQL
follow
https://sqlhints.com/tag/apply-in-sql/
Common Table Expression
follow
https://sqlhints.com/tag/common-table-expression/
Conversion Functions
follow
https://sqlhints.com/tag/conversion-functions/
CTE
follow
https://sqlhints.com/tag/cte/
DATEADD
follow
https://sqlhints.com/tag/dateadd/
Date and Time Functions
follow
https://sqlhints.com/tag/date-and-time-functions/
Error Message
follow
https://sqlhints.com/tag/error-message/
Filtered Index
follow
https://sqlhints.com/tag/filtered-index/
Foreign Key Constraint
follow
https://sqlhints.com/tag/foreign-key-constraint/
FORMAT
follow
https://sqlhints.com/tag/format/
Hekaton
follow
https://sqlhints.com/tag/hekaton/
JSON
follow
https://sqlhints.com/tag/json/
JSON in Sql
follow
https://sqlhints.com/tag/json-in-sql/
JSON in Sql Server
follow
https://sqlhints.com/tag/json-in-sql-server/
JSON in Sql Server 2016
follow
https://sqlhints.com/tag/json-in-sql-server-2016/
Msg 13608
follow
https://sqlhints.com/tag/msg-13608/
New Feature in Sql Server 2012
follow
https://sqlhints.com/tag/new-feature-in-sql-server-2012/
OBJECT_ID()
follow
https://sqlhints.com/tag/object_id/
Performance
follow
https://sqlhints.com/tag/performance/
Performance Tuning
follow
https://sqlhints.com/tag/performance-tuning/
Performance Tuning Tips and Tricks
follow
https://sqlhints.com/tag/performance-tuning-tips-and-tricks/
PIVOT
follow
https://sqlhints.com/tag/pivot/
Sequence
follow
https://sqlhints.com/tag/sequence/
Sql
follow
https://sqlhints.com/tag/sql/
Sql 101 Performance Tuning
follow
https://sqlhints.com/tag/sql-101-performance-tuning/
Sql 2016
follow
https://sqlhints.com/tag/sql-2016/
Sql Common Table Expression
follow
https://sqlhints.com/tag/sql-common-table-expression/
Sql CTE
follow
https://sqlhints.com/tag/sql-cte/
Sql Server
follow
https://sqlhints.com/tag/sql-server/
Sql Server 2008
follow
https://sqlhints.com/tag/sql-server-2008/
SQL SERVER 2012
follow
https://sqlhints.com/tag/sql-server-2012/
SQL SERVER 2014
follow
https://sqlhints.com/tag/sql-server-2014-2/
Sql Server 2014 CTP2
follow
https://sqlhints.com/tag/sql-server-2014-ctp2/
Sql Server 2016
follow
https://sqlhints.com/tag/sql-server-2016/
Sql Server Performance Tips and Tricks
follow
https://sqlhints.com/tag/sql-server-performance-tips-and-tricks/
Sql Server Performance Tuning Tip
follow
https://sqlhints.com/tag/sql-server-performance-tuning-tip/
Sql Server Tutorial
follow
https://sqlhints.com/tag/sql-server-tutorial/
Stored Procedure
follow
https://sqlhints.com/tag/stored-procedure/
sys.objects
follow
https://sqlhints.com/tag/sys-objects/
sys.sysobjects
follow
https://sqlhints.com/tag/sys-sysobjects/
System Versioned Table
follow
https://sqlhints.com/tag/system-versioned-table/
System Versioned Temporal Table
follow
https://sqlhints.com/tag/system-versioned-temporal-table/
Temporal Table
follow
https://sqlhints.com/tag/temporal-table/
TIps/Tricks
follow
https://sqlhints.com/tag/tipstricks-2/
VARCHAR
follow
https://sqlhints.com/tag/varchar/
Proudly powered by WordPress
follow
https://wordpress.org/