Viewing 15 posts - 1,861 through 1,875 (of 2,648 total)
I really like this script. Just been using it to create definitions or temporary tables that have been created using INTO #... which later had a problem with NULL columns...
December 20, 2018 at 9:13 am
December 18, 2018 at 8:06 am
December 18, 2018 at 7:21 am
December 17, 2018 at 7:37 pm
I need to...
December 17, 2018 at 4:36 pm
Try these and see what improvements or otherwise they make:CREATE INDEX IX_Edge_SessionId_EdgeID ON dbo.Edge(SessionId, EdgeID);
CREATE INDEX IX_Node_SessionId_NodeId ON dbo.Node(SessionId, NodeId);
CREATE INDEX IX_Weight_SessionId_NodeId ON dbo.Weight(SessionId, NodeId);
December 17, 2018 at 10:09 am
December 17, 2018 at 7:20 am
December 17, 2018 at 6:58 am
SELECT TOP(1) *
FROM myTable
WHERE LEGALDESCRIPTION IS NOT NULL
ORDER BY LEGALPARCELID, SEQUENCE_NO
December 17, 2018 at 6:35 am
SELECT *
INTO #t
FROM (VALUES
(1001, CONVERT(datetime,'2018-05-26 09:33'), 1),
(1001, '2018-05-26 08:44', 2),
(1002, '2018-05-28 08:22', 1),
(1002, '2018-05-28 12:44', 2),
(1001, '2018-05-21 07:44', 1),
December 17, 2018 at 6:30 am
December 17, 2018 at 4:07 am
Have you tried using 'nodes'?
December 16, 2018 at 8:55 am
December 14, 2018 at 7:58 am
December 14, 2018 at 5:26 am
Viewing 15 posts - 1,861 through 1,875 (of 2,648 total)