Viewing 15 posts - 5,896 through 5,910 (of 6,676 total)
antonio.collins (12/4/2008)
i misinterpreted it and thought he wanted the the current status and the prior status (which is a requirement we often have to meet with history tables).
Yeah - I...
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 4, 2008 at 11:20 am
antonio.collins (12/3/2008)
Jeffrey Williams (12/3/2008)
;With history (regid, status, history_date, rn)
As (Select reg_id
,status
...
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 3, 2008 at 4:18 pm
Your data file is restricted - what is the max size allowed? What is the auto-growth increment? How large is the transaction log (goes to determine how much...
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 3, 2008 at 4:14 pm
Is this what you are looking for?
;With history (regid, status, history_date, rn)
As (Select reg_id
,status
...
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 3, 2008 at 4:04 pm
Tempdb will grow as large as is needed to support the queries being run on your system. Once the database has grown - it will not shrink until you...
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 3, 2008 at 3:42 pm
Bummer - my new slingshot is back-ordered. Should be available and delivered in the next 6 to 8 weeks, shipping & handling charges extra (of course) :hehe:
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 3, 2008 at 2:37 pm
If the only thing the process is doing is inserting data into table variables and/or temporary tables, and then selecting from those tables - then there is no reason 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 3, 2008 at 2:35 pm
Review the following:
Select dateadd(month, datediff(month, 0, current_timestamp), 0)
,dateadd(month, datediff(month, -1, current_timestamp), -1)
,dateadd(month, datediff(month, -1, current_timestamp) -...
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 3, 2008 at 2:24 pm
Naw - have plenty of pork chops, I just need something to sling them with :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 2, 2008 at 10:22 pm
One thing you can try is adding a clustered index to those tables. Once the clustered index has been built, you could then remove it if you really need...
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 2, 2008 at 5:14 pm
I am still curious as to why you need to know if a parameter was passed in or not. It really shouldn't matter.
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 2, 2008 at 4:52 pm
No way that I am aware of. Why would you need to know that information anyways? If you are going to do something different based upon whether or...
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 2, 2008 at 2:58 pm
Also verify what level you are at in Object Explorer. You will see different reports available based upon where you are at. For example, you will see 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 1, 2008 at 4:04 pm
If your intent is to strip the time (or zero the time), then try:
SELECT dateadd(day, datediff(day, 0, DateColumn), 0);
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
November 30, 2008 at 6:18 pm
nbaghm (11/29/2008)
This the full error message:Message
Executed as user: GIS-SV01\SYSTEM. ...on 9.00.3042.00 for 32-bit
Okay - this version is the initial SP2 that was released. You should be on a minimum...
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
November 30, 2008 at 10:47 am
Viewing 15 posts - 5,896 through 5,910 (of 6,676 total)