Viewing 15 posts - 5,971 through 5,985 (of 6,676 total)
The only thing I would add would be to make sure the joins are correct. Using outer joins (LEFT) will return all rows from TableA and only matching items...
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
October 28, 2008 at 12:59 pm
Not true, as can been seen from my example. The error goes away eventually; it works in redgate; I'm specifying database with 'use' etc.
I would bet anything that 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
October 28, 2008 at 11:27 am
Lynn, I knew what you meant - but, I was kinda having a bit of fun with you:
Sure, when you are creating the table, the first columns I'd define are:
ChangedBy...
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
October 27, 2008 at 7:40 pm
Jobs run under the SQL Server Agent process, which is running under the domain account. Just because the job is owned by 'sa' does not mean it is actually...
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
October 27, 2008 at 5:00 pm
Perry Whittle (10/27/2008)
disabling the indexes will help from a performance point and...
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
October 27, 2008 at 4:33 pm
GilaMonster (10/27/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
October 27, 2008 at 4:22 pm
Okay, now - we need to be just a bit careful with this. Found a couple of caveats we should be aware of before we start rebuilding heaps:
System tables...
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
October 27, 2008 at 3:47 pm
Well, of course that is where it would be. Stupid me - for some reason I saw ALTER INDEX not ALTER TABLE :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
October 27, 2008 at 3:39 pm
That is probably your answer - the domain account has privileges on both servers and the job is running under the domain account not the 'sa' account.
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
October 27, 2008 at 3:37 pm
Garadin (10/27/2008)
cpetersen (10/27/2008)
Hello Sir,How did you figure out what the columns in table t374 were
ie... C700002200 is Closed_date?
Thanks,
Carl
Considering the OP hasn't logged on in over a year, I have...
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
October 27, 2008 at 3:36 pm
A couple of other things to simplify the queries:
1) Alias the table/view references - use aliases in select and joins
Example:
SELECT t1.col1
...
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
October 27, 2008 at 3:34 pm
First, we can simplify your case statement with the following:
Declare @openTime Datetime;
Set @openTime = '2008-10-27 17:25';
Select dateadd(hour, datediff(hour, 0, @openTime) + 1, 0) As end_hour
...
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
October 27, 2008 at 3:20 pm
What user account is running SQL Server Agent?
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
October 27, 2008 at 3:00 pm
GilaMonster (10/27/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
October 27, 2008 at 2:57 pm
GilaMonster (10/27/2008)
stephen.wolfe (10/27/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
October 27, 2008 at 2:27 pm
Viewing 15 posts - 5,971 through 5,985 (of 6,676 total)