How much data is there? You could try creating a clustered index on date/month column and then when you load the data for the current month, ensure that the data...

Faiyaaz (2/3/2010)

---

I have a DTS Package which normally used to run for 30 min now takes 7hours to run, when I had a look at the fragmentation of the table...

can you post the table schema that you are loading into and also upload the text file with sample data. it will be helpful then someone can actually test it...

Ruprecht (2/2/2010)

---

Hello All,

I'm having a heck of a time figuring this one out. I have a text field that I'm storing the html for web pages. Some tags...

Gail,

I was just trying to make your exact same point. Assuming that TOP 3 without order by clause will get you the 3 records that were inserted first is a...

Sunil,

I have one question. Is "Id" column in the table an IDENTITY column? If that is so, then you can sort on "Id Desc".

If "Id" is not IDENTITY, then...

More info needed. What is it...

Further to what Jack said.

First, what is it are you trying to improve? I think you first need to list out issues with the existing database. Then figure out what...

Glad we were able to help you.

Without a date or timestamp in the table there is no way of knowing which is the last 3 records added to the table.

If you just want to backup the jobs, you can script the jobs.

Here is a link that shows you how to do it.

Script jobs

What happened to the test server? Do...

Thanks Dave.

Awesome. I am going to start thinking Tally going forward. Really cool.

Check this link that explains duplexing and RAID very well I thought.

Duplexing and RAID

Thierry,

Like George said, RAID is essentially will have the same effect. Only difference it is not managed by SQL Server.

Also, duplexing is just an extension of mirroring. There is a...

Doesn't xp_readerrorlog take some parameters. If you don't specify any of the parameters, then it reads only the current log file.

Error logs can be cycled either manually or by...