|
VikashGohil wrote: But due to Large Database Size, it gives a Time-Out error on executing the Query.
What about a larger value for the Time-Out[^]?
I are Troll
|
|
|
|
|
Most larger databases have backup functionality builtin.
What database are you using?
|
|
|
|
|
You should probably check with your dba . One possibility could be the logs are full, another may be that you are waiting on a lock... Which DBMS are you using? Which version, and what is the SQL error number you are getting?
|
|
|
|
|
Hi All
Would you please help me, I have a stored procedure that calls a function within it. It is working fine when pointing to production database, but when
I change my connection to point to QA it raises an error. I have copied both the stored proc and the function from production to QA but still.
The error that I get is "A .NET Framework error occurred during execution of user-defined routine or aggregate"
I am using SQL Server 2008 full version.
Thank you in advance for your assistance.
MP
|
|
|
|
|
Are you getting the error in the client app or actually in the stored procedure. The dot net error indicates either the client has a problem or you have the CLR integration in SQL server turned on .
Either way without more detail cannot help.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi RAH
Thanx for the reply. I actually get this error even when I manually execute the stored procedure in SQL Server.
MP
|
|
|
|
|
Then I would think the function is a CLR function and there is a bug in there. Never having used the CLR in SQL Server I do not know how you debug such a beast.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have one sql server 2005 database and its size is 16 GB , i rebuild indexes on a table which is having size almost 12 GB (item Master)
* i know its not normalized but i get the db in this condition
dbcc dbreindex (item_master,'',80) and now size becomes 26 GB should i shrink database or physical files showing 50 % free space available.
what else can i do to increase the db speed , already check ,Disk I/O , Memory , temp DB , network Packet size.
Planning to do
UPDATE STATISTICS item_master
dbcc updateusage ('DB')
DBCC INDEXDEFRAG (DB,'item_master')
DBCC dropcleanbuffers
dbcc freesystemcache ('all')
dbcc cleantable (DB,'item_master') --
Anything else which can speed up the things from database point of view
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
How many rows are in the table? How many fields? What kind of data is it? Are your indices appropriate for the way you are wanting to extract the data? Can you update the structure to improve the performance or are you stuck with it?
|
|
|
|
|
Hi,
I have a database on webserver, when some one gives any order from website then data comes into this database. Now i'm fetching these data from websercer to our local machin's dataabse. for this purpose i'm using en exe which contains stored procedure for fetching the data.
These stored procedures takes 5-7 min to fetch the data from webserver. Now the problem is that at the time of execution of stored procedure no one can give the online order because of database busy.
My question is that how i can improve the system so that one can give online order at the time of execution of stored procedure.
Thank you..
krishna veer singh
|
|
|
|
|
can you tell which Database Server are you using and do you have any maintenance plans scheduled.
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
I'm using sqlserver 2005
krishna veer singh
|
|
|
|
|
Not without knowing a lot more about your system - table sizes, indices, configuration, usage, etc etc. One thing you could try, in your stored proc use (nolock) on your reads, this may help
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
No any complex thing is their in my system. only i'm selecting data from web sqlserver table and inserting it in to local sql server tables.
krishna veer singh
|
|
|
|
|
yes, but I bet there is a where clause, so are those columns indexed? Its far too complex to do in a fotrum without any table defs, index defs, usage stats etc etc. Run your query through query analyser and look at the execution plan, that should at least give you some clues.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Can you show your store procedure statement
Best Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
In SP there is nothing but only select and insert statements, i mean i'm selecting new data from web sql server and inserting it into our local sqlserver.
krishna veer singh
|
|
|
|
|
I always assumed that accessing the same Access database by multiple users somehow just works, i.e. many users can read and write to an Access database in a shared folder on the network.
I assumed the same functionality with SQLce.
However, I've never been able to test it.
Does it work as I assumed ?
|
|
|
|
|
abiemann wrote: I always assumed that accessing the same Access database by multiple users somehow just works, i.e. many users can read and write to an Access database in a shared folder on the network.
Happens way too often and although Access provides locking-mechanisms and the likes, you'll find that it fails to perform adequately.
SQL Express is also available free, and you can easily upsize your Access-database to SQL Express.
I are Troll
|
|
|
|
|
Yes, it works as you assumed... However, in both cases, each user needs to have their own front end installed (whether that's an Access DB, VB, whatever) You don't want a bunch of users opening the same file at the same time (ie: a single access database containing both tables as well as queries, forms and reports....)
|
|
|
|
|
the Access DB is used to only store data and it will be located in some shared folder on the network.
There's about 10 client apps (which is probably what you meant by "front end") that will, at any point of time, read data from the database and also write data to the database.
Forms will not be implemented in the database directly.
|
|
|
|
|
Access and SQL Server will both be fine as a back end then...
|
|
|
|
|
let us take the server is down and all the data are corrupted. other than backup,replication, log shipping what can we do to get back the data or make the customer to proceed with the work ?
|
|
|
|
|
Repeating the question won't help
only two letters away from being an asset
|
|
|
|
|
Ah, but this time some of it is bold and underlined (I guess for those of use that were too dim to understand the first time).
|
|
|
|