Viewing 15 posts - 196 through 210 (of 2,462 total)
You can use CONTEXT_INFO() .. to short circuit the infinte loop.
See the pseudo code
--Trigger on one side
declare @Context varbinary
SELECT @Context = context_info()
IF @Context = 0x35353535
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 30, 2013 at 4:39 am
Plz send any link.. if there is any detailed information on this
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 28, 2013 at 2:58 am
John Mitchell-245523 (9/27/2013)
Bhuvnesh (9/27/2013)
i dont think only SP definiton will provide much help here . Exec plan will be required.
Do you think so? The warning messages occur at...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 8:57 am
i dont think only SP definiton will provide much help here . Exec plan will be required.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 8:25 am
Yes.
There are a lots of chages in many DMVs structure. See http://blogs.msdn.com/b/sqlosteam/archive/2012/07/11/memory-manager-surface-area-changes-in-sql-server-2012.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 7:55 am
EddieN1 (9/27/2013)
Although as the Developer, I am allowed access, the System Administrator should not be.
Is it ???? then i totally discourage the rule/approach here .
Even you CANT restrict...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 7:02 am
mote.ajit2 (9/27/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 6:58 am
curious_sqldba (9/26/2013)
Now in my nc index when i dont include C2 it is still using the right index, but when i dont include c1 it is not using the right...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 6:33 am
i also use Red gate sql developer bundle . its had great sub tools sql compare , data compare and intellisense also
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 6:09 am
jatighe (9/27/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 5:21 am
sqlnes (9/26/2013)
will select count(*) get the keep changed record numbers even if (nolock) hint is on?
Yes . it WILL count the dirty reads .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 5:16 am
Rem70Rem (9/26/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 27, 2013 at 4:35 am
Generally i read article or Ebooks but ther is one book whic make me desparate to purchase it "Sql server 2008 internals" by kalen daleney. i have tried...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 26, 2013 at 5:23 am
This wil help you http://msdn.microsoft.com/library/ms189121.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 26, 2013 at 5:00 am
JimS-Indy (9/25/2013)
I found (after a long period of blind scrambling...) that my backup job from the previous night (4 AM) was locking something (Page Lock?)
So you are...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 26, 2013 at 4:24 am
Viewing 15 posts - 196 through 210 (of 2,462 total)