Viewing 15 posts - 541 through 555 (of 6,036 total)
_____________
Code for TallyGenerator
July 24, 2018 at 6:35 am
_____________
Code for TallyGenerator
July 24, 2018 at 5:24 am
_____________
Code for TallyGenerator
July 23, 2018 at 7:37 pm
July 23, 2018 at 7:31 pm
Yep... understood. I just want to know if I need to relearn a...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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"?
_____________
Code for TallyGenerator
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 ...
_____________
Code for TallyGenerator
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?
_____________
Code for TallyGenerator
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.
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
July 18, 2018 at 2:26 am
Yeah, criminals would definitely like a strong data retention policy.
_____________
Code for TallyGenerator
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 (
Code for TallyGenerator
July 11, 2018 at 5:46 am
What is the clustered index on the table?
_____________
Code for TallyGenerator
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.
_____________
Code for TallyGenerator
July 4, 2018 at 2:41 pm
Viewing 15 posts - 541 through 555 (of 6,036 total)