To follow up on that - as far as what the community expects, how do we determine (or do we) that someone is qualified to do the review? For example,...

Gibberish makes sense to me!

Andy

http://www.sqlservercentral.com/columnists/awarren/

From BOL:

When creating a database file on a raw partition, you do not specify the physical names of the files comprising the database; you specify only the drive letters of...

Not using either. So low tech! For those who might want to look more, see:

http://www.ipswitch.com/Products/WhatsUp/index.html

Andy

http://www.sqlservercentral.com/columnists/awarren/

Wish I had all the answers. I'd say one is to test a lot, set up and tear down, before putting into production. When it breaks, you want to know...

Have you considered sending in the params as an XML doc, then using OpenXML? Great way to avoid parsing.

Andy

http://www.sqlservercentral.com/columnists/awarren/

There's a trace flag that will pretty up the output in Query Analyzer - 257.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I dont think it gets used much. We've got one article on it:

http://www.sqlservercentral.com/columnists/sburke/introductiontoenglishqueryandspeechrecognition.asp

I think it's a great idea that has never hit critical mass.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I dont have it installed where I can test at the moment, but I don't think it's just you:

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&threadm=1ffb01c14283%24586cd140%24a5e62ecf%40tkmsftngxa07&rnum=2&prev=/groups%3Fq%3Dgibtab%26hl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D1ffb01c14283%2524586cd140%2524a5e62ecf%2540tkmsftngxa07%26rnum%3D2

Andy

http://www.sqlservercentral.com/columnists/awarren/

Each doc has a different format? If they are all the same structure, you could change the individual procs to return a standard resultset, then create the XML in a...

I'd go with with 8k or 64k, but have not tested enough to know for sure what the performance gain would be.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Steve,

What's going to be our policy about who can submit reviews?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Easy to test - just put a raiserror in the trigger, if VB receives the error message... Remember that the trigger is part of the transaction.

Andy

http://www.sqlservercentral.com/columnists/awarren/

It generates 5000 db requests? Almost no way to make that fast, just the overhead of 5000 network calls is going to slow it down. I think duration is pretty...

I think zip with max compression is usually better than cab.

Andy

http://www.sqlservercentral.com/columnists/awarren/