Wow, I didn’t realize I left this question out.
So here’s the question:
Q: What’s the difference between char() and varchar()?
A: With char() you can store the standard set of characters. And with varchar() you can store the extended set… pretty much any character you can think of can be stored in varchar() whereas with char() you can only store the standard 50. I think it’s 50. Maybe it’s 53 or something. I forget the exact number, but it’s about 50.
So that’s when I asked him about the difference between char() and nchar() because that usually kicks them in line and they go, oh wait, y, so char() holds regular data and nchar() holds extended data. So that means varchar() holds… and then whatever they come up with next.
But not this guy, no, he stuck to his guns and went with nchar() holding numeric character data.
You’ve gotta love someone who sticks to their guns no matter what!
The best database career advice you’ve never heard!
Become a DBA. Become a BETTER DBA. Use the Roadmap.
The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!
Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)
Visit www.DBARoadmap.com for info, forums, and more!
TagsArchitecture blunders Camtasia Career Coding Standards CPU data generator DBA Development disaster firewall Idiots Inside SQL Server Interview ITBookworm Jobs Kalen Delaney Katmai Ken Henderson LiteSpeed MidnightDBA PASS Summit 2011 Pinnacle politics Powershell Powershell Hero Query techniques Red-Gate reporting restore SQL Express 1433 SCM SQL Server SQLServerDVD.com SSIS SSRS Training troubleshooting TSQL Tuesday tuning Tutorials Video post videos Yukon
Interview: Kalen Delaney!
Need help? Got an emergency? Write us at Support@MidnightDBA.com!
We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.
- Guest Review: Microsoft Wireless Sculpt Ergonomic Keyboard
- Quick Review: Anker Vertical Ergonomic Optical USB Wired Mouse
- Reading: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan
- Repost: “Problems with my new book” by Grant Fritchey
- Announcing SQL Server 2012 Query Performance Tuning by Grant Fritchey