|
Hi,
I found that the Log file of my database has grown too fat. as i want to save some of the resources, i am thinking of deleting it.
but i think such a direct deletion will hamper my database. can you please tell me how to DELETE / REDUCE the size of that log file.
also, throw some light on how to read database log files.
Thanking You.
BSRK
|
|
|
|
|
What DB are you using, SQL Server?
ADDED: Apologies, I should have read the title of the question!!
You should look at your Recovery model. Maybe you could get away with a lower level of recovery.
You cannot delete the Transaction Log.
If you backup your log, it is automatically truncated. Then, you can shrink it. You can run backup with a TRUNCATE_ONLY option. Then shrink it.
Steve
-- modified at 14:37 Thursday 17th August, 2006
|
|
|
|
|
|
Simple one, I hope...
I want to query, say, a customer number and name and have the query return both as a single value for use in drop down list.
Is this possible? and if so what is the best way of doing this?
Thanks.
-- modified at 8:05 Thursday 17th August, 2006
|
|
|
|
|
Generally, SELECT field1 + field2 FROM table works. However, if the customer number is numeric, you will need to use SELECT CAST(field1 AS varchar(20)) + field2 FROM table
If you want gaps or additional chars such as [1] Customer name you do the following
SELECT '[' + CAST(field1 AS varchar(20)) + '] ' + field2 FROM table
Hope this helps,
Ian
|
|
|
|
|
1. Using ADO.NET Datareader a user extracts data from a database table
having 1000 rows.He closed his browser in between.
that is after fetching only 50 records.
What happens to the Datareader?will it remain connected?
and will fetch 1000 records and what after?
will garbage collector collect and dispose it soon?
2. A user fetched dtata from a database table
using Dataset(Disconnected records) for updation.
Another user deleted the table just after.
what happens when the first user try to update the table after changes? Error or Something else
3.where is session id stored in ASP? in IIS aerver or ASP Engine
Thanks & Regards
Vishal Sharma
vishalsharma556@yahoo.co.in
|
|
|
|
|
I'd like to help but I don't feel like Googling it for you.
|
|
|
|
|
1. What do you think happens? Think through the process, the sequence of events and try and work out what is likely to happen and why. This is one of the most important skills in software development and will help you in many area such as designing, debugging and implementation.
2. This is easy to test yourself by making a couple of quick test applications. Another important skill is to be able to quickly create a small example showing how something works so that you have a small reference project from which you can learn.
3. Off topic for this forum. One of the best skills is to know where something is in the grand scheme of things.
|
|
|
|
|
Hi, how do i index a table in 2005?
When i right click on the table, full-text indexing is grey'd out(disabled).
How do i enable it?
Regards,
Tintin
|
|
|
|
|
Full text indexing is not what you think that it is.
You want to index a column or columns not a table. Look in the SQL Server 2005 help files for info on how to do this.
Ian
|
|
|
|
|
Hi,
I want to know is the transaction log unique to SQL Server or it also exists in other databases like Oracle,MySQL, PostGreSQL etc. Also what information is contained in a transaction log? Moreover, can we read transaction log i.e. its contents and how can we restore a database using its transaction log?
Any help,article,link etc.
Regards,
Wasif Ehsan.
|
|
|
|
|
Almost all of the database servers use transaction logs (the name can be different in each product).
For example a simple access database uses transaction log in a separate file. You can see it if you open an access file with the access. A new file will appear in the same directory with ldf extension.
You can read about the sql server transaction log in the msdn library: http://msdn2.microsoft.com/en-us/library/ms345583.aspx[^]
|
|
|
|
|
We have a datetime issue.
The primary key uses a datetime data type of the primary key.
The times are different by more than 3 milliseconds. We have wait 15 seconds between inserts and it fails.
Are there any settings for the database or what not that would cause this behavior. ( we are not using smalldatetime either )
Thanks,
Nick
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
Datetime is not a valid primary key because two event can, theoritically have the same date time stamp. Consider revising the key.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Bad form!!!
A PK should ALWAYS be unique. A datetime data type can not be guranteed to be unique.
When was the last time you poured some wine for you and your sweetie and went out on the front porch to watch the geometry frolic on the lake?--Rebecca M. Riordan, Designing Effective Database Systems
|
|
|
|
|
Well I didn't choose this and I'm just the c# developer, but Its my task to find out why.
Thier argument is this. 2 inserts will never be done in less than a 15 second time frame so in theory it should be okay.
But, were still getting inserts.
Is there any documents that explain why this is bad, so I can share this with the DBA to get it changed?
And accorcding to the doc if a row is 1 second difference then it shouldn't matter.
Thanks,
Nick
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
I believe Ennis and I have given you the best reason, but if you need further explanation you can start here.[^]
When was the last time you poured some wine for you and your sweetie and went out on the front porch to watch the geometry frolic on the lake?--Rebecca M. Riordan, Designing Effective Database Systems
|
|
|
|
|
Ista wrote: 2 inserts will never be done in less than a 15 second time frame so in theory it should be okay
How can they be sure that this is always going to be the case? I'd never think of using a datetime as a primary key. It is bad practice.
I'd like to help but I don't feel like Googling it for you.
|
|
|
|
|
Well I agree with you I and I would never use datetime as a part of a key, but this is in production for 5 years before I got here. And yes the way it works, it would take a miracle from a higher power to create one that fast.
But, my delimna is that I know its wrong. But, I'm am merely the c# developer and its not good for a c# developer to tell the DBA ( which is the CIO ) that its wrong with out some sort of document to prove that its wrong other than some opinionated articles.
Even though, its wrong and I see why, it takes proof to change that and tell someone thier idea is faulty.
thanks
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
Ista wrote: Even though, its wrong and I see why, it takes proof to change that and tell someone thier idea is faulty.
Hopefully, your DBA/CIO should accept some constructive criticism that his or her idea could be improved. I wouldn't say it is faulty. Maybe five years ago using a datetime as a PK was okay, but I still wouldn't use it.
Blurb from Microsoft[^]
I'd like to help but I don't feel like Googling it for you.
Last modified: Thursday, August 17, 2006 1:21:30 PM --
|
|
|
|
|
1 insert every 15 seconds for 5 years = 691,00010 million (ID-10-T error) records so it isn't that large of a table. Append an autonumber, make the autonumber the primary key and add an index on the date field. It will take less time to implement the solution than to argue the merits of either case.
-- modified at 15:10 Thursday 17th August, 2006
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
yeah thats what I said. I told them to change it to an ID field and they told me that wouldn't make it unique.
I give up
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
Some people are stupid beyond help. For your situation try writing a before trigger that does a loop that expires 15 seconds before allowing an insert. That will eliminate the problem. Heavily comment why you did it so you will not be made fun of years from know when someone reads it.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Ennis Ray Lynch, Jr. wrote: Some people are stupid beyond help
I feel sorry for the situation he's in.
Ennis Ray Lynch, Jr. wrote: Heavily comment why you did it so you will not be made fun of years from know when someone reads it.
Start looking for a new job afterwards  Who knows what other b.s. will pop up 
too much daily WTF for someone... - Anton Afanasyev
|
|
|
|
|
Ista wrote: We have wait 15 seconds between inserts and it fails.
What is the error?
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
