Since applications are so specific and individual, there really isn't a way to say what "recommended" IO levels are. The best measure is: Is the cost of running the...

Derek Dongray (5/20/2008)

---

I got this wrong, because I didn't stop and think, as I've actually encountered it in the past and now always declare VARCHAR parameters as larger than I...

Personally, I'd probably do it by hand to make sure I didn't miss anything. The way to avoid this in the future is create groups, instead of setting up...

I use a number of ApexSQL tools. Check out their web page (www.apexsql.com), see if there's anything you like. They have free trials for most of it.

With regard to backups, the key question is how much data can your business stand to lose?

If one week worth of data could be lost without difficulty, then weekly full...

I'd say the first thing to do is try running a few queries with "set statistics io on" and "set statistics time on". Look at the Messages tab in...

Michael Earl (5/19/2008)

---

Ok - I'll bite. If you put the two indexes on different file groups, and then put the different file groups on different physical drives, and then...

Would it be possible to dump the data out of a partition into a separate table, then dump the master, then reload from the separate table? Done correctly, this...

What's the Maintenance Cleanup Plan trying to do? Remove old backup files?

Crever, I've got maintenance plans that have been running smoothly since I set them up in September, and...

Access has an Upgrade Wizard that will directly convert the database to SQL. I've used it, and it works pretty well. Requires a little work on your part,...

That doesn't speed it up. It just removes the splash screen. For me, the...

Take a look at the Node function in SQL in Books Online. That ought to give you what you need.

I find myself in a position where I am plannning on starting job hunting soon. The company I currently work for is a very pleasant place to work. ...

Seriously, folks, the separate date and time fields in SQL...

My first thought was fragmentation and/or out-of-date statistics. The new heap table wouldn't have any fragmentation, so it makes sense it would be faster.