Viewing 15 posts - 12,631 through 12,645 (of 19,560 total)
One last note - the duration columns are all in minutes.
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 2, 2010 at 11:30 am
If your goal is to have a single instance - it might be advisable.
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 2, 2010 at 11:29 am
SQL Guy-482125 (9/2/2010)
There are 38 tables, they are all from same schema. I created a cursor to script insert /select against source database. Putting them in correct order would...
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 2, 2010 at 11:26 am
jcrawf02 (9/2/2010)
Tom.Thomson (9/2/2010)
Steve Jones - Editor (9/2/2010)
Noooooooo, not partial posts. There can be enough nonsense in this thread already.Surely you don't expect all the posts to be impartial?
Is this Three...
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 2, 2010 at 11:24 am
This may be of help for you:
with duration as (
Select job_id
,MinDuration = min((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31 ) / 60)
,AvgDuration = avg((run_duration/10000*3600 + (run_duration/100)%100*60 + run_duration%100 + 31...
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 2, 2010 at 11:23 am
Here are some articles with several scripts to help you with that:
http://jasonbrimhall.info/2010/02/01/key-discovery-iii/
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 2, 2010 at 10:55 am
It seems that you did not pick the database engine option during setup. Or did you install a new instance?
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 2, 2010 at 10:53 am
I agree with Michael.
Load the data in the correct order, or delete in the correct order.
Here is an alternative script to help with figuring out the order:
http://jasonbrimhall.info/2010/02/01/key-discovery-iii/
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 2, 2010 at 10:50 am
SqlServerLover (9/2/2010)
Thanks Everyone for your valuable suggestions.I appreciate your help. SQLservercentral.com and you guys rock .
You're welcome
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 2, 2010 at 10:32 am
You are welcome.
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 2, 2010 at 10:19 am
Thanks for the question.
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 2, 2010 at 10:17 am
LightVader (9/2/2010)
Derrick Smith (9/1/2010)
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 2, 2010 at 10:07 am
Brandie Tarvin (9/2/2010)
Shorttimers Disease
CHanging 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 2, 2010 at 10:05 am
Steve Jones - Editor (9/2/2010)
Jas n,Wh t bo t t s as a p r i l st?
😀
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 2, 2010 at 10:01 am
Lynn Pettis (9/2/2010)
Alvin, how about you
That was unreasonably close to a full
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 2, 2010 at 8:58 am
Viewing 15 posts - 12,631 through 12,645 (of 19,560 total)