Viewing 15 posts - 481 through 495 (of 10,144 total)
Just spent a business day prototyping a partition-switch mechanism to improve the performance of a weekly data feed of 50M rows into a 12,000,000,000 row table. It takes ten hours. Most...
January 3, 2018 at 10:11 am
-- Works for cnt <= 10
-- Expand the inline tally for cnt > 10
;WITH Process AS (
SELECT t2.*, t1.cnt,
rn = ROW_NUMBER() OVER(PARTITION BY...
January 3, 2018 at 9:41 am
January 3, 2018 at 7:12 am
-- SQL Server will perform the filter and the conversion in either order
-- Note that Compute Scalar is plonked...
January 2, 2018 at 10:16 am
IF OBJECT_ID('tempdb..#SampleData', N'U')...
December 14, 2017 at 1:36 am
Here's an alternative which is worth testing:
DECLARE @String
December 11, 2017 at 9:57 am
I'd do something like this:
--===== Drop Temp Tables to make runs in SSMS easier.
December 6, 2017 at 5:08 am
December 6, 2017 at 2:35 am
December 6, 2017 at 2:18 am
December 6, 2017 at 1:45 am
December 1, 2017 at 8:47 am
WHERE a.TransactionTime >= @startdate
and b.DateKey >=...
December 1, 2017 at 7:50 am
Make that join SARGable:
--However, if I move the date filter to the calendar table like so:
December 1, 2017 at 6:32 am
Viewing 15 posts - 481 through 495 (of 10,144 total)