Viewing 15 posts - 36,421 through 36,435 (of 39,950 total)
Haven't used them, but they are around the corner from me and hiring SQL DBAs.
Steve Jones
June 17, 2003 at 11:07 am
the sa/god problem is one that most people are concerned about, but a sysadmin has to be trusted with access. Of course, you should also be fired/sued if you abuse...
June 13, 2003 at 10:48 am
Might be. Perhaps there is some temporary file there. Can you move the location for backup files and then restart?
Steve Jones
June 13, 2003 at 10:44 am
IANAL - I am not a lawyer.
I searched out our security people and they said that the info sec policy that we agree to says that you do not have...
June 13, 2003 at 10:15 am
great advice above. One more I'd add - SQL Litespeed. Works great and has reduced our largest backup substantially in size and time. Went from 60G native to 9GB...
June 13, 2003 at 10:12 am
I'd use a view as well. Use separate dbs if they need to maniuplate the data separate from other users.
Steve Jones
June 13, 2003 at 10:08 am
Sorry haven't read it. Can you post your thoughts or write a review? We'd love to have it on the site. Send a review in email to me (sjones@sqlservercentral.com) if...
June 13, 2003 at 10:05 am
Remove guest from msdb and do not give him access to this database.
Steve Jones
June 13, 2003 at 10:00 am
The maintenance plan itself must be created, not just the jobs. PITA, and I'm sure there's a way to script out the plan, but I haven't bothered. They are pretty...
June 13, 2003 at 9:55 am
I don't ever see the *.ckp files in my backup folder. Checkpointing is an operation that writes out the transaction logs automatically and ensures data is on disk.
Steve Jones
June 13, 2003 at 9:51 am
Daily - Backups
Weekly - Integrity (dbcc), Patch application and testing.
Monthly - Baselining
Steve Jones
June 13, 2003 at 9:35 am
Don't use "select *", list out the columns you need. And only those columns.
Use ANSI syntax, makes things clearer, ex:
select a.colA, b.colB
from tableA a
...
June 13, 2003 at 9:33 am
sa might be mapped to a user. The login would be sa, the user something else.
select
u.name
, s.name
from sysusers u
inner join master.dbo.syslogins s
on u.sid = s.sid
Steve Jones
June 13, 2003 at 9:29 am
Very nice scripts. Need some modifications for me, but these are handy to have around.
Steve Jones
June 13, 2003 at 9:27 am
Which part of the maintenance plan? I suspect that either the plan didn't create correctly or there is corruption in sqlmaint.exe.
Have you dropped and recreated the plan? Can you create...
June 12, 2003 at 4:19 pm
Viewing 15 posts - 36,421 through 36,435 (of 39,950 total)