Viewing 15 posts - 1 through 15 (of 183 total)
I want to keep the child data but just clear out the parent table.
September 20, 2019 at 3:29 pm
The data type is int for all columns . yes order by col1. Also there can be consecutive null values. But all the consecutive null values will be updated to...
August 28, 2019 at 9:24 pm
Yes, the indexing on the FOREIGN KEY on the referencing tables did it. Thank you !
May 13, 2019 at 3:38 pm
It has scan to find the 1000 rows
code for the view
select top 200 key1 from [dbo].[Mytable1]
where key1 not in (select key1 from Mytable2)
order by Key1
--I was not ordering before still...
May 10, 2019 at 6:21 pm
Guras wrote:No, I am the only one running this query at the moment.
That doesn't mean there can't be another process locking your table.
No processes nothing. I am the...
May 10, 2019 at 5:56 pm
No, I am the only one running this query at the moment.
May 10, 2019 at 4:55 pm
February 26, 2019 at 2:19 pm
February 26, 2019 at 7:10 am
November 28, 2018 at 1:22 pm
;WITH myTable AS November 28, 2018 at 9:46 am
July 12, 2018 at 9:13 am
July 12, 2018 at 8:11 am
July 11, 2018 at 3:09 pm
July 11, 2018 at 3:06 pm
Viewing 15 posts - 1 through 15 (of 183 total)