Viewing 15 posts - 18,886 through 18,900 (of 19,560 total)
Do you see commonality between the ones that were successful versus those that were not successfully transferred via your script?
Also, have you checked your script to see that the 71...
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
December 7, 2009 at 12:28 pm
sureshdeenu (12/7/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
December 7, 2009 at 12:17 pm
Please post the view, sample data, and table structures. This will help in coming up with a legitimate answer.
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
December 7, 2009 at 12:08 pm
You may be asked any question that is in line with SOX compliance. You have made the security changes based on SOX guidelines, you can bet you will be...
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
December 7, 2009 at 12:02 pm
Once you layout the code in a readable format, I think the error and resolution will become obvious to you.
As Gus said, you are missing some spaces. Remember 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
December 7, 2009 at 11:45 am
Grant Fritchey (12/7/2009)
Number 6 (12/7/2009)
At least he put it in the Hardware section of the Forums....They're talking about fixing mice, what are you doing here Alvin? Run! Run!
ROFLOL
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
December 7, 2009 at 11:42 am
jason.stephens (12/7/2009)
GilaMonster (12/7/2009)
jason.stephens (12/7/2009)
I couldn't find any specific documentation published by microsoft on a good cut-off.
A rough rule-of-thumb, given by a former program manager of the storage engine is around...
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
December 7, 2009 at 11:41 am
The user would need to exist in a place where both nodes could reach it. In a cluster, you would be better served to add a Domain User. ...
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
December 7, 2009 at 11:33 am
Many jobs or just a Single job?
Side by Side upgrade to SQL 2005?
One option could be Redgate Data Compare - and compare the MSDB database (sysjobs,sysjobschedules, sysjobsteps, sysjobservers, sysjobhistory).
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
December 7, 2009 at 11:28 am
Too bad it is gone now - probably U2 drivers. Tried to respond to it - but I think Steve got to it.
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
December 7, 2009 at 11:25 am
Antiquated
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
December 7, 2009 at 11:22 am
Please post your attempts. If you post what you have tried, we can better help you. Along with queries, it will be helpful to post table structures. ...
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
December 7, 2009 at 10:29 am
Something that would be helpful in answering this would be to know page counts for your tables. It would also be helpful to see what kinds of indexes you...
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
December 7, 2009 at 10:20 am
GSquared (12/7/2009)
The reason I use cursors for this kind of thing, instead of "quirky update" string building, is that I can wrap each command in error handling much more easily.
This...
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
December 7, 2009 at 10:05 am
rambilla4 (12/7/2009)
There is an integral piece of information. Knowing that the server is clustered is essential information for the answer.
Using net stop net start for the services will cause...
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
December 7, 2009 at 10:01 am
Viewing 15 posts - 18,886 through 18,900 (of 19,560 total)