Viewing 15 posts - 18,451 through 18,465 (of 19,560 total)
THANKS FOR THE QOD BitBucket
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
December 31, 2009 at 10:09 am
Try the DBCC UpdateUsage that Gail also suggested. Also, try updating stats for all tables rather than just the tables involved.
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
December 31, 2009 at 10:03 am
Nice 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
December 31, 2009 at 9:54 am
Steve Jones - Editor (12/31/2009)
CirquedeSQLeil (12/31/2009)
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
December 31, 2009 at 9:46 am
Happy New Years All (jumping on the BANDWAGON):hehe:
As for snow, we had our snowstorms over the past couple of days - nothing major, just a little slick and only about...
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
December 31, 2009 at 9:43 am
lmu92 (12/31/2009)
During weekend and Holiday there will be a three level support system:
Level 1: On Call
You have to be reachable by phone...
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
December 31, 2009 at 9:19 am
Steve Jones - Editor (12/28/2009)
you are correct. However many jobs, many IT jobs, don't specify holiday requirements. I've never had that be stated when I was hired. You're expected 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
December 31, 2009 at 9:15 am
jcrawf02 (12/31/2009)
Matt Miller (#4) (12/31/2009)[/b
I'm not sure if this qualifies as heresy or not, or if it's "just plain wrong", but Darth had a close call the other day:
My very...
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
December 31, 2009 at 9:07 am
Are we human or are we dancer?
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
December 31, 2009 at 9:04 am
Chris Quinn-821458 (12/31/2009)
Kit G (12/31/2009)
Chris Quinn-821458 (12/31/2009)
RAID Failureut oh!
Week end, month end and financial year end! 🙁
That is just wrong
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
December 31, 2009 at 9:01 am
One such script can be found at http://blog.sqlauthority.com/2006/12/01/sql-server-cursor-to-kill-all-process-in-database/
I think it would need some mods to keep it to killing only the desired SPIDS
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
December 30, 2009 at 4:25 pm
3rd party app counts number of SQL connections to a specific database and uses that count as the control for it's licensing methodology. Is that correct?
There are scripts available...
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
December 30, 2009 at 4:23 pm
Thanks for the info.
The information might be viable. And Lutz has a great point - information garnered from books and SSC is quite substantially more than a 4hr webinar....
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
December 30, 2009 at 3:57 pm
Thanks Scott.
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
December 30, 2009 at 3:30 pm
A few more things that did not happen in 2009 that were good for SSC
SSC does not blacklist posters for poorly written, unresearched, or never efforted questions to the forums....
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
December 30, 2009 at 10:54 am
Viewing 15 posts - 18,451 through 18,465 (of 19,560 total)