talentguy123 (7/1/2008)

---

We have a customer that is getting an extra file in their database

backup. this is not one of our nightly jobs. Can you please ID

where this job is run...

Also check the fillfactor on your indexes - could be causing lots of page splits if this is too high. Note: a value of 0 is almost equivalent to...

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...

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.

Steve Jones - Editor (6/30/2008)

---

Your maintenance plans should be running under specific accounts, likely the Agent account, but you could set it to a particular account and then run Profiler...

[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.

...

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...

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...

rbarryyoung (6/29/2008)

---

I'll need some convincing on that...

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...

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...

Mark (6/28/2008)

---

As an example, see if this helps

/* 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)...

vidhya sagar (6/28/2008)

---

[font="Verdana"]Hi Steve,

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...

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...

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...