Search for a command to run...
Articles tagged with #sql
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 version of the STRING_AGG function : select a.NameSurname -- previous version , stuff((select ',' + x.Ph...
Pros: No varchar<->datetime conversions required No need to think about the locale -- 2 day ago SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(DAY, - 2, GETDATE()))) -- today SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
Place the name of the column you use with order by at the end of the index. Query : select ExceptionMessage, CreateDate from TableName where MethodName = 'ERROR' order by TerminalNo First index : CREATE NONCLUSTERED INDEX [IX_TableName_MethodName] ...
It is network related. Error is : The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. This failure occ...
To view cache plan of AdHoc queries : SELECT cplan.plan_handle, cplan.usecounts, cplan.objtype, qtext.text ,qplan.query_plan FROM sys.dm_exec_cached_plans AS cplan CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS qtext CROSS APPLY sys.dm_exec_query_p...
