Viewing 15 posts - 1,066 through 1,080 (of 2,463 total)
i am using sql 2005 sp3 and database is in simple recovery model
June 22, 2011 at 6:49 am
sorry for late reply , i went for conference and came back today itself
so i ran
DBCC CheckDB with ALL_ERRORMSGS
and got below error
Msg 8921, Level 16, State 1, Line...
June 22, 2011 at 6:42 am
may be some tweak required here AND h.run_date > 2011-06-15
June 21, 2011 at 12:07 am
You can set the profiler trace. and see where its creating the issue?
June 21, 2011 at 12:03 am
thanks it has been resolved it happened due to some network issues.
June 10, 2011 at 2:30 am
there are is type of index adjustment rebuild and reorganize.
May 25, 2011 at 4:24 am
i dont think you can see "no of rows affected" when you use linked server query.
May 24, 2011 at 4:34 am
jineshpatel43 (8/28/2010)
I had a same problem few months back because one of developer Deleted one DB from our Production Environment.
DB dropped by developer ??? very strange thing. why...
May 23, 2011 at 2:33 am
xrapidx (5/20/2011)
I think we're misunderstanding each other.
i cant comment/suggest until i will see the query and index definition
May 20, 2011 at 6:39 am
xrapidx (5/20/2011)
currently any attempt has made the load process to slow, not sure if this is because of the exclusion of MONTH_END
YOu cant remove MONTH_END column from indexes.
May 20, 2011 at 6:23 am
xrapidx (5/20/2011)
Hi All1. When I create non-clustered indexes on the various tables, should they include MONTH_END?
That is not required because clus index will do the job here.
xrapidx (5/20/2011)
2. Currently,...
May 20, 2011 at 6:21 am
For you joining question i will go with B approach as it will use the indexes better.
Second YES you non clus index must have MONTH_END column as data will be...
May 20, 2011 at 5:00 am
i will send lutzm. i also feel that you are incomplete with requirement.
First gather the requirement regarding relationships or duplicacy of data.
second before pushing any thing on production first do...
May 16, 2011 at 2:27 am
i found you post a bit confusing.actually whosoever is logion into sql server , he/she can be traced by profiler.
May 4, 2011 at 6:15 am
Few additions to checklist
1. Check TempDB
2. Maintenance Plans
3. select some heavy resource consuming queries.
May 4, 2011 at 5:10 am
Viewing 15 posts - 1,066 through 1,080 (of 2,463 total)