Viewing 15 posts - 1,876 through 1,890 (of 6,036 total)
tfeuz,
You know that those numerous updates on #tables and persistent [tmp] table are extremely bad practices coming from procedural programming languages. They consume heaps of resources and slow everything down...
_____________
Code for TallyGenerator
August 18, 2015 at 8:55 pm
ArnoKwetters (6/12/2015)
Yes Sergiy,If that was the original question, then you are right.
Now I have had also 2 rows inserted.
The question was and still is - "Insert without PK". See the...
_____________
Code for TallyGenerator
June 12, 2015 at 3:04 pm
Steve Jones - SSC Editor (6/11/2015)
Arrrgg, apologies. That's what I get for trying to fix things quickly.Question corrected to disable the PK, and not the clustered index.
As the question stasnds...
_____________
Code for TallyGenerator
June 11, 2015 at 10:13 pm
TomThomson (5/9/2015)
Clearly you haven't a clue - can we agree on that?
You seem to get excited too easily.
Probably worth talking to a shrink.
Of course, I'm not an expert with phone...
_____________
Code for TallyGenerator
May 14, 2015 at 8:59 pm
DATEDIFF(dd, 0, [smalldatetime column]) + 1
_____________
Code for TallyGenerator
May 14, 2015 at 6:52 pm
There are no "local" calls from mobiles - you do realise that, right?
Mobiles do only "long distance" and "international" calls.
Every single call from a mobile phone starts with "0",...
_____________
Code for TallyGenerator
May 8, 2015 at 4:50 pm
TomThomson (5/8/2015)
You haven't responded to a single one of the points I made.
I must have missed them. Sorry.
Can you please repeat them in form of, say, bullet points list?
It would...
_____________
Code for TallyGenerator
May 8, 2015 at 7:01 am
Nevyn (5/6/2015)
Oh, I get it, 3 additional numeric columns in a database table are not significant extra storage
It's not. You still save same amount of data - probably even less...
_____________
Code for TallyGenerator
May 7, 2015 at 6:08 pm
TomThomson (5/6/2015)
Sergiy (5/5/2015)
_____________
Code for TallyGenerator
May 7, 2015 at 5:43 pm
Nevyn (5/6/2015)
But parsing one string before dialling a number takes "Too much of extra memory? Extra CPU power? I don't think so."
Yes, it does take extra CPU power.
Parsing a string...
_____________
Code for TallyGenerator
May 6, 2015 at 8:17 am
Nevyn (5/6/2015)
Remind the 'smart person' that in one of the cases he is maintaining 4 database columns, not 1, and updating all 4 on every phone number change.
Hmmm... what does...
_____________
Code for TallyGenerator
May 6, 2015 at 7:58 am
From how you described it I may assume that those BLOBs are totally irrelevant to user data, have no influence on user activity and may only be need for the...
_____________
Code for TallyGenerator
May 6, 2015 at 6:06 am
So, we have 2 options here.
1. Parse the entered string once when it's being saved into predefined components and store those components in the class.
2. Parse the entered string when...
_____________
Code for TallyGenerator
May 6, 2015 at 4:59 am
The international public telecommunication numbering plan
http://en.wikipedia.org/wiki/E.164
4 different categories - every single one is made up of several components.
Not a single one is a single character string.
Now, you may choose to...
_____________
Code for TallyGenerator
May 5, 2015 at 11:45 pm
Google's common Java, C++ and JavaScript library for parsing, formatting, storing and validating international phone numbers. The Java version is optimized for running on smartphones, and is used by the...
_____________
Code for TallyGenerator
May 5, 2015 at 11:07 pm
Viewing 15 posts - 1,876 through 1,890 (of 6,036 total)