I do and it's fine even with >5k transactions a minute. You don't want to leave it running all the time and you want to capture only the items you...

I think it means "no operation was performed".

Have you right-clicked on SQL Server Agent.

Select Properties.

What do you show on Job System for Non-SysAdmins?

If you are able to then SSIS would be the route to try.

Does this link help at all?

I would use SHRINKFILE specific to the log file.

Whenever I have something like that happen I usually execute the following:

use master

backup log DB_NAME with truncate_only

use DB_NAME

dbcc shrinkfile(LogFileName, 5000)

GO

5000 is just...

Try this

david (5/3/2008)

---

I am working on the MCITP: DBA and am stuck on a problem in the XML practice for Chapter 8, Lesson 3. I installed the trial Enterprise SQL 2005...

I would think that as you are developing the queries that drive your app you would be able to design your indexes very effectively using some of those features. Don't...

I would do a little research and see if the selectivity of that column has anything to do with why it wasn't suggested.

Also, you could always put the index back...

When you run the Index Tuning Wizard are you running it against just one piece of code in query analyzer?

Did you tell it to do a thorough check? Keep the...

Did you try any of the scripts on here?

Also, you could download a trial of Idera's SQL Diagnostics Manager. It may or may not help you but it's been really...

Compare the results of running it under Database Engine Tuning Advisor(2005) and Index Tuning Wizard(2000). It's been a while since I tried that but it seems that I came back...

Isn't it true that a covered index will only be used when the column on the left is part of the query?

So a covered non-clustered index with all three items...

Anyone get anything like this? It still restores but it fails on this part. I've tried CURSOR READ_ONLY FOR but it didn't help.

Step Error Source: Microsoft OLE DB Provider for...