Viewing 15 posts - 45,931 through 45,945 (of 49,571 total)
peace2007 (7/6/2008)
I'd like to monitor my stored procedures on another server. I think I should use SP_Counts or TSQL_SPs templates but what if I need a...
July 7, 2008 at 12:29 am
Doctor Who 2 (7/5/2008)
July 7, 2008 at 12:24 am
Steve Jones - Editor (7/6/2008)
I think the simulation path is the way to move. I know lots of people were tripped up on the 70-431 sims of SSMS.
Yup. Several of...
July 7, 2008 at 12:18 am
swtrans (7/6/2008)
July 7, 2008 at 12:08 am
Jeff Moden (7/6/2008)
I wonder how many questions they have on cursors now adays... If it's more than 5, I would flunk because I avoid them like the plague.
I don't actually...
July 7, 2008 at 12:05 am
That particular query shouldn't need tempDB space, as it has no query operators that require a work table. Sorts, hash joins, hash aggregates and other operators require space in TempDB....
July 7, 2008 at 12:03 am
Now we're getting somewhere useful.
Aprox how many rows would that query return? How many in the total table?
Ignoring covering for now (will get back to that once I have the...
July 7, 2008 at 12:02 am
Could you explain a bit more what kind of filtering you're trying to do?
July 6, 2008 at 11:23 am
Vivien Xing (7/6/2008)
I think MVP is more valuable than the certificate.
And significantly harder to get. Plus it's about different things. MVP is about community involvement more than anything
Congratulations Gail!...
July 6, 2008 at 11:23 am
Ok, I have to ask. Why are you truncating and shrinking your log file?
If you don't care about being able to restore to a point-in-time, set the database into simple...
July 6, 2008 at 6:27 am
Is there any blocking? If you look at the results from profiler, are certain queries slow and other not?
July 6, 2008 at 6:19 am
Hmmm. Probably not. Sorry, I missed that it was the people using the 2000 box that were having problems.
Yup, is a good time for profiler. Also maybe start up perfmon...
July 6, 2008 at 4:22 am
I believe it is 1000, though I have not seen that officially confirmed and I don't know anyone who's received that. (Best I've done is 984 on a VB exam...
July 6, 2008 at 4:17 am
Jeff Moden (7/5/2008)
That's where you and I may differ... I don't ask questions that appear on the certification...
Nor do I.
What I mean is that is someone says they...
July 6, 2008 at 4:16 am
rbarryyoung (7/5/2008)
Secondly, to do anything with this, we need to see the table definitions and the table relationships.
And for performance problems, the index definitions are also very important....
July 5, 2008 at 12:22 pm
Viewing 15 posts - 45,931 through 45,945 (of 49,571 total)