Viewing 15 posts - 766 through 780 (of 2,462 total)
kiasystemsoft (11/26/2012)
I do not have information to help
we dont require any info from your side , just follow what John Mitchell-245523 explained above. and take help from any person...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 10:39 pm
means both servers are not same from data (even sql objects too ) perspective
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 4:33 am
naga.rohitkumar (11/26/2012)
HI can any one say what is the use of these1 SET SHOWPLAN_ALL ON
2 SET SHOWPLAN_ALL OFF
3 SET STATISTICS PROFILE ON
4 SET STATISTICS PROFILE OFF
Rohit...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 3:18 am
SSSsil174 (11/26/2012)
Example: If the result set like the below..
Clientid TagId NameD1D2D3D4D5
147American100050030000
148Hispanic0001000200
147American100050030000
148Hispanic0001000200
I want the result set like the following..
Clientid TagId NameD1D2D3D4D5
147American100050030000
147American100050030000
147...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 2:53 am
sanath.kumar.kura (11/21/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 2:50 am
see these links
http://wyerarch.blogspot.in/2010/11/sql-server-could-not-spawn-fruncm.html
http://blogs.msdn.com/b/sql_protocols/archive/2006/01/10/511330.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 2:46 am
kiasystemsoft (11/26/2012)
I can not speek English well
I have two fields
The account is a person
In each row I have a previous account
It may be that the debtor or creditor
If you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 2:23 am
sqlquery-101401 (11/25/2012)
where
(Name not like '%master%' and Name not like '%model%' and Name not like '%msdb%') or
(ISNUMERIC(Right(SUBSTRING(name,1,charindex('.',name)-1),8))=0) or...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 1:01 am
rajkiran.panchagiri (11/25/2012)
Hi Friends,Any update
have you checked with Sp_who2 and sp_lock that which seesions are got blocked for that particular database ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 12:58 am
can you explain a bit ? i am not clear as if you are adding or subtracting columns value :hehe:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2012 at 12:55 am
shohelr2003 (11/23/2012)
Will it cause any inconsistency in mirror databse? Or may I need restore database and log...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 25, 2012 at 10:53 pm
Jeff Moden (11/22/2012)
Either put the CI on the GUID with a decent FILL FACTOR to prevent rampant page splits during inserts
what would be that decent valure ? in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 22, 2012 at 11:38 pm
what other alternative we can take here instead of "!= "
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 22, 2012 at 11:23 pm
Perry Whittle (11/21/2012)
you could build your own using my handy guide at these links😉
thanks perry but my question was little different , i want a...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 22, 2012 at 11:08 pm
shohelr2003 (11/22/2012)
Now my question is if I restore a database to principal, should I go through the above mentioned steps? Or there are any alternate solution?
alternative option means ????...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 22, 2012 at 11:04 pm
Viewing 15 posts - 766 through 780 (of 2,462 total)