Brad's Sure Guides

RE: Create DB Users for New Databases

• by planet115

• Redgate

• Reply

Yes.

2003-06-20

RE: DBA's tasks in general (daily, weekly or monthly)

• by Allen-Cui-55137

• Redgate

• Reply

Read SQL Server 2000 Operation Guide at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp

2003-06-13

1 reads

RE: DBA's tasks in general (daily, weekly or monthly)

• by Steve Jones

• Redgate

• Reply

Daily - Backups Weekly - Integrity (dbcc), Patch application and testing. Monthly - Baselining Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

2003-06-13

1 reads

RE: DBA's tasks in general (daily, weekly or monthly)

• by Site Owners

• Redgate

• Reply

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

2003-06-13

RE: temp_db slow

• by GAURAV_BINDLISH

• Redgate

• Reply

Use Performance monitor over some period to see waht is the resource choking the performance of tempDB? Is tempDb on the same drive as OS files? Also is there any other application running on the system? As you have mentioned about fragmentation, go offline for few hours and defragment the drive. Its a good practive […]

2003-06-11