Viewing 15 posts - 21,196 through 21,210 (of 22,196 total)
Bad news. I just ran this little in 2008:
goto MyLabel
exec sp_who
Mylabel:
It's STILL there. I'm planning on being in Seattle in November for PASS... I'll brink an Ozark Tire Thumper and...
January 18, 2008 at 8:24 am
I agree. We work with XML a lot out in the applications, but the database mostly just returns regular old result sets.
However, if you really had to, in addition to...
January 18, 2008 at 8:13 am
You can run DBCC OPENTRAN('dbname') to verify that there are no open transactions. Run the Activity Monitor will also let you know if a transaction is still open in the...
January 18, 2008 at 8:09 am
Tell them the truth. Anything else will get you into trouble.
"I've been working for these insane college kids at this dot com and I can't stand it any more."
I used...
January 18, 2008 at 7:55 am
Oh man, don't they have to kick you off the boards for 8 months like Don Imus if you use language like that?
January 18, 2008 at 7:42 am
I still don't understand the problem fully, so I'm not sure I can help.
The second line is just a short cheat that's available with the "go" statement that makes it...
January 18, 2008 at 6:01 am
The way I did it early in my career was answer as many questions for my peers as possible. Then I'd take the question & answer to the guys I...
January 17, 2008 at 12:30 pm
Hey Sandy,
Can you simply use a WHILE loop?
WHILE [SomeCondition = TRUE]
BEGIN
EXEC sp_proc
[Change Condition]
END
Or do you need something more like:
exec sp_who
go 5
Putting the number next to the GO statement will make...
January 17, 2008 at 7:01 am
Hey Sandy,
Sorry I'm late to the game, but everything Jeff said goes double for me. 😀
January 17, 2008 at 6:56 am
The two things I saw that stood out was that there was a join without a predicate. That's usually not a good thing. Joins, for the most part, should have...
January 16, 2008 at 1:13 pm
I know I sound like a broken record sometimes, but have you looked at the execution plan to see which operations are specifically causing the most problem? That will lead...
January 16, 2008 at 10:56 am
Embarcadero ERStudio, but I wouldn't be swallowing when you see the price on that one either.
Great tool. Decent company.
January 16, 2008 at 10:28 am
Nothing to be sorry about. You'll just get quick responses because it's going to be seen by a wider audience.
January 16, 2008 at 8:47 am
Viewing 15 posts - 21,196 through 21,210 (of 22,196 total)