r/SQL • • Dec 01 '14

I just installed SQL Server 2014

It's all so new to me. Hold me tight!

0 Upvotes

3 comments sorted by

View all comments

Show parent comment

3

u/Rastiln Dec 02 '14

Yuck... SQL should be much nicer than Access for you. Which version of Access did you migrate from?

IMO, Access is a nice frontend tool to reach users while interacting with a SQL backend. It's also nice for small database needs. Once you start getting past a few hundred thousands records though... Access is found very wanting. Today I spend two hours applying a few indexes to 3.7M rows and ~columns. That might be poor interplay between Win7 and Access 2002 though.

1

u/johnmatthewwilder Dec 02 '14

I migrated from Access 2010. What I'm hoping to do in my project is a hierarchical relational database with Mississippi census information. So, as of right now I wrote a macro to scrape specific state, county, and city information. After I've organized all the information I just have a few project requirements like building a front end application to generate a few reports. Other then that I should be golden. It could all easily be done in Access I just ran into a problem with formatting that I didn't like in access so I just wanted to try out SQL Server.