Viewing 15 posts - 13,981 through 13,995 (of 19,560 total)
Are you getting an error message of any sort?
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 17, 2010 at 3:42 pm
WayneS (5/17/2010)
The Dixie Flatline (5/17/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 17, 2010 at 2:40 pm
FWIW, the Blog article by Brent is a really good read!
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 17, 2010 at 2:33 pm
I wouldn't toss the Clustered Indexes. If anything you may want to recreate the PKs as Clustered.
Speculation - The PK was created without a clustered index and then later...
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 17, 2010 at 12:44 pm
Jeff Moden (5/17/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 17, 2010 at 12:40 pm
Thanks for sharing.
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 17, 2010 at 11:42 am
Jeff Moden (5/12/2010)
BTW... I've submitted two abstracts as a possible speaker for the 2010 summit and I'm working on a third.
I may have to make my way into one of...
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 17, 2010 at 11:35 am
There are a couple more take-aways from the conference that I like.
1) You have the opportunity to learn from peers and not just the presenters. The classes have...
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 17, 2010 at 11:35 am
Nice list Steve. I think those are some good options to change, remove, or improve.
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 17, 2010 at 11:28 am
I am not particularly fond of encrypting stored procedures. One particular reason why is that it only obscures what is being done until you have to unencrypt it.
One example...
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 17, 2010 at 11:24 am
Boston
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 17, 2010 at 10:07 am
Kona
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 17, 2010 at 9:57 am
Steve Jones - Editor (5/17/2010)
Thanks, been trying to get those down. After editing 5 articles last week that can't figure out how...
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 17, 2010 at 9:55 am
crookj (5/17/2010)
Back-Pain.(Alot of digging this weekend for all the new buhes and plants my wife purchased. Ouch!)
Joe
From the purchases or the digging?
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 17, 2010 at 8:27 am
Hossam AlFraih (5/15/2010)
Hi,One more thing to add here is; running the SQL Server Profiler from another machine (not the server itself) will help in minimizing the performance impact.
Good luck! 😉
Be...
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 15, 2010 at 8:55 am
Viewing 15 posts - 13,981 through 13,995 (of 19,560 total)