connecting to sql questions
-
Hi all At work we have a database that is read only that keeps track of the work we do ( who completed what ticket and so on) I need to take a chunk of the database for the work done by my group then count up certain types of information like who has done how many tickets or how many of one type of problem there was during a certain time. question 1) can i use the fact that this is read only to my advantage in terms of speed or memory i saw something called sqlreader but i haven't had time to play with it yet question 2) given the senerio above what would be the most efficient work flow? should i read the database into a dataset then do my filtering from there or something else unfortunately this is not my strongest subject so all suggestions are appreshated
-
Hi all At work we have a database that is read only that keeps track of the work we do ( who completed what ticket and so on) I need to take a chunk of the database for the work done by my group then count up certain types of information like who has done how many tickets or how many of one type of problem there was during a certain time. question 1) can i use the fact that this is read only to my advantage in terms of speed or memory i saw something called sqlreader but i haven't had time to play with it yet question 2) given the senerio above what would be the most efficient work flow? should i read the database into a dataset then do my filtering from there or something else unfortunately this is not my strongest subject so all suggestions are appreshated
I would choose solution 1, coupled with the use of stored procedure. As a piece of advice, if you are only reading from the tables, use the
with (nolock)lock hint in your queries.----- If atheism is a religion, then not collecting stamps is a hobby. -- Unknown
-
Hi all At work we have a database that is read only that keeps track of the work we do ( who completed what ticket and so on) I need to take a chunk of the database for the work done by my group then count up certain types of information like who has done how many tickets or how many of one type of problem there was during a certain time. question 1) can i use the fact that this is read only to my advantage in terms of speed or memory i saw something called sqlreader but i haven't had time to play with it yet question 2) given the senerio above what would be the most efficient work flow? should i read the database into a dataset then do my filtering from there or something else unfortunately this is not my strongest subject so all suggestions are appreshated