Viewing 13 posts - 1 through 13 (of 13 total)
one last try....anyone?
January 25, 2021 at 1:13 pm
Does anybody have anything on this scenario?
January 21, 2021 at 3:09 pm
DECLARE @X int
DECLARE @I int
DECLARE @W int
DECLARE @SQL varchar(MAX)
DECLARE @Cols varchar(MAX)
DECLARE @FROM varchar(MAX)
DECLARE @WHERE varchar(MAX)
IF object_id('tempdb..#X') IS NOT NULL
BEGIN
DROP TABLE #X;
END
IF object_id('tempdb..#XX') IS NOT NULL
BEGIN
DROP TABLE #XX;
END
CREATE TABLE #X (
Id...
May 8, 2019 at 3:12 pm
yes, I can split the string into a table.
the number of values will not always be 3....I coded basically what you provided, but with dynamic SQL.
when there are more than...
May 8, 2019 at 2:54 pm
yes....optimize for adhoc is on
November 4, 2016 at 4:05 am
I am using SSMS.
IF object_id('tempdb..#X') IS NOT NULL
BEGIN
DROP TABLE #X;
END
--create temp table
CREATE TABLE #X (
sql_handle varbinary(64),
plan_handle varbinary(64),
statement_start_offset int,
statement_end_offset int,
query_hash binary(8),
query_plan_hash binary(8),
creation_time datetime,
last_execution_time datetime,
execution_count int,
AvgWorkerTime decimal(19,4),
AvgLogicalReads decimal(19,4),
SQL_Text varchar(max)
);
insert into #X...
August 26, 2015 at 10:15 am
This in NOT my code...this is NOT my company's code...it is code from a third party vendor.
StatementOptmLevel="FULL"
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1.1" Build="10.0.6000.29">
<BatchSequence>
<Batch>
...
August 26, 2015 at 6:57 am
Grant Fritchey (9/3/2014)
September 3, 2014 at 7:49 am
Grant Fritchey (9/3/2014)
September 3, 2014 at 7:25 am
Viewing 13 posts - 1 through 13 (of 13 total)