June 20, 2011 at 5:06 am
Hi all,
I'm new to the Database.
We are using the free version of MS SQL Server 2005 for in the organization. Now the data growing
and reaches to 2.7GB. So for free version Microsoft provides upto 4Gb. So any other way to extend
the memory free of cost?. And also in the organization they were developed the application to get
the data for reporting. The reporting is to compare the data past few years.
My Plan:
Planned to take the bakup and clear the data and allowing the fresh data
But if i do that i can't compare the data with pervious year in reporting.
Looking for yours kind help.
Thanks,
June 20, 2011 at 5:38 am
Nope. If you're hitting the limit, you're hitting the limit. No way around it. You either have to dump data or you have to purchase a licensed copy of the software.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 20, 2011 at 5:50 am
2008 R2 Express provides a 10gb limit on db size but still limits you to 1 processor and 1gb RAM.
If you're pushing those limits, time to cough up the dough.
June 20, 2011 at 6:35 am
If you're reaching your data limit, why would you be questioning how to increase the memory size? Data size and memory size are two different things and should be treated as such.
But, as the others have said, you can purge old data off to fix the problem, or you can upgrade.
June 20, 2011 at 6:39 am
The free version is limited to 1 Gb of RAM, regardless of how much/little data you have, no way around that.
There are ways around the storage limit, but they're technically a violation of the license agreement, and that's a legal violation that can get your business in trouble (like expensive lawsuit type trouble).
The 10 Gb limit on SQL 2008 Express is, I think, a typo. The details page on it (http://www.microsoft.com/sqlserver/2008/en/us/express.aspx) says 4 Gb. Probably worth testing, but I haven't bothered.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 20, 2011 at 6:44 am
GSquared (6/20/2011)
There are ways around the storage limit, but they're technically a violation of the license agreement, and that's a legal violation that can get your business in trouble (like expensive lawsuit type trouble).
Reasons why I stopped myself from mentioning them.
June 20, 2011 at 7:21 am
The reporting is to compare the data past few years.
You could analyze the reporting. By that I mean is the data, lets say for sales of items, entered as a daily item in a table lets call it CurrentSales. That is from the DB you can select sales for each day of a given month for a given year. But in the report comparing different years, the report sums the daily values and the comparison is done on a monthly basis. If that is the case you could create a table, lets call it PriorSales where you insert the sum of daily sales for each day of a given month and year (the value that appears in the report). Once you have done that, and of course checked it to be sure the values are correct, then the entries in the CurrentSales table for that prior year and months can be deleted. This would give you 12 rows in the PriorYears table, and allow you to delete some 365 rows from the CurrentSales table. In effect "increasing the capacity of the DB".
Now if this appears to be practical, be sure to take a DB backup, store that so that if more detail is needed at some time in the future the DB can be restored to that point of time.
June 20, 2011 at 7:27 am
GSquared (6/20/2011)
The free version is limited to 1 Gb of RAM, regardless of how much/little data you have, no way around that.There are ways around the storage limit, but they're technically a violation of the license agreement, and that's a legal violation that can get your business in trouble (like expensive lawsuit type trouble).
The 10 Gb limit on SQL 2008 Express is, I think, a typo. The details page on it (http://www.microsoft.com/sqlserver/2008/en/us/express.aspx) says 4 Gb. Probably worth testing, but I haven't bothered.
10 GB is for 2008 R2 (confirmed by a failed restore of a 25 GB db with the error : max 10 GB)
June 20, 2011 at 8:28 pm
Thanks a lot for all your suggestions.
My management planned to get the license from Oracle. So if they implement the oracle i need to migrate the SQL to Oracle. SO our application based on SQL server script.
Can i use the SQL scripts for Oracle DB?. Because our application build with SQL scripts.
Or else any tool is there is such that i pass the SQL scripts and it convert to Oracle scripts?.
Once again thanks.
June 20, 2011 at 8:56 pm
I think the easiest way to generate Oracle DDL would be to reverse engineer the schema into a Data Modeling tool (if you have one) and then try to generate the DDL from the diagram. The DDL scripts for SQL Server will likely not work on Oracle because the data type names are different (example: integer in T-SQL and number(9,0) in Oracle).
June 20, 2011 at 9:22 pm
There are differences between Oracles SQL and Microsofts SQL Servers T-SQL. If your organization is going to purchase a database system, moving to Oracle is going to require a fair amount of work. The easiest upgrade path would be to Microsoft SQL Servers Workgroup or Standard edition depending on your needs and would not require any changes to your database.
I would recommend checking into that before moving to Oracle. In addtion, Micorsoft does provide more tools out of the box than Oracle does.
June 21, 2011 at 12:44 pm
Ken Garrett (6/20/2011)
I think the easiest way to generate Oracle DDL would be to reverse engineer the schema into a Data Modeling tool (if you have one) and then try to generate the DDL from the diagram. The DDL scripts for SQL Server will likely not work on Oracle because the data type names are different (example: integer in T-SQL and number(9,0) in Oracle).
Ken, I think he's talking DML, not DDL.
And no, there's not an easy way to do it since syntax is different.
June 22, 2011 at 6:54 am
Ninja's_RGR'us (6/20/2011)
10 GB is for 2008 R2 (confirmed by a failed restore of a 25 GB db with the error : max 10 GB)
And double confirmed by Microsoft's own product comparison page:
http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx
June 22, 2011 at 8:17 am
Brandie Tarvin (6/20/2011)
GSquared (6/20/2011)
There are ways around the storage limit, but they're technically a violation of the license agreement, and that's a legal violation that can get your business in trouble (like expensive lawsuit type trouble).Reasons why I stopped myself from mentioning them.
I mentioned them because I'd hate to see someone suggest them without the caveat, and someone else adopt them thinking they're fine, and then get in trouble.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 22, 2011 at 9:30 am
Anyone else find it ironic that a company is moving from a FREE SQL Server product to an Oracle product? :w00t:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 15 posts - 1 through 15 (of 60 total)
You must be logged in to reply to this topic. Login to reply