Viewing 15 posts - 1,516 through 1,530 (of 6,216 total)
Gary, thanks for the kind words. Any chance you could genericify that best practices document and submit as an article (or two)?
Andy
October 1, 2003 at 5:55 pm
I agree about the comments and I'll take the blame - I load the content, should have gotten it cleaned up. I'll try to do better!
Andy
October 1, 2003 at 5:26 am
Didnt have a need to at the time. In my eval, everything worked. Biggest complaint I had about both products (which may have changed) was the lack of integration into...
October 1, 2003 at 5:24 am
October 1, 2003 at 5:24 am
ADO is a lot easier, look for references to the ADO Stream object. Old way was getchunk/appendchunk (in ADO).
Andy
October 1, 2003 at 5:20 am
I'm going to a follow up to hit on the object naming thing a little harder - you guys are right, spaces arent the only bad thing. Just particularly objectionalble...
October 1, 2003 at 4:46 am
Also, a low budget solution is to mark your backup folder as compressed using the NT attributes. It's slow - I saw about a 350% increase in the time required...
September 30, 2003 at 5:30 pm
From what I understand LiteSpeed compresses on the fly and does not write an intermediate file to disk.
Andy
September 30, 2003 at 5:29 pm
SQL Up "simulates" a cluster via SQL replication - thats why you need the guids, to support replication. I've seen a demo, it seemed to work very well. Note that...
September 30, 2003 at 5:28 pm
Run a presnapshot script that would drop any indexes, make other changes you want before the data gets loaded maybe.
Andy
September 30, 2003 at 2:16 pm
Brute force - how about rolling back any transaction that makes that type of change with an error message?
Andy
September 29, 2003 at 8:04 am
Not handy. The fun part is because you can't use text as a local var type, there is no way to load it that I know of except outside TSQL....
September 29, 2003 at 7:19 am
Or just restore an entire copy of the db - sometimes faster, depends on how much data they really need. If you do the restore, make sure they have their...
September 28, 2003 at 1:53 pm
How else would it make sense to execute them anyway? I've had code in the past that would execute a proc from a list in a table, but the proc...
September 28, 2003 at 1:51 pm
All users are equal as far as processor time. You can make a user a member of the sysadmin role to give them "super user" permissions, but it doesn't change...
September 28, 2003 at 6:20 am
Viewing 15 posts - 1,516 through 1,530 (of 6,216 total)