Yes, although there is a two-byte overhead for the variability, so storing "Test" would cost you 6 bytes. But if, for example, you were storing just state codes "AL",...

Also, choosing the appropriate data type (and scale) helps prevent absurd data from getting into your database - you know, dates that aren't proper dates, phone numbers with text in...

Another option, if you do regular random test restores of your databases, is to run DBCC CHECKDB on the restored version. Yes, you'll still need the same amount of...

Ralph

Use an error output in your data flow.

John

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