Viewing 15 posts - 10,696 through 10,710 (of 19,560 total)
Krasavita (3/30/2011)
I ran update statment 2 hours on that table (I thought update was complited) in the query analyzer and tryed to close...
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
March 30, 2011 at 1:33 pm
Grant Fritchey (3/30/2011)
CirquedeSQLeil (3/30/2011)
using the spid of that process, use dbcc...
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
March 30, 2011 at 1:31 pm
Final signoff for application testing should be "Application Works as Coded"
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
March 30, 2011 at 12:17 pm
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
Only thing missing - Application Spec'd as Coded.
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
March 30, 2011 at 12:15 pm
Is that process that is running the same as the one we already looked into, or is a new one?
using the spid of that process, use dbcc inputbuffer to find...
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
March 30, 2011 at 12:06 pm
Grant Fritchey (3/30/2011)
Chad Crawford (3/30/2011)
Wahoo! After 4 months of wrangling, got the PASS Summit approved (and paid for) today!
congratulations.
Oh, and for those interested, I've heard through the grape...
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
March 30, 2011 at 11:58 am
Chad Crawford (3/30/2011)
Wahoo! After 4 months of wrangling, got the PASS Summit approved (and paid for) today!
Awesome
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
March 30, 2011 at 11:55 am
I think management of stress and the methods described in this editorial can be applied to more than just the computer field. A little stress is good. Too...
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
March 30, 2011 at 11:33 am
sing4you (3/30/2011)
Ray K (3/30/2011)
Daniel Bowlin (3/30/2011)
SunMoon
constellation
Pisces
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
March 30, 2011 at 10:52 am
Brandie Tarvin (3/30/2011)
Well, gosh darned it! Apparently I missed my "Hall of Fame" to "Carpal Tunnel" moment.I got promoted! @=) (Ow! My poor SQL wrists!)
Congrats and onward to 1 orange...
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
March 30, 2011 at 10:45 am
Thanks for the question.
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
March 30, 2011 at 10:03 am
Nice question - 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
March 29, 2011 at 11:47 pm
Excedrin PM
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
March 29, 2011 at 4:48 pm
Using Lutz's query, I would probably through an order by c.name,t.name in there. You might also want to include the datatype and size as well..
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
March 29, 2011 at 4:08 pm
steven.hulse (3/29/2011)
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
March 29, 2011 at 4:04 pm
Viewing 15 posts - 10,696 through 10,710 (of 19,560 total)