I have a database and its size is 70MB also the log file have a size of 30MB. I am using this db for one of my application and going to insert data frequently and it will grow big very fast.
I dont want to loose the data going into the SQL DB, but at the same time as data is going to grow with time i need to take care of the size.
Is there any way in sql server 2005 I can store my data somewhere and also free up some space. I will need to pull out this information on front end later on.
All I want is I guess a way to capture the historic data or the sql data somewhere in the history which dont really occupies the space in SQL server and I can also pull out that data on front end using vb.net.
Also please suggest me any other ways I can handle this in this particular case.
There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005.
The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Recently, I was involved in a di…
This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…