Viewing 15 posts - 5,431 through 5,445 (of 6,678 total)
When the database is in simple recovery model, the transaction log won't be truncated until a checkpoint occurs. So, just issuing the commit transaction will not truncate the log.
Add...
April 10, 2009 at 12:20 pm
We also install the client tools on the server. It does not hurt anything, but when you need to do something and your PC is not available (with all...
April 10, 2009 at 11:25 am
Michael Valentine Jones (4/10/2009)
I decrypted and looked at a few of the procedures. They...
April 10, 2009 at 11:23 am
mister.magoo (4/10/2009)
Jeffrey Williams (4/9/2009)
Modify the where clause like this:
WHERE 1 = CASE
WHEN...
April 10, 2009 at 9:49 am
Are you asking whether or not you can shrink the transaction log? Yes.
The missing backup file - I am not sure what is going on there. Can you...
April 10, 2009 at 9:46 am
Edd (4/10/2009)
Thats what I'm wondering about?? Why didn't the transaction log shrink? Why is it still asking for the old file?
The transaction log won't shrink (get smaller on disk) just...
April 10, 2009 at 9:00 am
Torres (4/9/2009)
I'm trying to apply a filter which could have multiple values based on a user's selection (@Report). The problem is that I'm trying to place all of this...
April 9, 2009 at 9:24 pm
Torres (4/9/2009)
I'm trying to apply a filter which could have multiple values based on a user's selection (@Report). The problem is that I'm trying to place all of this...
April 9, 2009 at 9:21 pm
When SQL Server is running as the Local System account, the server credentials are used to create an SPN record. When you modified the service account to use a...
April 9, 2009 at 9:16 pm
One of the things you might want to consider is the catch all task in SSMS Maintenance Plans. That is, you have an Execute SQL Task available that will...
April 9, 2009 at 6:11 pm
Netapp has a utility call Snap Manager for SQL Server. This utility uses the VDI to freeze SQL Server and creates a snapshot of the LUN. There are...
April 9, 2009 at 5:57 pm
What are you min/max memory settings on both systems?
April 9, 2009 at 1:53 pm
Jpotucek (4/9/2009)
select a.towid,a.update_date,a.update_action,b.towid,b.presentdate
from modify_title.dbo.mat_audit_nbdoc as a left join towerdb.tower.nbdocdeletedrecords as b
on (a.towid = b.towid)
where
a.Update_Date >= '04/07/2009'
and a.Update_Date <...
April 9, 2009 at 10:43 am
Jpotucek (4/8/2009)
April 8, 2009 at 2:12 pm
Because that instance of SQL Server is running SQL Server 2000 (80) and not SQL Server 2005 (90) or SQL Server 2008 (100).
April 8, 2009 at 2:08 pm
Viewing 15 posts - 5,431 through 5,445 (of 6,678 total)