Look at it on the bright side - being "invaluable" means lots of consulting (and NOT for free, for real) once you leave... You might even get paid what...

Depending on your load, you might care to drop all indexes EXCEPT the clustered. MS' case study on the matter seems to think that that tends to be the...

Of course - if your block size is 32 (like you mentioned) and your file sizes aren't an even increment of said block size - wouldn't your alignment be all...

Paul Randal (1/26/2008)

---

Beware of rebuilding all indexes in a database every day as many people do - you should only be removing fragmentation when that fragmentation is contributing to workload...

Nice in-depth article.

Just curious - do you have any metrics as to how efficient this is? DTS has gotten a black eye in the past as to being less...

You certainly can. You just have to introduce multiple steps into your SSIS project. You're going to want to read up on it. Actually Andy Leonard put...

you've got some homework to do. Read up on xp_sendmail.

Once you've done your updates, use the above procedure to send your mail. Books Online go over the syntax.

It seems to me that you'd need an index on (filename,typeID,status) with an include for (fpath). Give how big you have fpath - the include may or may...

Try cleaning up the @enddate before using it. In other words - assume that if the user didn't include a time component, they want all day. If they...

Gary - could you give us a sample of what you have in the TIME column?

Also - I'm not sure you're clear on this - but '1/23/2008' converts to 1/23/2008...

Again - without some specifics it's hard to advise you on anything. That being said - you might care to check out the NTILE ranking function, which should help...

The email profile SQL2000 uses needs to be useable from that account. In other words you need the e-mail profile to be based on the same credentials.

So the verdict is - remove all instances of "characters long"?

Reads a lot better when those are gone....

Edit: nevermind - it's friday afternoon. Coffee infusion seems to shed light...

In order to change editions, run the setup.exe from the command line with the option

SKUUPGRADE=1

It should ignore service packs, etc... and will allow you to change versions/editions.

Have you looked at ignoring the data errors or redirecting them to another table during import? That's one of the options you can set up on your Excel Data...