Viewing 15 posts - 14,926 through 14,940 (of 19,560 total)
Are you simply referring to the IO performance related to constant log growth or the log file filling up?
If you switch to full recovery, you must enable transaction log backups...
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
April 13, 2010 at 5:30 pm
Hey Steve, I just saw a post from SiteOwners and see that they have 10,000+ pts. We don't see them in the points shakedown. Why is 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
April 13, 2010 at 5:23 pm
I use RSS for the blogs that I try to follow but not any of the forums. I rely on emails and then flip through the forums periodically.
I will...
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
April 13, 2010 at 5:20 pm
Now that you know which report it is, I would check the SQL in the report and optimize the TSQL as well as tables and indexes for the report.
One possible...
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
April 13, 2010 at 5:08 pm
Thanks for updating us on the situation.
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
April 13, 2010 at 5:01 pm
Dave Heiler (4/13/2010)
Thank you for the scripts. This gave me the exact information I needed.
You're welcome.
I have updated that last script again. I posted information about it 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
April 13, 2010 at 4:53 pm
Is there anybody else at the playground now that I can come out to play?
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
April 13, 2010 at 4:42 pm
PaulB-TheOneAndOnly (4/13/2010)
In the Oracle world a explicit cursor is a cursor you define in the "declare" section - this is pl/sql...
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
April 13, 2010 at 2:51 pm
Suresh Kumar-284278 (4/13/2010)
It was one of the questions I got when I got assessment call in my company (our company does assessment for employees every year).
One more...
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
April 13, 2010 at 2:45 pm
Trey Staker (4/13/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
April 13, 2010 at 1:10 pm
jcrawf02 (4/13/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
April 13, 2010 at 12:55 pm
Grant Fritchey (4/13/2010)
RBarryYoung (4/13/2010)
Grant Fritchey (4/13/2010)
Roy Ernest (4/13/2010)
Where is Gail? I havent seen her... Anyone has any news?
She's doing fine. We've exchanged email a bit. She's busy working on her...
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
April 13, 2010 at 10:19 am
Thanks for the article.
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
April 13, 2010 at 10:16 am
What it sounds like is either you were in an Oracle interview or somebody was trying to trip you up. Ref cursors are Oracle.
As for the implicit and explicit,...
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
April 13, 2010 at 10:14 am
healthcare
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
April 13, 2010 at 9:52 am
Viewing 15 posts - 14,926 through 14,940 (of 19,560 total)