Viewing 15 posts - 541 through 555 (of 6,036 total)
July 24, 2018 at 6:35 am
July 24, 2018 at 5:24 am
July 23, 2018 at 7:37 pm
Yep... understood. I just want to know if I need to relearn a...
July 23, 2018 at 6:53 pm
I'm curious as to how this will affect dates prior to 1753 mentioned in history books.
Dates prior to 1753 defined by different calendars.
Using extrapolation of Grigorian calendar to that...
July 23, 2018 at 3:52 pm
Department of Homeland Security encourages cellphone and internet service providers to retain detailed records, as well as making them easily accessible.
How about the "right to be forgotten"?
July 21, 2018 at 6:37 pm
SELECT ..., t3.ValueList
from [dbo].[GEMS_CIX_EQ_C] t2
Cross apply ( select STUFF(....) from [dbo].[GEMS_CIX_EQ_C] t1
Where ....
) t3 (ValueList)
Group by ...
July 18, 2018 at 8:17 pm
I would ask "why?"
Why do you need to load 1 billion records regularly?
Is it a "refresh data" task?
July 18, 2018 at 2:33 pm
That's because you're using a correlated subquery in SELECT part of the query.
Try to make it into CROSS APPLY.
July 18, 2018 at 2:42 am
Think of those #metoo activists - do the even have a case?
According to the new law it's even illegal to remember events from that distant past.
Wait till they themselves are...
July 18, 2018 at 2:26 am
Yeah, criminals would definitely like a strong data retention policy.
July 18, 2018 at 2:18 am
You better make [date] a key for a clustered index on the table.
Otherwise:
DECLARE @FromID int, @ToID int
SELECT @FromID = MIN(ID), @ToID = MAX(ID)
FROM (
July 11, 2018 at 5:46 am
What is the clustered index on the table?
July 11, 2018 at 4:26 am
A meaningful validation must implement all constraints like these:
https://en.m.wikipedia.org/wiki/Telephone_numbers_in_Australia
That's for Australia.
Nothing to do with any other country.
July 4, 2018 at 2:41 pm
Viewing 15 posts - 541 through 555 (of 6,036 total)