Lets see in my last job:

I get a call from the guy and he say's "hey my query kept timing out so
I set the timeout to 0 and now I get an error out of memory"
I go look at the query and this is what I saw:

Select * from my_2million_Row_table , my_7millionrow_table

Hello McFly??

So do you think the performance on the db was impacted?
I guess if you only have a few people writing access db's then you can
control it. If not, like in the last job you get 8700 + databases that
take up space, don't have version control, point to one database or
excel file which points to another database or gets changed sometime in
the last month and when someone goes to report for month end gets
errors.
Hey Jeremy did I miss anything?

PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]


-----Original Message-----
From: Norkett Margaret
[mailto:mssqldba-ezmlmshield-x99807782.[Email address protected]
Sent: Monday, July 30, 2007 2:26 PM
To: LazyDBA Discussion
Subject: Using Access to create reports and queries to a SQL server

I have a developer here who LOVES to use MS Access to create queries and
reports in. She links tables from my SQL2005 database in it and goes to
town. I know I've read on this forum that there is a performance hit
involved with this practice (I think), so would like to take information
to my boss to help him discourage her from this practice.



What say ye?



If you have any questions or concerns, please let me know them.



Margaret Norkett

Database Administrator

* 864-271-6522 ext 222

* 864-270-2884









Experience is the name everyone gives to their mistakes.

Oscar Wilde <http://www.quotationspage.com/quotes/Oscar_Wilde/> , Lady
Windermere's Fan, 1892, Act III Irish dramatist, novelist, & poet (1854
- 1900)

~





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------
The information contained in this message may be privileged,
confidential, and protected from disclosure. If the reader of this
message is not the intended recipient, or any employee or agent
responsible for delivering this message to the intended recipient,
you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer.

Thank you. Paychex, Inc.

MS Sql Server LazyDBA home page