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...
Jared
CE - Microsoft
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
Jared
CE - Microsoft
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
Jared
CE - Microsoft
October 26, 2011 at 2:19 pm
What are the fill factor settings for each of your indexes?
Thanks,
Jared
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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
Jared
CE - Microsoft
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,...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
October 26, 2011 at 12:47 pm
Well there is your first problem 🙂 Can you rebuild your indexes at some time soon?
Jared
Jared
CE - Microsoft
October 26, 2011 at 12:31 pm
Have you looked at the fragmentation of your indexes?
Thanks,
Jared
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
October 26, 2011 at 12:08 pm
kstjacques (10/26/2011)
Jared
CE - Microsoft
October 26, 2011 at 11:36 am
Viewing 15 posts - 2,281 through 2,295 (of 2,647 total)