Viewing 15 posts - 36,646 through 36,660 (of 49,562 total)
jeremym (9/1/2009)
If it is shrunk beyond the size it needs to be won't it just allocate more space?
Yes, and that will force transactions to wait while the log is expanded...
September 1, 2009 at 11:43 am
jeremym (9/1/2009)
From what I gather the the 0 is the same as unspecified and will decrease the file as much as possible.
Correct, but that is not a good...
September 1, 2009 at 11:20 am
Count the queries or add PRINT statements.
Did you check the articles I referenced? I'm sure this is mentioned in one of them
September 1, 2009 at 11:19 am
Apurva (9/1/2009)
I dont think even red gate has anyhting for readign the log. Not sure now.
They do, but only for SQL 2000.
September 1, 2009 at 11:03 am
rajdba (9/1/2009)
What you think we should do?
Wait or restart SQL. Those are your only options. Note that if you restart SQL and do not have 2005 Enterprise edition, the...
September 1, 2009 at 11:02 am
jeremym (9/1/2009)
I think what I am going to do is script it for an as needed use using the DBCC SHRINKFILE (N'DBName_LOG' , 0, TRUNCATEONLY) command.
No!
Firstly, truncateonly is...
September 1, 2009 at 10:30 am
Bob Hovious (9/1/2009)
Good luck with your 2 a.m. presentation, Gail.
What 2am presentation?
p.s. right thread for this question?
September 1, 2009 at 10:26 am
Elliott W (9/1/2009)
September 1, 2009 at 10:19 am
Elliott W (8/31/2009)
If you stop and start SQL I can almost guarantee your database will be corrupted.
Not at all. If you stop SQL and restart it, it will still...
September 1, 2009 at 10:16 am
sudhanva (9/1/2009)
Since the column length/type in table is decimal(6,2), i dont want to change the precision and scale.
The biggest number that you can store in a decimal (6,2) is 9999.99....
September 1, 2009 at 10:14 am
timothyawiseman (9/1/2009)
Similarly, even if SQL is on a server by itself its apparent performance can be slowed down if there is heavy network traffic at the moment.
I've seen a SQL...
September 1, 2009 at 10:06 am
Alvin Ramard (9/1/2009)
24 Hours of PASS starts today and I did not get a good night's sleep last night. It's gonna be a fun 2 days.
Starts tomorrow for me,...
September 1, 2009 at 9:52 am
riga1966 (9/1/2009)
Gila,sp_help returns a whole bunch of grids.
Can I get results as Text?
Sure, switch output to text rather than grid.
You can use STATISTICS TIME to see which queries take what...
September 1, 2009 at 9:49 am
Cross Apply forces the subquery to be run once per row of the outer query. A simple join with ROW_NUMBER does not. It's very easy to see the performance characteristics...
September 1, 2009 at 9:48 am
Viewing 15 posts - 36,646 through 36,660 (of 49,562 total)