Viewing 15 posts - 17,086 through 17,100 (of 19,560 total)
Jack Corbett (2/21/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
February 21, 2010 at 3:44 pm
Matt Miller (#4) (2/21/2010)
CirquedeSQLeil (2/21/2010)
Lynn Pettis (2/21/2010)
CirquedeSQLeil (2/21/2010)
After that - Gail, Andy, Tim, K. Brian Kelley, Steve, and Jeff are...
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
February 21, 2010 at 2:50 pm
Lynn Pettis (2/21/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
February 21, 2010 at 2:38 pm
george sibbald (2/21/2010)
did the points from timewarp get reinstated?- I lost track.
Nope.
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
February 21, 2010 at 1:38 pm
GilaMonster (2/21/2010)
Can ask someone(s) to keep an eye on the corruption forum for the week please? I'm pretty much offline for the week. Thanks
Sure, we'll watch it. We'll try...
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
February 21, 2010 at 1:19 pm
Lynn Pettis (2/21/2010)
CirquedeSQLeil (2/21/2010)
If not Barry, Lynn, or Gus, it must be Jack. 😀After that - Gail, Andy, Tim, K. Brian Kelley, Steve, and Jeff are already MVP's.
Or maybe even...
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
February 21, 2010 at 1:00 pm
nice 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
February 21, 2010 at 10:21 am
If not Barry, Lynn, or Gus, it must be Jack. 😀
After that - Gail, Andy, Tim, K. Brian Kelley, Steve, and Jeff are already MVP'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
February 21, 2010 at 10:13 am
isuckatsql (2/20/2010)
CirquedeSQLeil (2/20/2010)
isuckatsql (2/20/2010)
Defragged all drives and rebooted the server, no improvement in query performance 🙁
Was the disk defrag performed while sql server was stopped?
Second, did you try creating a...
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
February 20, 2010 at 10:05 pm
isuckatsql (2/20/2010)
Defragged all drives and rebooted the server, no improvement in query performance 🙁
Was the disk defrag performed while sql server was stopped?
Second, did you try creating a clustered index...
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
February 20, 2010 at 9:22 am
Jeffrey Williams-493691 (2/19/2010)
Thank you Jason - couldn't have said it better myself...in fact, I didn't 🙂
Thanks goes to you 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
February 19, 2010 at 7:39 pm
I think it is a good approach.
Make sure you tidy up the code a little (your drop table is attempting to drop ##DBUSER which is not the table you created).
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
February 19, 2010 at 3:05 pm
Lynn Pettis (2/19/2010)
CirquedeSQLeil (2/19/2010)
jcrawf02 (2/19/2010)
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/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
February 19, 2010 at 2:14 pm
jcrawf02 (2/19/2010)
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/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
February 19, 2010 at 2:10 pm
Grant Fritchey (2/19/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
February 19, 2010 at 1:25 pm
Viewing 15 posts - 17,086 through 17,100 (of 19,560 total)