Viewing 15 posts - 41,791 through 41,805 (of 49,562 total)
It means that the database has been closed and the when it was closed SQL was able to finish all transactions and write all dirty pages to disk. Hence no...
January 12, 2009 at 2:11 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic634841-17-1.aspx
January 12, 2009 at 1:40 pm
The_SQL_DBA (1/12/2009)
USE msdbSELECT TOP(30) OBJECT_NAME(object_id), rows
FROM sys.partitions
ORDER BY rows DESC
How's that going to find what's filled the transaction log up?
January 12, 2009 at 1:39 pm
SanjayAttray (1/12/2009)
Instead you can put msdb, model and master database in simple recovery mode and take full backup every night.
Just bear in mind that if you put Model into...
January 12, 2009 at 1:36 pm
madhu.arda (1/12/2009)
January 12, 2009 at 1:32 pm
What SQL's probably doing is a seek on index 1 that retrieves all the rows that match on first name, then a seek on index 2 to retrieve all that...
January 12, 2009 at 1:27 pm
Jean-François Bergeron (1/12/2009)
From what I read in the plan, the only predicate it uses is the first Part : Like 'A/P%', how about the 's' that is after?
There should be...
January 12, 2009 at 1:00 pm
Ariadne (1/12/2009)
Gila: This is an OLTP system if that helps any. Found out the server have AMD 2-socket 4-core 2210 mhz processors resulting in 8 CPUs total.
If it's OLTP then...
January 12, 2009 at 12:52 pm
Try it and see.
If you have a table with an index on a string column, you run a query of that form and check the execution plan, you'll see exactly...
January 12, 2009 at 9:35 am
Jackal (1/12/2009)
Thanks for the response, the SQL logs show the error occuring at 6.01pm
Can you post the full message that was in the log?
Anything in the windows event logs?
January 12, 2009 at 9:26 am
Jean-François Bergeron (1/12/2009)
How does a like react?
If there's a wildcard, it's treated the same way as a between.
LIKE 'A%' becomes >= Scalar Operator('9þ') AND < Scalar Operator('B')
How does a greater...
January 12, 2009 at 9:23 am
With that row count, the noncluster's probably only 2 levels deep. As the table gets larger, you'll probably be able to see a small IO count difference between the two...
January 12, 2009 at 9:12 am
I'm debating what to replace my stolen 17" with. Despite the weight, I'm probably going to get another 17" laptop. I don't travel all that much and when I do,...
January 12, 2009 at 9:08 am
mhaskins (1/12/2009)
January 12, 2009 at 9:04 am
Jeff Moden (1/9/2009)
January 12, 2009 at 9:01 am
Viewing 15 posts - 41,791 through 41,805 (of 49,562 total)