Viewing 15 posts - 12,676 through 12,690 (of 19,560 total)
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
August 31, 2010 at 8:24 pm
Excellent question and excellent explanation.
Thanks Hugo
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
August 31, 2010 at 7:27 pm
Alvin Ramard (8/31/2010)
CirquedeSQLeil (8/31/2010)
how about a countdown for 18000 now?24 more :hehe:
Ok, time to turn off the email notifications.
LOL
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
August 31, 2010 at 7:25 pm
how about a countdown for 18000 now?
24 more :hehe:
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
August 31, 2010 at 7:07 pm
Here Here - echo that sentiment 😀
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
August 31, 2010 at 6:53 pm
There are also a couple more options.
there is a script called sp_whoisactive by Adam machanic here
I also wrote an article with a script that may be of use here[/url]
I also...
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
August 31, 2010 at 6:35 pm
WayneS (8/31/2010)
CirquedeSQLeil (8/31/2010)
Any chance this thread will breach 20,000 posts by the second anniversary?
Just a wee bit over 2000 to go to get it by 11/18 - 2.5 months is...
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
August 31, 2010 at 5:44 pm
Uncle Moki (8/31/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
August 31, 2010 at 4:16 pm
I agree with Wayne. i believe the issue resides in the CTE.
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
August 31, 2010 at 4:09 pm
Alvin Ramard (8/31/2010)
Michael Earl-395764 (11/18/2008)
Is it me, or are the posted questions getting worse these days?
I don't know if they're getting worse, but they're not getting much better.
Yes, 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
August 31, 2010 at 4:05 pm
I think the skillset will vary greatly depending on employer. Some employers want a DBA who is an architect and a developer and others want a DBA just 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
August 31, 2010 at 3:54 pm
Lunch-time
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
August 31, 2010 at 3:07 pm
Chris Morris-439714 (8/31/2010)
Magic 🙂
Selena Gomez?
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
August 31, 2010 at 10:28 am
homebrew01 (8/31/2010)
CirquedeSQLeil (8/31/2010)
Once you have re-grown the log - then defrag your indexes.
Does defragmenting indexes apply to shrinking log files as well as data files ?
In this case it looks...
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
August 31, 2010 at 9:01 am
Experience is a good piece of the puzzle and there are several ways to get it as you mentioned - 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
August 31, 2010 at 8:59 am
Viewing 15 posts - 12,676 through 12,690 (of 19,560 total)