Viewing 15 posts - 12,316 through 12,330 (of 22,214 total)
Look up sp_changedbowner in the Books Online. That will let you change the database owner to another login and then you can drop hers. I would recommend dropping her login...
June 14, 2011 at 4:25 am
As long as the login isn't mapped to users that own objects or databases, sure you can drop it. But I would check the ownership very carefully before you drop...
June 13, 2011 at 7:39 pm
And with all that, now it's going to be even harder trying to figure out why you're getting performance differences and where those differences are coming from. I hope you're...
June 13, 2011 at 6:11 pm
61 different statements... You're on your own.
I will note that statement 7 & 8 (two of the highest, one in ON & one in OFF) both show ANSI_WARNINGS set to...
June 13, 2011 at 5:08 pm
todinhkhoi (6/13/2011)
Thank you for the instructions. I followed them, and finally I was successful in retrieving the data I wanted. I have another 2 questions...
June 13, 2011 at 5:00 pm
Jack Corbett (6/13/2011)
Thanks for the congratulations. I'm looking forward to the new opportunities and challenges. ...
June 13, 2011 at 4:55 pm
Yeah, it's a valid approach. Just as long as you know that those procs are cache dependent which means you could lose queries as they age out of the cache,...
June 13, 2011 at 4:53 pm
Are you getting different execution plans depending on if it's on or off?
June 13, 2011 at 1:48 pm
sql_handle is how you connect to sys.dm_exec_query_text.
If you're concerned more about procedures, in 2008 you can use sys.dm_exec_procedure_stats. Not available in 2005, but it is 2008.
June 13, 2011 at 1:46 pm
Sorry, I can't help you there. I don't have a 2000 instance available any more to test it out. You might try posting in the 2000 forum.
June 13, 2011 at 1:00 pm
Plus, there is no one, perfect answer. So you set the MAXDOP to 1 and "fix" the CXPACKET problem, but now you've got queries that are taking forever because they...
June 13, 2011 at 12:56 pm
I wouldn't mess with all the aggregations. sys.dm_exec_sql_stats is an aggregate of the performance already. You won't get differences. Also, why are you using that function instead of sys.dm_exec_sql_text and...
June 13, 2011 at 12:50 pm
Yep, you could hit issues. Also, the recommendations might include statements (such as the INCLUDE statement, ha) that won't work on 2000. There was a tuning advisor for 2000 databases....
June 13, 2011 at 12:46 pm
Thought I'd share. My wife ordered this book and I finished it just now. Having dealt with a problem sleeper (and still dealing with him at age 13), this thing...
June 13, 2011 at 12:42 pm
Jack Corbett (6/13/2011)
June 13, 2011 at 12:32 pm
Viewing 15 posts - 12,316 through 12,330 (of 22,214 total)