Viewing 15 posts - 17,566 through 17,580 (of 22,202 total)
Hmmm... Now I am confused. I remember seeing that in action, but when you run RECONFIGURE WITH OVERRIDE the cache gets cleaned out, so I couldn't have done it playing...
April 28, 2009 at 12:27 pm
I did it in the execution plan book. Let me look it up...
Damn, found a typo. I'm blaming you becuase I wouldn't have seen it otherwise...
Crap... Evidently I just lied......
April 28, 2009 at 12:19 pm
Looks like your statistics might be a tad off. The index seek operation that is taking up 86% of the cost shows an estimated 1 row, but is returning 65000....
April 28, 2009 at 11:42 am
Since SQL Server 2000 is off the main stream support path, how about the fact that if a mandatory security patch comes out that breaks 2000, you can't count on...
April 28, 2009 at 11:34 am
Can you save the actual execution plan as a .sqlplan file, zip it and attach that? Without all the underlying data it's hard to read an execution plan.
April 28, 2009 at 11:30 am
I'm sorry, I've never seen that one occur before. On a guess, someone did it. Especially if it's everywhere.
April 28, 2009 at 11:14 am
Yes. You can apply controls to it directly so that it only uses a single CPU and limited memory. It means that the auditors will actuall make less impact on...
April 28, 2009 at 11:00 am
Thinking about it further, would this be construed as a test system? Then you don't need to buy a license for it.
Either way, if you really have to let them...
April 28, 2009 at 10:11 am
sam (4/28/2009)
Grant Fritchey (4/27/2009)
Move to 2008 then you can put the Resource Governor to work along with some policy based management.
We're just finishing up our migration of 170 dbs to...
April 28, 2009 at 10:08 am
GilaMonster (4/28/2009)
Paul White (4/28/2009)
April 28, 2009 at 10:05 am
Oops. I misread what they had created. Sorry. I saw it as a compound index. My bad.
April 28, 2009 at 7:23 am
April 28, 2009 at 6:16 am
You might look at Change Data Capture. Here's an article on auditing on MSDN. That might help.
April 28, 2009 at 6:14 am
I've had 2000, 2005, 2008, and four different versions of Express all running at the same time on an XP box. No issues. Well, except that it's slow as hell...
April 28, 2009 at 6:11 am
Yikes. That won't be easy. I'd try using a UNION between each of the different databases, assuming you know what they all are. That way, any given query against any...
April 28, 2009 at 6:10 am
Viewing 15 posts - 17,566 through 17,580 (of 22,202 total)