This is how I understand the page I linked to: the CHECKDB operation is broken down into batches (unless you have TF2562 set - do you?) in order to avoid...

Do you have a small number of large tables in this databases, whereas in your other databases, the data is more evenly distributed between tables? That's one possible explanation....

Danny

You'd probably be better off using an error output in your data flow. You can start here.

John

What are the values of LNAME, FNAME and MINTL for those two rows?

John

I'm not writing the query for you - that's what you're paid to do. If you really don't want to do it yourself, just type "query to return backup...

1. Write a query that gets the information you need from the target servers

2. Use a Data Flow task to pull the query results into a table on your central...

What happens if the number of tickets is more than 5?

John

I'm afraid you need to do the hard work on this one yourself. Start here[/url].

Incidentally, I'd advise you to use an OUTPUT clause in your DELETE and UPDATE statements,...

Build the verification into your backup job, so it's done as soon as the backup is made.

By the way, VERIFYONLY only checks the file header. You might want to...

Physically separating data and log files is about more than performance - it's about recoverability, too. If you lose the disk that your data and logs are on, you've...

That stored procedure isn't going to return a result set, just some output parameters, so I'm a little confused. And given that startdate is an output parameter for the...

I can't see your report, so I don't really know what's happening. Does this stored procedure produce the main report, or does it just supply the parameters for the...

You need to set @startdate, @enddate and @fp as OUTPUT parameters in your stored procedure, don't you?

John

Have you considered a table-valued parameter?

John

drosa 15759 (7/27/2016)

---

Hola amigo tengo 7 grupos contando el Primary y dentro de cada grupo tengo un archivo ndf, quiero eliminarlos porque actualmente tengo un entorno de produccion dentro de...