Viewing 15 posts - 33,151 through 33,165 (of 49,552 total)
The cached execution plan will be reused, providing nothing else has happened to throw it out of cache1. This may or may not be a good thing.
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
1) Schema change, stats...
April 27, 2010 at 9:39 am
If the index was corrupt then, depending on the type and severity of corruption, a drop/recreate of the index could well have fixed it or simply deallocated the corrupt page....
April 27, 2010 at 8:27 am
April 25, 2010 at 9:54 am
One thing you could do, what was done with the last Itanium server I worked with, is to set up a second server, an x86 or x64 machine with a...
April 25, 2010 at 8:51 am
sqlguy-549681 (4/25/2010)
April 25, 2010 at 8:48 am
x64 or IA64 (Itanium)?
If Itanium, there are some things to consider re drivers and utilities. x64 code won't run on an Itanium, so you have to get Itanium versions of...
April 25, 2010 at 4:52 am
Other stuff running on the server, network delays, etc. You haven't given any numbers, but if the differences are small, then they can be ignored. Generally one would run queries...
April 24, 2010 at 9:23 am
thava (4/24/2010)
i didn't know which one is better
Which one ran faster? Which one used hte least CPU? Which did the least IOs? Use either SQL profiler or STATISTICS IO and...
April 24, 2010 at 8:23 am
Why don't you run them and see which is fastest? If you find one is faster/slower and you don't know why, post the execution plan and someone's sure to have...
April 24, 2010 at 8:00 am
April 24, 2010 at 7:41 am
The time it's taking has nothing to do with the schema lock. As I mentioned, all queries (select, insert, update, delete) take schema stability locks.
What's the query? How big's the...
April 23, 2010 at 5:57 am
You're trying to add a row with a primary key value that already exists. What's the primary key for that table?
This isn't a result of a restore, unless you restored...
April 23, 2010 at 5:56 am
richardd (4/23/2010)
One small suggestion - you can sometimes work around the 8921 Check Terminated message by specifying the WITH TABLOCK hint on the CHECKDB command:http://kbalertz.com/960791/Error-message-CHECKDB-command-computer-contains-Server.aspx
Yes, but that's in a very...
April 23, 2010 at 5:53 am
No, inadequate licensing will not cause performance problems, it'll just get you hit with a fine when Microsoft does a software audit.
April 23, 2010 at 4:43 am
Viewing 15 posts - 33,151 through 33,165 (of 49,552 total)