Viewing 15 posts - 6,406 through 6,420 (of 6,676 total)
Definitely option 2 - since reindexing an empty table doesn't do anything. What I normally do is:
1) Disable all non clustered indexes
a) ALTER...
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
July 1, 2008 at 10:34 pm
MSDASQL x64 driver is available at: http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en
I have downloaded this and was able to connect to Intersystems Cache using it.
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
July 1, 2008 at 1:35 am
Steve Jones - Editor (6/30/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
June 30, 2008 at 1:37 pm
[quote-02008-06-30 01:00:28.46 Backup BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.
...
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
June 30, 2008 at 12:52 pm
Chris,
Glad I could help point you to a possibly different solution. Not sure if it will work out fully, so try it out and let us know if 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
June 29, 2008 at 8:51 pm
Yeah, I know - sometimes it is better to leave extra variables so the process is a bit more self-documenting. And yes, I do that often enough myself...
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
June 29, 2008 at 8:48 pm
rbarryyoung (6/29/2008)
Jeff Moden (6/29/2008)
... and, come to think of it... I think 1 Order By in the CTE will probably be enough, as well. 😉
I'll need some convincing on that...
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
June 29, 2008 at 6:08 pm
In your DTS package, you will have at least one connection to a database. I have seen a lot of people using local/localhost and a SQL account (generally, 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
June 29, 2008 at 5:41 pm
The more I think about this, the more I am convinced that you are going down the wrong path for how to create this report. You really shouldn't be...
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
June 29, 2008 at 5:04 pm
Mark (6/28/2008)
/* ItemsSold */
(SELECT SUM(item_qty) FROM FactOrder WHERE date_purchased_key = @dateKey) as TotalItemsSoldDay,
(SELECT SUM(item_qty) FROM FactOrder WHERE date_purchased_key >= @fWeekBeginKey AND date_purchased_key <= @fWeekEndKey)...
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
June 29, 2008 at 11:36 am
vidhya sagar (6/28/2008)
I had a doubt then, Suppose if the user drops SP @ 9:00 and full backup happens @ 10:00. Is it possible to read the tlog using...
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
June 29, 2008 at 11:19 am
You will see his error if your client tools are not at the same level (or higher) than SQL Server, or if SQL Server is less than SP2 and your...
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
June 29, 2008 at 11:07 am
First, let me say that I am not a programmer and don't really know VB.Net that well. With that said, I don't see anything wrong with the T-SQL that...
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
June 29, 2008 at 10:59 am
Since this is the default instance, you can type in one of the following to connect:
.
(local)
localhost
computername
Another option is to browse for more in the drop-down. That should give 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
June 27, 2008 at 11:48 pm
Mani Singh (6/26/2008)
So I only keep 1 days...
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
June 27, 2008 at 2:42 pm
Viewing 15 posts - 6,406 through 6,420 (of 6,676 total)