Viewing 15 posts - 3,871 through 3,885 (of 6,216 total)
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....
July 6, 2002 at 1:28 pm
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
July 6, 2002 at 1:20 pm
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...
July 5, 2002 at 2:46 pm
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....
July 5, 2002 at 2:44 pm
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...
July 5, 2002 at 1:11 pm
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....
July 5, 2002 at 11:23 am
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...
July 5, 2002 at 9:39 am
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
July 5, 2002 at 7:16 am
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...
July 5, 2002 at 6:15 am
Good question. I guess it would depend to what extent you're using the framework on the server.
Andy
July 5, 2002 at 6:13 am
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
July 5, 2002 at 5:14 am
I've only installed it so far on my workstations running developer edition. No issues at all.
Andy
July 5, 2002 at 5:12 am
July 4, 2002 at 1:32 pm
From what I could find you "striped" the backup. Take a look at this thread:
Andy
July 4, 2002 at 5:36 am
Try this:
exec master..xp_logininfo N'builtin\administrators', N'members'
Andy
July 4, 2002 at 5:31 am
Viewing 15 posts - 3,871 through 3,885 (of 6,216 total)