Viewing 15 posts - 5,866 through 5,880 (of 6,676 total)
pbreitenbeck (12/10/2008)
/* original code */
update MachineAudit set leaseNumber = b.leaseNumber
from MachineAudit a,
(select a.machineID, b.leaseNumber from MachineName a, LeaseInfoImport b
where a.machineName = b.computerName) b
where a.machineID = b.machineID
What this is is an...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 10, 2008 at 10:13 am
You are welcome.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 10, 2008 at 8:47 am
After each operation, you can issue the statement CHECKPOINT. You can review BOL at:
Basically, when you issue a checkpoint - all dirty pages are written to disk and the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 10, 2008 at 8:44 am
Jeff Moden (12/9/2008)
Jeffrey Williams (12/7/2008)
Instead of trying to fiddle with IGNORE_DUP_KEYS on the index, ...No "fiddling" required... it's set it and forget it. 😉
Well, that is true - but to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 11:11 pm
That is perfectly fine - because every one of us has been there before. :w00t:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 5:37 pm
You can start with these tables:
msdb.dbo.sysjobs
msdb.dbo.sysjobschedules
msdb.dbo.sysjobservers
msdb.dbo.sysjobsteps
msdb.dbo.sysjobstepslogs
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 3:09 pm
You can use the column 'is_system_named' in the tables:
sys.default_constraints
sys.foreign_keys
sys.key_constraints
sys.check_constraints
Not sure where you can find the same thing for indexes that are not constraints. I do know that you can...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 2:50 pm
Can't say that I have seen that kind of issue before. I know this is a stupid question, but have you verified that you are connected to the right...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 1:36 pm
Phil Auer (12/9/2008)
I have actually hand-type simple backup commands for different paths and different databases and none of the scripts executed properly.
I'm sorry for being a bit dense - but,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 12:54 pm
Grant Fritchey (12/9/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 12:42 pm
ISNULL (or COALESCE) is only required if the columns allow nulls. If the columns do not allow nulls, then you don't need it. For a column that contains...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 12:37 pm
Alan Vogan (12/9/2008)
I'm running a similar script and yes, it is WAY better to write your own optimizations. How do you handle the exception when the index contains one...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 12:28 pm
Jerry Hung (12/9/2008)
Select db_name()
,object_name(s.object_id) As ObjectName
--,object_schema_name(s.object_id)...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 12:23 pm
Grumpy DBA (12/9/2008)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 9, 2008 at 12:21 pm
There are a few problems with your datasets. First, you should never use '*' in production code - it will cause issues for you as soon as someone modifies...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 8, 2008 at 8:15 pm
Viewing 15 posts - 5,866 through 5,880 (of 6,676 total)