Viewing 15 posts - 17,956 through 17,970 (of 19,560 total)
Alvin Ramard (1/22/2010)
CirquedeSQLeil (1/22/2010)
Kit G (1/22/2010)
P Jones (1/22/2010)
Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do...
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 22, 2010 at 8:03 am
Kit G (1/22/2010)
Quis custodiet ipsos custodes?(Who watches the watchers?)
Illuminati
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 22, 2010 at 7:55 am
Nice list - 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 22, 2010 at 7:53 am
Kit G (1/22/2010)
P Jones (1/22/2010)
Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do anything...
Bet that's...
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 22, 2010 at 7:51 am
In addition to query tuning, and Index maintenance - I suggest proper indexing.
Another expensive option is to replace your disks with solid state disks or flash drives - very 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
January 22, 2010 at 7:49 am
Jeff Moden (1/21/2010)
What? No pork chops? :hehe:
What was microsoft thinking on this one?:-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 22, 2010 at 7:40 am
Lynn Pettis (1/22/2010)
CirquedeSQLeil (1/21/2010)
It was cheaper back when I was interested in attending there.There is a cheaper alternative currently for MIT - tell her to do the Open CourseWare program
Can't...
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 22, 2010 at 7:38 am
I would go so far as to increase the tlog backup interval to every 5 minutes during index rebuilds / reorgs
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 21, 2010 at 11:16 pm
praetorians
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 21, 2010 at 11:11 pm
Keep in mind that you will have to query while the tempdb is growing.
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 21, 2010 at 10:55 pm
It was cheaper back when I was interested in attending there.
There is a cheaper alternative currently for MIT - tell her to do the Open CourseWare program
http://ocw.mit.edu/OcwWeb/web/home/home/index.htm
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 21, 2010 at 10:46 pm
Jeff Moden (1/20/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
January 21, 2010 at 10:26 pm
Community college and clep your way through most of the credits - could get a lot of degree for that:-D
MIT - you might get a few semesters.
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 21, 2010 at 10:13 pm
Thanks for the question. It was a pleasure to answer it.
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 21, 2010 at 10:10 pm
Jeff Moden (1/21/2010)
Very cool code and a great link, Jason. Thanks!
Thanks for the compliment and you're welcome.
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 21, 2010 at 10:06 pm
Viewing 15 posts - 17,956 through 17,970 (of 19,560 total)