Viewing 15 posts - 2,281 through 2,295 (of 2,647 total)
Lon2012 (10/27/2011)
When I run this query I see two issues
1. If the project has forecast for some...
October 27, 2011 at 8:29 am
Change the LEFT JOIN to FULL JOIN. For the dimensions, I guess it depends on what your dimensions are... What would you be joining the dimensions to this on?
Thanks,
Jared
October 26, 2011 at 5:43 pm
Take a look at this article as well: http://blog.sqlauthority.com/2009/12/16/sql-server-fillfactor-index-and-in-depth-look-at-effect-on-performance/
Thanks,
Jared
October 26, 2011 at 2:19 pm
What are the fill factor settings for each of your indexes?
Thanks,
Jared
October 26, 2011 at 1:40 pm
GilaMonster (10/26/2011)
jared-709193 (10/26/2011)
"Log truncation frees space in the logical log by deleting inactive virtual log files form the start of the logical log."
Not quite correct.
Log truncation frees space in...
October 26, 2011 at 1:36 pm
Couple of things I would check, and I'm sure Gail will have a more concise reply 🙂
1. Make sure that you are SURE no shrinking is happening. It can...
October 26, 2011 at 1:28 pm
george sibbald (10/26/2011)
You just contradicted yourself. that's what truncation is. Marking the inactive part for re-use. If its not truncated its not reusable so the log is likely to grow.
"Log...
October 26, 2011 at 1:15 pm
GilaMonster (10/26/2011)
Sapen (10/26/2011)
Technically I dont see any stored procs under the programmability-->stored procedures folder of this database.Ok, which has what to do with DTA and your indexes?
Sorry, I asked...
October 26, 2011 at 1:08 pm
Here is another good link for you to look at http://www.sqlservercentral.com/articles/Performance/71001/
Thanks,
Jared
October 26, 2011 at 12:54 pm
george sibbald (10/26/2011)
Gus, I don't see that, you want log truncation, otherwise the log will just continue to grow.
I believe this is wrong. When a log backup is created,...
October 26, 2011 at 12:52 pm
Well, besides your indexes being fragmented you should look at the queries that are running slow. Performance is many times due to bad queries. Also, are your developers...
October 26, 2011 at 12:47 pm
Well there is your first problem 🙂 Can you rebuild your indexes at some time soon?
Jared
October 26, 2011 at 12:31 pm
Have you looked at the fragmentation of your indexes?
Thanks,
Jared
October 26, 2011 at 12:09 pm
Lon2012 (10/26/2011)
Hello GrasshopperI am not having any luck with this...pls let me know if you can help me
You still have not answered if you tried the query suggested. The logic...
October 26, 2011 at 12:08 pm
kstjacques (10/26/2011)
October 26, 2011 at 11:36 am
Viewing 15 posts - 2,281 through 2,295 (of 2,647 total)