From the course: SQL Server 2014 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Advanced options of database configuration - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
Advanced options of database configuration
- So, now, let's talk about some additional options you have when creating a database. Again, in SQL Server Management Studio, I'm going to right click on databases and select new database. And all the way to the left in this dialogue under select a page, I'm going to go to Options, and we can see we have quite a number of options when creating a database. Most of the time just leaving these to the default values is fine. But let's go ahead and talk about a few of them. The top one, Collation, is a rather large drop-down that allows us to select different things. Collation roughly translates to how we put things in order. So, often, when we query a database, we ask it to put the results in alphabetical order. Alphabetical order can be slightly different in different languages. So if you scroll through this list, you'll see a list of quite a number of different languages. The one language you will not see, surprisingly, is English. English is not an option. Instead, for English…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.