Viewing 15 posts - 1,066 through 1,080 (of 2,462 total)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 22, 2011 at 6:42 am
may be some tweak required here AND h.run_date > 2011-06-15
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 21, 2011 at 12:07 am
You can set the profiler trace. and see where its creating the issue?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 21, 2011 at 12:03 am
thanks it has been resolved it happened due to some network issues.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 10, 2011 at 2:30 am
there are is type of index adjustment rebuild and reorganize.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 25, 2011 at 4:24 am
i dont think you can see "no of rows affected" when you use linked server query.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2011 at 6:15 am
Few additions to checklist
1. Check TempDB
2. Maintenance Plans
3. select some heavy resource consuming queries.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2011 at 5:10 am
I will second Lowell for this. actually whats your exact requirement.
meanwhile you can restrict user by limiting their permission at database level like SELECT, EXECUTE etc.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2011 at 2:31 am
Viewing 15 posts - 1,066 through 1,080 (of 2,462 total)