Viewing 15 posts - 7,291 through 7,305 (of 19,560 total)
Change them from print statements to insert statements. You apparently have the prints built into the logic, so replace appropriately with insert statements. Create an runlog table to...
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
January 5, 2012 at 7:29 am
Gut said one way, but never tried it the way the third option said. Went with gut and got it right.
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
January 5, 2012 at 7:26 am
Good solid recommendations Steve. Thanks.
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
January 4, 2012 at 4:35 pm
Have you considered writing those messages to a table and then bringing that information into the package if necessary at a later point?
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
January 4, 2012 at 4:32 pm
Can a subscriber have a subscription to one of those two and not subscribe to enews?
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
January 4, 2012 at 4:21 pm
The reports are xml files. They are typically read using the web service in SSRS. Another method is to add a configuration for ReportViewer. But in all...
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
January 4, 2012 at 3:58 pm
Are you looking for a consultant to train 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
January 4, 2012 at 3:43 pm
Koen Verbeeck (1/4/2012)
SQLRNNR (1/4/2012)
GilaMonster (1/4/2012)
SQLRNNR (1/4/2012)
itpcpro (1/4/2012)
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
January 4, 2012 at 3:40 pm
Koen Verbeeck (1/4/2012)
Did I miss anything...
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
January 4, 2012 at 3:35 pm
GilaMonster (1/4/2012)
SQLRNNR (1/4/2012)
GilaMonster (1/4/2012)
SQLRNNR (1/4/2012)
itpcpro (1/4/2012)
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
January 4, 2012 at 12:42 pm
itpcpro (1/4/2012)
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
January 4, 2012 at 12:41 pm
GilaMonster (1/4/2012)
SQLRNNR (1/4/2012)
itpcpro (1/4/2012)
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
January 4, 2012 at 11:54 am
L' Eomot Inversé (1/4/2012)
crookj (1/4/2012)
WOTD - buzzwordbombinate
Frag?
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
January 4, 2012 at 11:51 am
GilaMonster (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Should be easily possible. Friday 28th December 2012, 4pm PST.
We should adjust that to 4PM Hawaiian instead of Pacific:-D
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
January 4, 2012 at 9:41 am
itpcpro (1/4/2012)
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
January 4, 2012 at 8:30 am
Viewing 15 posts - 7,291 through 7,305 (of 19,560 total)