Hi All, i wanted to know if and how does choosing char over varchar impacts the performance. i have some data which will be fixed size (may contain null). i...
Hi All, i am posting this message on behalf of Mr.Janak from HCL Chennai.. he is searching his old friend "Shiv Kumar" who studied at NCST around 1980s. please...
Here is what I found .... As a general rule, you would pick CHAR if all rows will have the same length and VARCHAR when it is variable length. CHAR is also a...
yes that's the general rule. and even i was under the impression that char would be faster so should be used when it comes to fixed size data. what i was...
IMHO, Internally using varchar to implement char will defeat the entire purpose of char. Also it seems to a really convoluted design for implementing char. ...
... remember also that a char(x) NULL column is actually a varchar(x) NULL column. A char column is incapable of holding a null, so behind the scenes SQL will...
yes that was the post that caught my attention. however if your interpretation is right, then it will be a pain (from implementation point of view of DB) if...
heres another msg on this thread. good to see group in action after quite some time. not sure if this msg was sent to group or not. his first point is...
Per MSDN, If ANSI_PADDING is ON when a char NULL column is created, it behaves the same as a char NOT NULL column: values are right-padded to the size of the...
A friend of mine is looking for a good course to get started with programming and computer science in general. He appeared for the recent edition of CST but it...
Have you checked the kharghar center. Vashi center was in rental place and close later after khargar center became operational...Kharghar center is quite...
I was at Kharghar 2005-06 FPDGST. It is simply too good... huge ground to play, good hostel, college like environment and very spacious campus. Also it is...
Thoughtworks is looking for Systems / Network Engineer for its Chennai office with 3 5 years of experience. * Linux/Windows * DHCP/DNS/Active Directory/HTTP...
Greetings: We presently have an opening for Java/ J2EE professionals with at least one year of experience with Database Administration for major RDBMS like...
Hi, I want to send another ajax request when one request is in process to get the status of first request in asp.net 2.0. This is working fine if no session...
Hi Friends, I am recently having a strange problem with a Red Hat Linux server that manages the firewall of my company network. Basically it gets shut down ...
Are you sure this a linux problem ? I've had this problem with faulty power supplies. If you think Linux is the culprit, check your APM (advanced power...
It can be issue of faulty power supply or it can be issue of Overheating due to cooling fans not working in the unit causing the processor over heating. Thanks...
Dear All, My friend is looking for an Automation Testing / Game Testing opening. He has pursued B.E (Information Tech.) and is working since 2.2 years(first...
Dear All, This is for my friend : Would any one advice me on - "If continuing a career in Automation testing would benefit him over Game Testing. What would be...
FYI ... From: Prasad Rao Date: Wed, Aug 26, 2009 at 9:45 PM Subject: Google Code Jam Returns! Hi,* Given a 49x49 grid of numbers, can you place mines in the...
Hi, I need IBM HTTP server 6.1 - 64 bit for Solaris SPARC 10. The IHS 6.1 installer available on IBM's site is 32 bit. I need to know if IBM supports 64 bit...
Hello Friends, Please forward this resume of my friend in your respective companies. Thanks & Regards, Rajiv Ranjan Now, send attachments up to 25MB with...
Hi Everyone, www.ptech.in is my company site...we are recruting agressively for onsite egov projects ... people will be stationed at various client site......
Hi All, My sister is looking for job as Java Developer. She is a fresher in the industry. She has done BE from Mumbai University and passed SCJP with 90%. If...
Dear All, This is Shilpa Palkar. I am currently doing my MBA in Information Management. With regards for my third year MBA Thesis, I have selected the topic...
No attachment allowed on group. please send me your questionaire at pravin.deo@... Regards, Pravin Kumar ________________________________ From: shilpa...