We can probably support the web space, don't know about letting them upload via Snitz - will have to see why we don't right now. For now if anyone wants...

Well said. That reflects a lot of what we were thinking. The counterpoint (that we were thinking) is that technical material is hard enough to read/learn when written very clearly...

Deadlocks are bad no matter where they happen. You might try making the cursor local and read only.

Andy

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

My fault on the English - we haven't decided what to do just yet. Clearly if can't follow the article it's of no value, yet we don't have time to...

Are they indexed the same? The different might be in page splitting, you have very little free space per page in table A.

Andy

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

A simple way is to use write something to pick up the file into a string, pass into OpenXML. SQL also has some bulk load facilities for XML, we had...

I use the designer up front and stick with that if I can. It takes a lot of code to do what the designer does. Even if you need to...

BCP should generate its own header I think. You need something else?

Andy

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

Often an outer join will do it.

Andy

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

Im not much of an XML fan either, but in many cases the extra overhead is worth what you get out of it. Using the DOM requires you to read...

I use the tickler file myself. If you're really concerned that you don't have it all, put the file length in the tickler. You can also list all files concerned...

I dont know that its a ridiculous limitation. Cascading deletes are there for precisely this case, to save writing a lot of extra code in the triggers. Once you decide...

To distribute the server you'd have to deal with licensing, and even then its better handled as separate installs (one for your app, standard one for SQL). Unless you're using...

Sounds like a bad client install - try rerunning just the client tools portion.

Andy

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

I've made it a practice to qualify everything. I think it's better coding regardless of performance implications. I think it does affect performance still, without a table owner at any...