Hi guys
I have no formal database education and this is why I have trouble selecting one way of doing things over another.
what is the general consensus on this?
I have a database that is used in the way that every time I use it I load new data into a list of "base"tables. Then I run the same queries against the data and use the result to write a report.
Before I use the database for the next report I empty all the base tables of old data, then load the new data into the base tables and then I run all the queries.
I am the only user in the database.
The RDBMS is MS SQL 2008 with SQL management studio as editor. Currently I have no GUI. But in time I would like to write a GUI so the use of the database is more sleek.
In this scenario, would you recommend that I have my queries defined in views that are run or that the queries are defined in stored procedures?
I look forward to a good learning experience about the purpose of views and stored procedures and pros and cons for each and then a recommendation based on my scenario.
cheers
Thomas
I have no formal database education and this is why I have trouble selecting one way of doing things over another.
what is the general consensus on this?
I have a database that is used in the way that every time I use it I load new data into a list of "base"tables. Then I run the same queries against the data and use the result to write a report.
Before I use the database for the next report I empty all the base tables of old data, then load the new data into the base tables and then I run all the queries.
I am the only user in the database.
The RDBMS is MS SQL 2008 with SQL management studio as editor. Currently I have no GUI. But in time I would like to write a GUI so the use of the database is more sleek.
In this scenario, would you recommend that I have my queries defined in views that are run or that the queries are defined in stored procedures?
I look forward to a good learning experience about the purpose of views and stored procedures and pros and cons for each and then a recommendation based on my scenario.
cheers
Thomas
Comment