One way to do it since you have a constant connection is to just insert it directly into SQL. You can do this easily by linking to the SQL tables....

One way is to set concat_null_yields_null off. A better approach is to test each value with isnull and convert it to an empty string.

Andy

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

SQL Mag had a comment about this a while back, dont have the link handy but as close as I remember with the grid it comes back all at once...

It makes sense that if you move processing that was done on the client (like a cursor type op) to a stored proc you will increase utilization of the server....

Havent looked at the tool, not sure that network monitoring will add much...but never know!

First think I noticed is that the second query is using a hash join, first is...

No reason it wont work, same issues as with any other asp, have to work harder to not maintain state, also have to evaluate the security of the solution closely....

You'll definitely take a performance hit like that, you could be creating thousands of objects to load the treeview. Think about how Explorer works, it only loads files in folders...

Maybe. I try not to run a lot of stuff on the server itself, most of the heavy tasks are run from a dedicated client machine.

Andy

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

I wouldnt think it would be VB - performance should be about the same in any language, work is done in the COM object. That's not to say that you...

Good question. I guess it would depend to what extent you're using the framework on the server.

Andy

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

DTS would work, though maybe more than you need. Sounds like a simple update statement running in a TSQL job step should do the trick.

Andy

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

I've only installed it so far on my workstations running developer edition. No issues at all.

Andy

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

Thanks for the follow up Steven.

Andy

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

From what I could find you "striped" the backup. Take a look at this thread:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=%23lWnpTkoAHA.1456%40tkmsftngp03&rnum=7&prev=/groups%3Fq%3Dsql%2Bserver%2BThe%2Bmedia%2Bset%2Bonly%2B1%2Bare%2Bprovided.%2BAll%2Bmembers%2Bmust%2Bbe%2Bprovided.%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D%2523lWnpTkoAHA.1456%2540tkmsftngp03%26rnum%3D7

Andy

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

Try this:

exec master..xp_logininfo N'builtin\administrators', N'members'

Andy

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