Viewing 15 posts - 4,516 through 4,530 (of 6,216 total)
Thanks for the follow up. When you get the script going we'll have room for it in the script library!
Andy
April 10, 2002 at 4:53 pm
Nope, mostly IP connections for me. Are you rebuilding indexes regularly? I've seen latch waits if the db was heavily fragmented a couple times.
Andy
April 10, 2002 at 4:52 pm
Reset in SQL itself, or in the QA picklist?
Andy
April 10, 2002 at 4:51 pm
You can share one SQL login by embedding it in the app (password too if you want). The alternative is to use NT security where access is based on their...
April 10, 2002 at 10:34 am
I dont have enough hardware or data to find out for sure - my philosphy so far is to use filegroups only when I can't get it all on one...
April 10, 2002 at 10:32 am
Pretty interesting. No ideas yet on a good fix, a workaround would be to grab the logic from the proc and just dump into a new one you create that...
April 10, 2002 at 10:27 am
Once you know a pub is out of sync, you just right click it and select reinitialize. Then you can generate a new snapshot. A snapshot consists of a bcp...
April 10, 2002 at 10:25 am
You can attach a model.mdf copied from another server.
Andy
April 10, 2002 at 10:17 am
Yes, you need to run validation. It offers several options to set the depth of the validity check. I run one weekly but so far have never had an issue.
Andy
April 10, 2002 at 7:11 am
Glad you found the articles helpful. You need to set the login object to an existing user. As it is your login object doesnt exist in the db. You need...
April 10, 2002 at 6:43 am
Your choices are to store the file in the file system and the name of the file in the db, or put the whole file into a blob. Do a...
April 10, 2002 at 4:48 am
Long term you'll be better off putting all that data in one table and just adding a additional column to indicate which bank. No limit, more efficient than adding a...
April 10, 2002 at 4:44 am
Possibly even a bad NIC. Cheap enough to just replace it if it continues.
Andy
April 10, 2002 at 4:42 am
You'll need a 3rd party product like LogExplorer by Lumigent.
Andy
April 10, 2002 at 4:41 am
I'd recommend that if you're going to use an array that you dim it once outside the loop. Preserve is a fairly expensive operation if your list is of any...
April 10, 2002 at 4:40 am
Viewing 15 posts - 4,516 through 4,530 (of 6,216 total)