Viewing 15 posts - 46 through 60 (of 1,228 total)
I have business logic for date comparisons that go beyond the typical DATEDIFF...
March 8, 2017 at 1:52 pm
I want to retrieve the ID value from CustomFields and insert into CustomID and get...
March 6, 2017 at 11:47 am
February 28, 2017 at 3:00 pm
February 28, 2017 at 2:54 pm
I am trying to help my DBA so that I get the DEBUGGER enabled ?...
February 20, 2017 at 1:37 pm
TH1239.CDB.LOCAL
TH1238.CDB.LOCAL
TH1237.CDB.LOCAL
TH1236.CDB.LOCAL
TSB1-TLA.CDB.LOCAL
TSB2-TLA.CDB.LOCAL
I would like to...
February 20, 2017 at 1:33 pm
February 20, 2017 at 1:12 pm
Here's a very simple alternative which also might work:SELECT
Srvname,
[status] = 'Failed',
MIN(run_dt),
MAX(run_dt),
grp = dd-rn,
ConsecutiveDays = COUNT(*)
FROM (
SELECT...
February 20, 2017 at 1:10 pm
Why not read the contacts table in one go?
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT
S.Id,
s.Id, -- S.ID = T.ID
x.AssignedContacts_Id,
x.OwnerType,
x.[Description]
FROM...
February 20, 2017 at 1:00 pm
Ethan.Hinton - Thursday, February 16, 2017 8:16 AMFor reference, here are the two query plans on PasteThePlan:Query_that_completed_40_minutes: https://www.brentozar.com/pastetheplan/?id=SJklWSXFl
Query_not_finishing_still_running: https://www.brentozar.com/pastetheplan/?id=S1OmbS7Fl
Same...
February 16, 2017 at 2:16 pm
Hi,
I agree on the comments that MAXDOP is not the solution or that CXPACKETS is...
February 13, 2017 at 1:51 pm
Hi,
This query is coming from an application that I cannot modify. I am manually running...
February 11, 2017 at 6:30 am
I want to write a recursive statement to...
February 8, 2017 at 2:09 pm
February 4, 2017 at 8:12 am
Viewing 15 posts - 46 through 60 (of 1,228 total)