#sql
Read more stories on Hashnode
Articles with this tag
STRING_AGG is an aggregate function that takes all expressions from rows and concatenates them into a single string. FOR XML PATH is the previous...
Pros: No varchar<->datetime conversions required No need to think about the locale -- 2 day ago SELECT DATEADD(dd, 0, DATEDIFF(dd, 0,...
Place the name of the column you use with order by at the end of the index. Query : select ExceptionMessage, CreateDate from TableName where...
It is network related. Error is : The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be...
To view cache plan of AdHoc queries : SELECT cplan.plan_handle, cplan.usecounts, cplan.objtype, qtext.text ,qplan.query_plan FROM...
