Viewing 9 posts - 1 through 9 (of 9 total)
Hi Experts ,
We have identified the process which has consumes the space in tempdb . The stored procedure uses a lot of temp tables in it . Does storing the...
September 25, 2020 at 10:59 am
Will it free the space temporary?
So in production its still happening and we needs a temporary solution for the time being. It will take us some time to fix the...
September 24, 2020 at 2:46 pm
Hi Guys ,
I have a very basic question regarding comparing 2 execution plans .
While comparing the execution plan i usually see Estimated sub tree cost of the left most operator...
June 10, 2020 at 4:09 pm
Hi Experts .
I have table Temp_decimal_mismatch which has duplicate data . The duplicate data is not straightforward to remove .
Here the row highlighted in yellow is a...
September 23, 2019 at 2:39 pm
As i cannot post the actual data and table structure. .I have created that table , so that i can post it in sql center portal .
September 23, 2019 at 2:04 pm
There is [TABLE_SCHEMA], [TABLE_NAME], [COLUMN_NAME], [datatype] is the pk
September 23, 2019 at 12:38 pm
/*
CREATE TABLE SampleData(
Cust_Name varchar(100),
Prd_Name varchar(100),
[1/1/2019] decimal(10, 4),
[2/1/2019] decimal(10, 4),
[3/1/2019] decimal(10, 4)
)
INSERT...
February 11, 2019 at 3:11 am
Hi,
Please find the attached UAT execution plan . I am not a dba can you please provide me a list of things that i should check.
January 17, 2019 at 9:44 am
Viewing 9 posts - 1 through 9 (of 9 total)