DataBase - SQL Server 2008 R2 Express Database Size Limit Increased to 10GB

SQL Server 2008 R2 Express Database Size Limit Increased to 10GB
Great news for SQL Server Express users today! We increased the
maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB.

http://blogs.msdn.com/sqlexpress/

  Arvin Meyer [MVP] replied to a a r o n . k e m p f

Doesn't matter to most Access users, who typically have databases which are
under 100 MB. True, size is a consideration, but most Access users choose
SQL-Server for other reasons than the size it allows for data.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


message

  a a r o n _ k e m p f replied to Arvin Meyer [MVP]

PLEASE leave your sour grapes BS at home, dude




re
in
com...

  asd123 replied to a a r o n _ k e m p f

dsaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
??????:95a21bf8-5a82-4c12-b0bc-53243f09f1b4@p5g2000pri.googlegroups.com...
PLEASE leave your sour grapes BS at home, dude

SQL query slow DataBase Hi In the code below I found that it takes 1.3 seconds to load to split it up or cancel the query? And can I read this faster? string sql = EquipmentID(Equipment) + StartDate.ToOADate().ToString(FloatFormat, myCulture) + EndDate.ToOADate().ToString(FloatFormat, myCulture); sql + = " group by event_id, name"; _Log("Calc thread #2"); OleDbCommand com = new OleDbCommand(sql, con); _Log("Calc thread #3"); From #2 to #3 it takes 1.3 seconds. Remaing less that 0.1 second. So the query is what slows it down. Access Discussions SQL Server (1) Linson Unlike Albert D. Kallal (1) MySQL (1) Windows Server 2003 (1) Visual Studio (1) SharePoint (1) NHibernate (1) Microsoft SQL Server (1) Hi, Besides

Aaron Kempf's MCITP DBA proof DataBase https: / / mcp.microsoft.com / authenticate / validatemcp.aspx transcript: 944364 AccessCode: helloworld Access Discussions SQL Server 2008 R2 (1) SQL Server 2008 (1) SQL Server 2005 (1) Microsoft SQL Server Reporting Services (1) Regards Larry Linson

Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed reading this article, is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will 2010 does not really save them money (because of the 64-bit requirements of Sharepoint Server 2010, it could vastly increase those costs for organizations with legacy hardware). The features of businesses, but the market segmentation of the product makes it entirely cost-prohibitive for medium-size and small businesses. I do not know if I could sell clients on hosted Sharepoint email hosted by someone else, so it is not a paradigmatic change. Having your flagship database applications hosted outside your local LAN seems to me to be a big leap, and http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1) SharePoint (1) David W. Fenton

Using Mysql or SQL server as backend to Access front end DataBase Have a client having problems with a fairly complex Access system which is split into end. Using access 2003 / mdb format with Access 2007 software. We are surmising that recent server problems or connectivity problems may be to blame. If we converted to MySQL or SQL server as the back end, would that eliminate the potential for Database corruption that can occur with Access Jet databases when you lose connectivity, when someone shuts down their PC with the database active, etc? If so am I correct that you connect via ODBC rather than using

Library Database DataBase Firstly, I am not sure if Library database is the correct term. I am talking about Dbs to which you set a reference drew blanks last time. Now assuming I have several referenced (library?) databases in my main database, how do I get the names of all the forms in all the Dbs? CodeProject AllForms.Count gives me the correct number of forms if I am in that referenced database. What I think I need is a method of looping through all the different CodeProject names in the main database, but there is not a sort of CodeProjects parent object. Or somehow moving the focus And, No, there is not any parent object for all the code projects. Because each database only knows about its own objects (or documents), you have to use a procedure in each database to refer to the objects in that database. E.g. to open a form in