Viewing 15 posts - 751 through 765 (of 2,462 total)
ranganathleo (11/29/2012)
how to identify the particular table being accessed now?
why you are only thinking about tables here ? there could be enormous cause for this degradation like hardware...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 29, 2012 at 7:44 am
MOC Ewez (11/29/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 29, 2012 at 7:36 am
PiMané (11/28/2012)
About FKs and indexes...If a FK has Col1, Col2, Col3 by this order is a Col1, Col2 index any good?
yes but always (not there, where col3 is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2012 at 9:14 am
WHat if we use SSIS to do this stuff more robust more tracable .. more comfortable to handle heavy volume data. i will welcome suggest on this suggest 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2012 at 8:54 am
i am surprised why not anybody refer here machine's event viewer(log ) or ot doesnt help in cases of vm machines :unsure:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2012 at 8:37 am
@rob-2 And Query ???
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 5:02 am
Rob Reid-246754 (11/27/2012)
whether the optimiser can decide for itself that too many clauses have been used and ignore the extra ones.
sql optimizer defintely choose only that index which is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 3:11 am
bleroy (11/27/2012)
just to make sure I understand:
You could essentially retrieve that unique record by using just 1 or 2 columns in your WHERE clause.
E.g. SELECT EMP_ID, NAME FROM STAFF_LIST WHERE...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 2:57 am
Soon any expert will be here (i would expect gail ) to give you clear and better picture
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 12:54 am
Rob Reid-246754 (11/27/2012)
Should I use WHERE Clause A or B?
obviously both are totally different as they contain different no and type of column's filer so i am 100 %...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 12:53 am
thanks gail
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 12:19 am
GilaMonster (11/26/2012)
allocation contention
Can you please explain this
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 27, 2012 at 12:05 am
see this http://msdn.microsoft.com/en-us/library/ms345414(v=sql.105).aspx
and also http://www.sqlservercentral.com/articles/Administration/64582/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 11:57 pm
hisakimatama (11/8/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 11:32 pm
Perry Whittle (11/26/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 10:41 pm
Viewing 15 posts - 751 through 765 (of 2,462 total)