Viewing 15 posts - 1,516 through 1,530 (of 2,462 total)
Insufficient information provided i would say.
1) Check the error log
2) the processid is basically spid , so you could have checked that with "sp_who2 59" and "sp_lock 59"
and also...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 28, 2010 at 6:54 am
ssis learner__ (7/26/2010)
how to update millions of records quickly........
there is no precise solution/approach for this.
following are the things you can try.
1. use nolock( Warning :if possible)
2. do it in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 27, 2010 at 6:22 am
STherrien-978820 (7/27/2010)
Two inserts into the same history table, whose transactions start about 5 seconds apart from each other deadlocked.
separation is being done with some kind of Sql job ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 27, 2010 at 2:27 am
Then you can use sp_send_dbmail.and use the query parameter
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 27, 2010 at 1:30 am
this links contains many scripts , see which one can help you.
http://www.sqlservercentral.com/search/?q=transfer+the+logins
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 26, 2010 at 11:59 pm
2005_DBA (7/26/2010)
but not quite sure how to integrate db send mail with the query so that it send us an email if backup is not there.
Is the database mail configured...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 26, 2010 at 11:45 pm
try this
/*******************************************************
* SQL 2005 Extract Logins
* Hugh Scott
* 2010/01/06
*
* Description:
* Modified from the original to remove dependency on sp_VarbinaryToHex
* stored procedure. Other minor modifications as well.
*
* Modification History:
*...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 26, 2010 at 11:42 pm
Thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 26, 2010 at 5:30 am
Perry Whittle (7/26/2010)
Bhuvnesh (7/26/2010)
this is new to me. are you sure for it ?Yes!!
then what are the task/operations can be performed with disabled "sa" and with enabled "sa".?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 26, 2010 at 3:38 am
Sudeepta (7/23/2010)
If the sa account is disabled and the instance is running using Windows Authentication, still the job will execute.
this is new to me. are you sure for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 26, 2010 at 12:50 am
declare @deptid int
SEt @deptid = 24
if not exists ( select * from department where deptid = @deptid )
print 'department Doesnot Exist dude'
ELSE
update .....
Where deptid = @deptid
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 23, 2010 at 4:10 am
GilaMonster (7/22/2010)
Doesn't make a difference. The T-SQL parser removes all column references from an EXISTS very early in the execution process, before the optimiser gets the query for optimisation.
WHat, ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 23, 2010 at 2:16 am
i also tried it . datatime --> varchar ---> int . it worked because sql server allows varchar to int conversion only incase when column contains null values but...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 23, 2010 at 1:48 am
ipeepay (7/16/2010)
First of all I have to apologize for my English. It's my second language. I have a problem to do with my sql server 2005.
As...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 23, 2010 at 1:38 am
nuengharit (7/22/2010)
i imported many images in sql per week.
Well in this case , you can opt for SIMPLE recover model and take log backup on 15 min interval.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 23, 2010 at 1:34 am
Viewing 15 posts - 1,516 through 1,530 (of 2,462 total)