August 17, 2015 at 10:20 am
Hello,
Is there a performance hit if I use CAPITOL LETTERS (like this) in column names for my SQL Server tables? Logically I would think that lower case letters would have better performance because they are smaller characters and easier to store.
Does this actually matter, or am I splitting hairs here 🙂
Any help would be greatly appreciated.
SQLTG
The are no problems, only solutions. --John Lennon
August 17, 2015 at 10:28 am
SQLTougherGuy (8/17/2015)
Hello,Is there a performance hit if I use CAPITOL LETTERS (like this) in column names for my SQL Server tables? Logically I would think that lower case letters would have better performance because they are smaller characters and easier to store.
Does this actually matter, or am I splitting hairs here 🙂
Any help would be greatly appreciated.
SQLTG
Seriously?
Using smaller font size will improve performance more than uppper/lower case will.
Just kidding of course.
Case has no effect on performance.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 17, 2015 at 10:32 am
Thanks for your response. I figured that was the case but just wanted to be sure.
BTW: Your signature is hysterical! I love it! Both cynical and logical 🙂
The are no problems, only solutions. --John Lennon
August 17, 2015 at 10:45 am
If you want to get technical about it, then case might have a performance issue. In the terms that if you are using case-sensitive collations and you don't call your columns with the proper case, then SQL isn't going to perform at all.
Just sayin'. @=)
August 17, 2015 at 11:00 am
Yeah, if you use a smaller font, you can squeeze more letters into the same space. <eye roll >
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply