Viewing 15 posts - 346 through 360 (of 10,144 total)
April 23, 2018 at 2:34 am
April 23, 2018 at 1:52 am
We had, until recently, a weekly load of around 50 million rows into a table of 12,000,000,000 rows. It was taking about 8 hours, much of which was rebuilding the...
April 20, 2018 at 9:48 am
Free space in database files:
SELECT
[Logical Name]...
April 20, 2018 at 8:12 am
richardmgreen1 - Friday, April 20, 2018 7:19 AMMe neither, but the load process is uniform.
I'll fully agree the document is cr@p.
So...
April 20, 2018 at 7:25 am
April 19, 2018 at 6:48 am
The function DelimitedSplit8k is here.
;WITH MyTable AS (
SELECT * FROM ( VALUES
(1, 1001, 'Benjamin', '0'),
(2, 1002, 'Andy', '0:1001'),
(3, 1003,...
April 11, 2018 at 7:12 am
Hi Sam
Use DelimitedSplit8K to split the parameters out into rows in #temp tables, then join to those temp tables. Your query will also need OPTION(RECOMPILE)...
April 11, 2018 at 4:32 am
April 6, 2018 at 5:15 am
Thanks for the response.
I'd already tried something similar to that and it's returning the...
April 6, 2018 at 4:52 am
Variations on this theme usually work:
SELECT *
April 6, 2018 at 4:39 am
April 6, 2018 at 4:35 am
April 6, 2018 at 1:56 am
Something like this?SELECT e.*, '#' '#', x.*
FROM dbo.Employee e
OUTER APPLY (
SELECT TOP(1) d.*
FROM dbo.PHONE d
WHERE d.EMPLID = c.EMPLID
AND d.PHONETYPE IN ('HOME','CELL','PFVG')
April 6, 2018 at 1:49 am
Viewing 15 posts - 346 through 360 (of 10,144 total)