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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 27, 2010 at 8:27 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2010 at 8:51 am
sqlguy-549681 (4/25/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2010 at 4:52 am
Define 'last'
If you mean 'most recently entered', then you need some column that shows the order entered. Date inserted or an identity column. Order by that desc and use TOP
If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2010 at 9:31 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2010 at 8:00 am
Please read through this - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2010 at 4:43 am
Viewing 15 posts - 33,151 through 33,165 (of 49,552 total)