Viewing 15 posts - 2,386 through 2,400 (of 6,216 total)
Not 100% sure that is true. In standard transactional you'll have some latency as you wait for the log reader to read the transaction, post it to distribution db (as...
March 17, 2003 at 6:43 pm
I've found the easiest way to stop the logreader is to find the name of the job and use sp_stop_job. I cheat and don't worry about being able to recover...
March 15, 2003 at 5:47 am
I think it depends on your comfort level (and any users querying directly) applying bitmap logic. Typically I'll go with individual bit cols. When you allocate a bit column internally...
March 15, 2003 at 5:41 am
You can do the same thing using .Net with a lot less headache (uses the same API I imagine). One thing you have to watch for is it will fire...
March 15, 2003 at 5:38 am
Haven't used Progress - can the data be accessed using an ODBC driver?
Andy
March 15, 2003 at 5:35 am
SAN is a pretty expensive way to store files. I guess it depends which files you value that much!
Andy
March 15, 2003 at 5:34 am
Missing constants definitely makes the reading/work harder - I guess DreamWeaver doesn't get the type library idea? No good idea on your problem, only thought that came to mind was...
March 13, 2003 at 3:33 am
We use Access for some stuff, have had no problems getting either type authentication to work. I think a good place to start is to make sure the user login...
March 12, 2003 at 9:28 pm
I'll try to look tonight, but a good way to resolve things like this is to do parameters.refresh, then iterate the collection to dump out all the property settings to...
March 11, 2003 at 12:45 pm
Do you get the timeout when you run the same select in Query Analyzer?
Andy
March 11, 2003 at 11:22 am
Lots of threads on this, I have an article up on why I like uniqueidentifers too.
Andy
March 11, 2003 at 11:21 am
Disk io and cpu time to start - is the server maxed out when you backup? Could also be that you have more data, that it's more fragmented (rebuilding indexes...
March 11, 2003 at 11:20 am
Didnt know that, great tip! Typically I write my code in VB, then port to VBS, so I never have echoes anyway. Glad it's helped. I've got at least one...
March 11, 2003 at 11:19 am
Two db servers and one mail server initially.
Andy
March 11, 2003 at 11:17 am
I think you're going to have to index, either on a dateadded col or adding an identity. I don't know for sure about the sp, but its definitely possible. I...
March 11, 2003 at 5:09 am
Viewing 15 posts - 2,386 through 2,400 (of 6,216 total)