Klos, Susan
Susan.Klos at fldoe.org
Wed Mar 24 06:35:53 CDT 2010
John, count me in also. I am not familiar with .net but have built websites using a text editor and knowledge of html code. I would be more than willing to help where I can and learn new things. I am an advocate for cross browser coding. It should look good in browsers other than IE. I used to use Cold Fusion for getting data from and to a database on the server. I could learn .net I am sure. If you need further assistance feel free to contact me. Susan Klos Senior Database Analyst Florida Department of Education Evaluation and Reporting Office Phone: 850.245.0708 Fax: 850.245.0710 email: susan.klos at fldoe.org -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of dba-sqlserver-request at databaseadvisors.com Sent: Tuesday, March 23, 2010 2:00 PM To: dba-sqlserver at databaseadvisors.com Subject: dba-SQLServer Digest, Vol 85, Issue 13 Send dba-SQLServer mailing list submissions to dba-sqlserver at databaseadvisors.com To subscribe or unsubscribe via the World Wide Web, visit http://databaseadvisors.com/mailman/listinfo/dba-sqlserver or, via email, send a message with subject or body 'help' to dba-sqlserver-request at databaseadvisors.com You can reach the person managing the list at dba-sqlserver-owner at databaseadvisors.com When replying, please edit your Subject line so it is more specific than "Re: Contents of dba-SQLServer digest..." Today's Topics: 1. Re: SPAM-LOW: Re: My database is slow (Mark Breen) 2. Call for development assistance (jwcolby) 3. Re: Call for development assistance (Susan Harkins) 4. Re: Call for development assistance (jwcolby) ---------------------------------------------------------------------- Message: 1 Date: Mon, 22 Mar 2010 19:27:03 +0000 From: Mark Breen <marklbreen at gmail.com> Subject: Re: [dba-SQLServer] SPAM-LOW: Re: My database is slow To: Discussion concerning MS SQL Server <dba-sqlserver at databaseadvisors.com> Message-ID: <c7fd28d01003221227s4a33a4edkd6fce640943fce62 at mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hello John, Just FYI, [Following comments are for information and not intended to be for scalable systems or high volumes of users] an ODBC linked table, over the internet, to MySQL or MS SQL works fantastically fast. At times you would not realize that it was a linked table via OBDC, even when that is a shared server in a hosting company with 100 other people on the same box. Using a Jet Query can give fantastically fast results and criteria such as Where OrderID = x works super. Doing a join from Customers to Orders works well enough but can be slower. However for the average user a join of two tables might be plenty fast with data coming back in 1-2 seconds. Doing a join from Customers to orders to Order Details starting to become slow. In that case, you can create a View then you "Select * from CustomersOrdersOrderItems" where Order Id = x. Not surprisingly this is fantastically fast again. So what is my point? Do not assume that linked tables and jet based queries are all bad, they are good enough for normal users to use and you only need server based queries when they become more complex. I hope that is useful for you, you should try it sometime and you will be surprised to see how fast "dirty linked tables" can be. HTH, Thanks Mark On 22 March 2010 17:58, jwcolby <jwcolby at colbyconsulting.com> wrote: > Mark, > > I thought it was slow through SSMS as well. However I just went back in to > look and it is pretty > much instantaneous displaying the top (1000) records for any table. > > The database files are on my local laptop. The laptop is a DELL (Intel) > dual core with 4 gigs of > RAM. The hard drive is an upgrade to 7200 rpm. > > Everything was running fine. I had SQL Server 2005 Express services > running on the laptop and > installed 2005 SSMS to be able to see it from SSMS if needed. > > I never had any issues until I switched to 2008. I upgraded my SERVER to > 2008 and suddenly was > unable to get at the databases on the server. Thinking back on it that was > suspicious since I would > think that 2005 SSMS should be able to see and talk to 2008 server > instances. > > I wasn't really thinking deeply about that though. I just decided that > 2008 was running great on > the server, let's install on my laptop as well. When I tried, it > complained during install about > the Express stuff. I just decided to completely uninstall everything SQL > Server and reinstall from > scratch with 2008. That in fact worked quite well. > > So it seems that maaaaybe the issue could be ODBC access to the 2008 stuff > from Access 2003. The > interface is still pretty darned slow. > > I think life is prodding me to learn how to bind forms and combos to stored > procedures out on SQL > Server. I actually moved to SQL Server exactly to allow me to learn this > stuff here at my office on > a real system, then I never got around to it. > > John W. Colby > www.ColbyConsulting.com > > > Mark Breen wrote: > > Hi John, > > > > So it is SQL Server itself or the billing db? > > > > Are other db's also slow? If it is just billing then you need to look at > > indexes etc, and as Bobby is suggesting, you may want to use the wizard > to > > create a daily maintenance plan, that will re-build the indexes on > specified > > databases. I always include a daily maintenance plan on any transaction > > based db's I look after. > > > > However, if it is machine and OS / installation related, that is all > > irrelevant and you need to look at firewall, AV or some other machine > > related issue. I would plum first for a careful complete removal of SQL > and > > another install in that case. I would turn off AV/ Firewal and anything > > else that might effect it (Spyware software). > > > > Let us know which it is, I recently upgraded a few machines to sql 2008 > and > > would be keen to hear how you get on. > > > > Also, is it slow in SSMS or just through the GUI that you are using? > IOW, > > could it be ABO or ODBC related? > > > > Mark > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > ------------------------------ Message: 2 Date: Tue, 23 Mar 2010 10:19:22 -0400 From: jwcolby <jwcolby at colbyconsulting.com> Subject: [dba-SQLServer] Call for development assistance To: VBA <dba-vb at databaseadvisors.com>, Sqlserver-Dba <dba-sqlserver at databaseadvisors.com> Message-ID: <4BA8CDEA.9000907 at colbyconsulting.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Guys, Please bear with me for just a bit of explanation. Because my daughter has a genetic problem which causes her a variety of medical issues, I have become involved in an organization that is training my wife and I to be advocates for people with disabilities. The organization is called Partners in Policymaking (PIP) and their intent is to train individuals with disabilities, or caretakers for people with disabilities to be effective advocates. First of all anyone (in the US) who has a disability or is a caretaker, I highly recommend the following site as it provides a ton of links to other sites for specific issues. http://www.partnersinpolicymaking.com/ For my state the link is: http://www.ncpartnersinpolicymaking.com/index.html PIP is a national organization but each state has their own organization to provide training in that state. PIP provides a series of about 9 monthly trainings (16 hours, once a month) on a variety of issues. Each participant (me) has to do a project. While PIP has a web site and stuff, what they do not have (or I haven't found) is an effective system for allowing every PIP graduate from every state to find each other and communicate. For my project I have decided to try to leverage my technical abilities (and contacts!) to try and build a system for coordinating the graduates. What I want to do is build a web site. BUT I do not do web sites! But it really needs to be a web site. Sigh. So (THE PURPOSE OF THIS EMAIL) I am putting out a call for anyone who wants to get involved with a good cause and knows anything at all about building a web site (in .Net). I am going to be involved in this. I am going to learn everything I can about every phase of this, but I need help. I expect to have a fairly large database of contact information, including email addresses. I expect eventually to broaden the base to anyone with a stake, people with or caretakers of people with a disability. Eventually I would like to build a system similar to one belonging to: http://consumer-action.org/ This organization collects email addresses for consumers who want to affect legislation. Someone at consumer-action.org then monitors legislation before congress and emails us consumers when legislation is about to be voted on. More importantly it provides a way, through their web site, to SEND EMAIL to MY legislators (based on my zip code). Way cool, way easy to send the email to my legislator. I want to do that for disability rights legislation. I need help. Anyone interested in helping please raise your hand, get with me, and let's make this thing happen. Thanks, -- John W. Colby www.ColbyConsulting.com ------------------------------ Message: 3 Date: Tue, 23 Mar 2010 10:25:19 -0400 From: "Susan Harkins" <ssharkins at gmail.com> Subject: Re: [dba-SQLServer] Call for development assistance To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com> Message-ID: <F096396072CC48F695CA312355DCD3DC at SusanOne> Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original > Anyone interested in helping please raise your hand, get with me, and > let's make this thing happen. ======JC, count me in -- I have no experience in building web sites, but I'm sure there's something I could do to help, and I'm not opposing to learning new skills. Susan H. ------------------------------ Message: 4 Date: Tue, 23 Mar 2010 10:58:16 -0400 From: jwcolby <jwcolby at colbyconsulting.com> Subject: Re: [dba-SQLServer] Call for development assistance To: Discussion concerning MS SQL Server <dba-sqlserver at databaseadvisors.com>, VBA <dba-vb at databaseadvisors.com> Message-ID: <4BA8D708.2000901 at colbyconsulting.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Thanks Susan! If it works, eventually this thing will be huge I think. In the meantime I am going to need SQL Server stuff, C# stuff and ASP.Net stuff. Lots for everyone to do I am sure. Not to mention brainstorming, high level planning, documentation and so much more. I would like to be able to do startup in time for my last session which will be in the November time frame. John W. Colby www.ColbyConsulting.com Susan Harkins wrote: >> Anyone interested in helping please raise your hand, get with me, and >> let's make this thing happen. > > ======JC, count me in -- I have no experience in building web sites, but I'm > sure there's something I could do to help, and I'm not opposing to learning > new skills. > > Susan H. > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > ------------------------------ _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver End of dba-SQLServer Digest, Vol 85, Issue 13 *********************************************