Viewing 15 posts - 19,321 through 19,335 (of 19,560 total)
To second the advice given:
Reattach the database first and then add the logins. I have encountered less problems that way.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 13, 2009 at 11:33 am
Do you know the size estimate of the data that you are trying to move from Oracle into SQL2K?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 13, 2009 at 11:30 am
GabyYYZ (10/13/2009)
Apparently, Microsoft is releasing it's biggest set of patches in one day today, and among those is a SQL patch. I can't seem to find details on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 13, 2009 at 11:23 am
Here is a sort of starter script to show a little bit of the interaction. This will give a quick overview of some of the properties of your jobs....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2009 at 12:11 pm
One more thing to try is to check your ansi_warnings setting.
Try
set ansi_warnings on
execute your proc
If you get an error, then reverse the setting. And then add set ansi_warnings off...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2009 at 10:11 am
Will you also script the job and show us that?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 18, 2009 at 9:59 am
what have you done to troubleshoot?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 4:58 pm
Do you get an actual error message if you click the shortcut?
Looks like somebody uninstalled the management tools from the pic you sent - best guess.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 4:38 pm
ifila (9/17/2009)
Is this something worth changing to improve...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 4:34 pm
BTW, thanks for being helpful to us. You providing the table and index information really helps make this process go a lot smoother.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 3:00 pm
drodriguez-762178 (9/17/2009)
OK, I think I got it. There reason for the fragmentation is because there is now primary key.
No. The reason for fragmentation is due to the lack of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 2:58 pm
edvaldocastro (9/17/2009)
CirquedeSQLeil (9/17/2009)
Also, are there any other inserts happening inside this proc?
Lastly, inside the sql agent job, what is the command...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 1:47 pm
To help the situation, you should consider a clustered index for the table. To defrag the other indexes, you will need a clustered index. The clustered index can...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 1:27 pm
lmu92 (9/17/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 11:53 am
drodriguez-762178 (9/17/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 11:39 am
Viewing 15 posts - 19,321 through 19,335 (of 19,560 total)