Viewing 15 posts - 6,151 through 6,165 (of 6,210 total)
Are you saying that there can be NO blocking with simultaneous execution of the same sp?
July 19, 2001 at 9:06 am
It is in the Backoffice Resource Kit (BORK) 4.5. I dont know if its available as a general download - if you're an MSDN subscriber you should be able to...
July 19, 2001 at 9:05 am
I've used the MS Load Simulator tool - it lets you run a script on a bunch of different threads from the same machine, variable interval and #active threads. We...
July 18, 2001 at 6:46 pm
Gotcha. So what is the extent you refer to?
July 18, 2001 at 12:49 pm
Im sure there is a cost associated with it - how much probably depends on which operation you're doing. I'd guess left is likely to optimize much better than right...
July 18, 2001 at 12:47 pm
It depends. Indexing is pretty complex. Even if a single index by itself doesnt have good selectivity, it may work in concert with another index. Start by indexing all your...
July 18, 2001 at 12:43 pm
I get the same error. I dont have desktop edition installed, I use Developer - not sure if that would make a difference. Found a Q note about the same...
July 18, 2001 at 9:24 am
Looks like it might be a service pack issue, take a look at this link:
Andy
July 18, 2001 at 8:49 am
Im curious too - why do you have the repeating fields (meat1, meat2, etc)? If you're taking the time to move it to SQL, why not normalize while you do...
July 17, 2001 at 7:47 pm
Keep in mind that object ownership is not a simple topic. There are plenty of valid reasons for letting users own their own objects..I think anyway!
My preferred technique is to...
July 17, 2001 at 7:44 pm
Could you tell us why you need to do this? Im a firm believer in integer keys, faster and simpler. If you're concerned about key conflicts from multiple locations, uniqueidentifers...
July 17, 2001 at 9:23 am
Unless you made them part of dbo (dbowner), the objects will get named like this:
Barbie.table
Ken.table
Rather than
dbo.table
I avoid ownership chains - rarely worth the hassle. You can fix them after the...
July 17, 2001 at 9:20 am
You sure it's not a server based virus scan running? Or someone accessing something via the network? How about logging in locally to the machine to try the install? Might...
July 17, 2001 at 9:16 am
Let us know how it turns out.
Andy
July 17, 2001 at 9:14 am
Viewing 15 posts - 6,151 through 6,165 (of 6,210 total)