Viewing 15 posts - 691 through 705 (of 10,144 total)
krishna83 - Friday, June 9, 2017 5:57 AMPlease find attached actual execution plan of the query.
This is an estimated plan. To get...
June 9, 2017 at 6:07 am
June 9, 2017 at 5:06 am
June 9, 2017 at 4:08 am
krishna83 - Friday, June 9, 2017 1:49 AMPlease find attached execution plan and post your suggestions here
Thanks for posting the plan, it's...
June 9, 2017 at 2:23 am
June 7, 2017 at 9:53 am
June 6, 2017 at 9:15 am
June 6, 2017 at 8:28 am
I have a table with out any indexes. If I am deleting & Inserting data...
June 6, 2017 at 6:27 am
June 6, 2017 at 5:10 am
SELECT
COUNTY.CountyName,
property.State.
x.UserDate2 AS LastCovered,
x.CompletedDate
FROM COUNTY COUNTY
INNER JOIN property property
ON COUNTY.CountyCode = property.County
CROSS APPLY (
SELECT TOP(1)
June 5, 2017 at 7:18 am
June 5, 2017 at 2:11 am
June 5, 2017 at 2:00 am
SELECT t.*
FROM @Table1 t
WHERE [Type] = 'Periodic'
OR
([Type] IS NULL AND NOT EXISTS (
SELECT 1
FROM @Table1 ti
WHERE ti.ID...
June 2, 2017 at 9:38 am
Viewing 15 posts - 691 through 705 (of 10,144 total)