Viewing 15 posts - 1,651 through 1,665 (of 2,645 total)
March 7, 2019 at 10:06 am
March 7, 2019 at 4:29 am
March 7, 2019 at 4:24 am
March 6, 2019 at 7:37 am
ChrisM@Work - Wednesday, March 6, 2019 5:28 AMToday's SSC Featured Contents includes a section on capturing live execution plans using Extended Events.
That's...
March 6, 2019 at 6:38 am
March 6, 2019 at 6:37 am
March 6, 2019 at 5:15 am
March 5, 2019 at 11:19 am
SELECT --TOP 10
t.query_sql_text,
q.query_id,
OBJECT_NAME(q.object_id) AS parent_object,
CONVERT(xml, P.query_plan),
Q.last_execution_time
FROM sys.query_store_query_text t
INNER JOIN...
March 5, 2019 at 10:42 am
Ideally you would have a primary key on your table, an identity column or somthing similar so you won't find the same row overlapping with itself:select t1.enrollid,
...
March 5, 2019 at 8:11 am
March 5, 2019 at 7:37 am
Your query looks ok, exists and not exists are fast methods of filtering.
A few of points:
I would give every table an alias and use it on every...
March 5, 2019 at 6:42 am
I can think of two ways to get the results you want:IF OBJECT_ID('tempdb..#tmpmaxgroup1') IS NOT NULL
DROP TABLE #tmpmaxgroup1;
;WITH CTE AS
(
...
March 4, 2019 at 2:11 pm
There are two issues here. The first one is identifying the correct group. Your English...
March 4, 2019 at 1:55 pm
March 4, 2019 at 9:53 am
Viewing 15 posts - 1,651 through 1,665 (of 2,645 total)