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...
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...
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...
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...
May 14, 2015 at 8:59 pm
DATEDIFF(dd, 0, [smalldatetime column]) + 1
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",...
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...
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...
May 7, 2015 at 6:08 pm
TomThomson (5/6/2015)
Sergiy (5/5/2015)
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...
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...
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...
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...
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...
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...
May 5, 2015 at 11:07 pm
Viewing 15 posts - 1,876 through 1,890 (of 6,036 total)