Viewing 15 posts - 1,876 through 1,890 (of 2,462 total)
sudhakara (4/16/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 16, 2010 at 3:32 am
Did you install it carefully (means got any error/warning during installation) ? i think you should get.
Is your login has required privledges ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 15, 2010 at 7:17 am
Are you using the same login to execute that job (i mean, any change in its database role) ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 15, 2010 at 5:43 am
Has this CD been used for sql installation earlier(in past) ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 15, 2010 at 5:33 am
dba-vb (4/15/2010)
how can i use execution plan/io/profiler one by one. when to check these is there any specific rule.
Profiler's Videos
http://www.sqlservercentral.com/articles/Video/66676/
http://www.sqlservercentral.com/articles/Video/63814/
for Execution plan
http://www.sqlservercentral.com/articles/Performance+Tuning/displayingexecutionplans/1103/
http://www.sqlservercentral.com/articles/Performance+Tuning/understandingexecutionplans/739/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 15, 2010 at 1:51 am
Try using single quotes. Also i think your row terminator is new line character followed by comma (,). I added comma in the row terminator. check that one also.
BULK...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 14, 2010 at 5:23 am
ychen 55059 (4/13/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 14, 2010 at 5:14 am
i dont think this suggested index is required here as clustered index itself fullfil the requirement
and also we should not blindly trust tuning advisor.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 14, 2010 at 4:50 am
Sasidhar Pulivarthi (4/14/2010)
The job should send mail that error log info...or successfull info....as attachment
check BOL for msdb.dbo.sp_send_dbmail
http://msdn.microsoft.com/en-us/library/ms190307.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 14, 2010 at 4:29 am
dba-vb (4/14/2010)
hi to all,if a sp is taking log time to execute how can check why it is giving log time.
1. Study execution plan
2. Read IO statistics
3. Refer...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 14, 2010 at 4:25 am
DML triggers only work for INSERT/UPDATE/DELETE operation on tables and DDL triggers work for schema changes on sql objects. So no help from triggers in your case
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 13, 2010 at 7:55 am
@Chandhini . if you post the syntax of your ALTER statement , we can try to give the cause of its failure
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 13, 2010 at 7:52 am
See this also http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/321bda9d-0971-47a1-b65e-ee01bdfb0fc1
http://www.bigresource.com/Tracker/Track-ms_sql-bfOhjw3U/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 13, 2010 at 12:46 am
chanti2985 (4/9/2010)
Error: 2010-03-24 07:01:25.99
Code: 0xC0012024
Source: ST_Enter JobID
Description: The task "ST_Enter JobID" cannot run on this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 13, 2010 at 12:41 am
saghbash (4/3/2010)
how can I speed tracks my career and where to start. Many question in my mind and looking for your generous advice.
these type of FORUM also provide...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 11, 2010 at 12:28 am
Viewing 15 posts - 1,876 through 1,890 (of 2,462 total)