Viewing 15 posts - 14,206 through 14,220 (of 19,560 total)
bcsims 90437 (5/6/2010)
El Paso? Salsa... it's almost lunchtime.
Jalapenos
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
May 6, 2010 at 12:39 pm
Amol Naik-681410 (5/6/2010)
The time to run the SP definitely is longer than it should have taken, almost double the time (~6 minutes).Thanks,
That seems proportionate to a double run (validation and...
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
May 6, 2010 at 11:55 am
I was thinking the delayvalidation flag that can be set to true. During runtime, the runtime engine validates each task as it reaches it. During runtime, the delayvalidation...
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
May 6, 2010 at 11:50 am
bcsims 90437 (5/6/2010)
CirquedeSQLeil (5/6/2010)
Lynn Pettis (5/6/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
May 6, 2010 at 11:39 am
When you are running this, are you running it as a job or directly from BIDS?
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
May 6, 2010 at 11:38 am
It looks like you can do an upgrade. You will need to perform a custom installation to do that.
http://blogs.msdn.com/sqlexpress/archive/2009/06/15/installing-sql-server-2008-guidance.aspx
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
May 6, 2010 at 11:36 am
eric_russell 13013 (5/6/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
May 6, 2010 at 11:30 am
If you are truly on sql server 2008, I recommend you look into altering the data type to varchar or nvarchar(max) instead of text. Text data type is going...
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
May 6, 2010 at 11:26 am
GilaMonster (5/6/2010)
Henrico Bekker (5/6/2010)
Next on your agenda I would say is to go for MVP status.
Um.....
MVP status is not something that you should be 'going for' as a career goal....
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
May 6, 2010 at 11:19 am
Have you considered turning off pre-validation?
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
May 6, 2010 at 11:11 am
If the DBA is in the sysadmin role, then the DBA will have access to the data. The DBA would need to not be in the sysadmin role. ...
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
May 6, 2010 at 11:10 am
How well does the SP perform outside of the package? Have you checked indexes? What does the proc look like?
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
May 6, 2010 at 11:06 am
Ninja's_RGR'us (5/6/2010)
This seems like a case of error message pointing to the wrong thing. We need the whole code and sample data to find the real problem.
I agree. ...
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
May 6, 2010 at 11:02 am
jacroberts (5/6/2010)
CirquedeSQLeil (5/6/2010)
I would have like to see a more in-depth article on the facets of the scripts. I think this would have added more value to the article.
I...
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
May 6, 2010 at 10:50 am
Lynn Pettis (5/6/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
May 6, 2010 at 10:45 am
Viewing 15 posts - 14,206 through 14,220 (of 19,560 total)