Viewing 15 posts - 44,911 through 44,925 (of 49,571 total)
There are a couple different reasons for having multiple files in TempDB. I don't have specific numbers because they will be different for every system, depending how heavily it uses...
August 24, 2008 at 1:48 am
Jack Corbett (8/22/2008)
What build level are you at? I believe this is an issue related to procedure cache and that SP2 fixed it.
The proc cache pre SP2 could grow...
August 23, 2008 at 5:03 am
Functions aren't allowed to have side-effects, i.e. they aren't allowed to change the state of the database in any way.
It's so that when they are included in querues, it doesn't...
August 23, 2008 at 5:01 am
I believe that you need to restart the instance before the max memory takes effect. It certainly does work (and needs to be set) on 64 bit.
100 MB's a little...
August 23, 2008 at 4:50 am
Download the AdventureWorks sample database. It's availuable on CodePlex
It's a relativly complex database with a fair bit of data in it.
Link goes tto the page with the SQL 2008 versions,...
August 23, 2008 at 4:49 am
Duplicate post.
Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic557734-338-1.aspx
August 23, 2008 at 4:39 am
You can try reattaching the database. Depending on the corruption it might succeed.
Why no backup?
August 23, 2008 at 4:32 am
Perfectly normal. Rebuilding indexes means putting all the leaf pages down in order. next to one another. If there isn't space available to do that, SQL will frow the file...
August 23, 2008 at 4:31 am
jfbergeron (8/22/2008)
See the attached pictures, since I cannot attach the plan itself... =(
You can zip the .sqlplan file and attach the zip.
Any table variables involved? User-defined functions (scalar or...
August 22, 2008 at 1:21 pm
Did you detach the database?
Can you reattach it?
Do you have a good backup?
August 22, 2008 at 5:36 am
Arman (8/21/2008)
Please advise me that where i should replace, drop and put index.
I have absolutely no idea.
Indexes should be defined based on the queries that affect the tables. Without...
August 22, 2008 at 5:32 am
You can try them out on a test server and make sure that they are useful. Nothing else comes to mind.
August 21, 2008 at 12:19 pm
New_to_being_DBA (8/21/2008)
Also, I thought there was a correlation between avg_page_space_used_in_percent and avg_fragmentation_in_percent.
There isn't a direct relationship. The fragmentation % refers to the percentage of tables 'out of order'....
August 21, 2008 at 12:03 pm
Run profiler during busy times, say for a hour. Monitor the T-SQL batch completed and the RPC:Completed.
Once the trace has finished, look through and find 5 or so queries...
August 21, 2008 at 11:56 am
It's because the table has a small number of pages. Don't worry too much about the fragmentation on small tables )less than about 100 pages)
August 21, 2008 at 11:14 am
Viewing 15 posts - 44,911 through 44,925 (of 49,571 total)