By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,036 Members | 978 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,036 IT Pros & Developers. It's quick & easy.

is case sensitive & normalization

P: 6
1. sql server 2005 is case sensitive or not......
2. do sql have normalization concept like oracle.........
Mar 6 '08 #1
Share this Question
Share on Google+
4 Replies


ck9663
Expert 2.5K+
P: 2,878
1. sql server 2005 is case sensitive or not......
2. do sql have normalization concept like oracle.........
1. Can be either, depending on your configuration. By default, I believe (read: not sure), is no, it's not case sensitive.

2. Am not into terms, but if you're talking about normalization on your db and tables, yes, SQL-Server, by design, is a relational database. But it still depends on your implementation. If you just create a table without implementing these features, then it's just serving as storage.

-- CK
Mar 6 '08 #2

P: 6
-- CK[/quote]
thank u sir...

1.what is the difference between oracle and sql server.....
Mar 7 '08 #3

amitpatel66
Expert 100+
P: 2,367
YES, Normalization is very important in terms of database design. In order to avoid data redunduncy, better performance, proper space usage, etc Normalization concepts needs to be considered for database design.
Mar 7 '08 #4

ck9663
Expert 2.5K+
P: 2,878
-- CK
thank u sir...

1.what is the difference between oracle and sql server.....[/quote]

Your question would require a course in a university :)
Mar 7 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.