Viewing 15 posts - 196 through 210 (of 215 total)
Let me give a different perspective -- a non-technical one -- find out what your support people will say. In many shops, Solomon is going to be supported by...
November 3, 2002 at 6:11 pm
quote:
The other option is parallism. If you have a poorly performing query that has a query cost larger than your parallism threshold...
November 3, 2002 at 5:50 pm
quote:
In current activity in EM or sp_who in QA is tempdb showing a log backup taking place?
November 3, 2002 at 5:36 pm
One area where this comes up frequently is with web access (and occasionally other client/server access) to a SQL database.
User X hits the web server Y. Using IIS and...
October 21, 2002 at 5:44 am
I know nothing about FDA 21 CFR part 11.
It sounds like they are profiler traces (just from the fact you can see them with Profiler).
I'm not exactly sure what you...
October 21, 2002 at 5:37 am
Thanks for the pointer. You had adopted a similar approach (though much more complete) where you explicitly look for certain datattypes to decide which have one parameter (e.g. char)...
October 17, 2002 at 1:52 pm
sp_pkeys -- gesh... blush... thanks.
October 17, 2002 at 10:09 am
quote:
I am curious, how do you guys see the process is rolling back after you kill it?
October 16, 2002 at 3:32 pm
I guess I was hoping for the
ALTER TABLE x ALTER CONSTRANT MAKE UNNAMED
statement.
Naming them is straightfoward, and probably should start. We were doing them this way because...
October 15, 2002 at 5:55 pm
I should have been more specific. Here's an example in code.
Let me first explain that as we deploy an application on multiple servers, we do a couple things to...
October 14, 2002 at 7:15 pm
quote:
I am not certain I understand what you mean by "install MSDE on a Domain Server". Are you referring to the...
October 12, 2002 at 12:59 pm
I've heard (but in a quick look didn't see it documented) you cannot install MSDE on any server that had SQL on it. I have no idea what settings...
October 11, 2002 at 6:10 pm
After getting some confirmation I called Microsoft (no point in wasting a support call if I was doing something stupid).
Interestingly in talking with them we tried keyset and dynamic, which...
October 9, 2002 at 4:31 am
Re: I know how it feels to have no resolution
Well, while I'd love to know about the more general killed/rollback hang and what to do, I must say that...
September 27, 2002 at 10:44 am
Re "how long" the last was a 3 minute runtime (max) rolling back for 20 hours. 🙂
I had some free time and decided to call Microsoft. THey said...
September 27, 2002 at 10:12 am
Viewing 15 posts - 196 through 210 (of 215 total)