Viewing 15 posts - 12,166 through 12,180 (of 19,560 total)
The Dixie Flatline (9/23/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
September 23, 2010 at 7:55 am
Dave Ballantyne (9/23/2010)
GilaMonster (9/23/2010)
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Yeah, surprising that. (not)
I must add that to my optimisation advice. "Try adding this...
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
September 23, 2010 at 7:51 am
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Hmmm - haven't tried that method. I think I will on a couple of our larger...
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
September 23, 2010 at 7:50 am
GilaMonster (9/22/2010)
<several people>: Change the index thusly
OP: That won't help.
<couple people>: Did you try it?
OP: That helped 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
September 23, 2010 at 7:48 am
Obligatory daily update on 20K goal
Thread 14.42 posts/day
Gail 13.91 posts/day
For digital 20k
Thread 22.84
Gail 22.33
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
September 22, 2010 at 6:15 pm
I agree, dev server only. Dev sample databases should not be on a production box. If I find them on prod, I remove them.
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
September 22, 2010 at 5:16 pm
george sibbald (9/22/2010)
Toby Harman (9/22/2010)
I think that this revolves around the concept that His Chuckness can do anything...but can he act?
No need when you have mad skills like he...
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
September 22, 2010 at 5:07 pm
Toby Harman (9/22/2010)
I would guess that the original poster is having issues with SQL...
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
September 22, 2010 at 5:05 pm
Hmmm - I don't either. Somebody please explain¿
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
September 22, 2010 at 4:37 pm
Nice article - well written.
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
September 22, 2010 at 4:34 pm
Paul White NZ (9/22/2010)
Alvin Ramard (9/22/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
September 22, 2010 at 4:16 pm
Jack Corbett (9/22/2010)
Daniel Bowlin (9/22/2010)
CirquedeSQLeil (9/22/2010)
Daniel Bowlin (9/22/2010)
Is this some evil plan to get us to spend even more time in the forums? 😀
Yes - and it is working
It's like...
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
September 22, 2010 at 1:57 pm
GilaMonster (9/22/2010)
*mutter* blah, waffle, blah.
Long Hair white cat got your tongue?
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
September 22, 2010 at 1:47 pm
mbricker-600840 (9/22/2010)
CirquedeSQLeil (9/22/2010)
mbricker-600840 (9/22/2010)
CirquedeSQLeil (9/22/2010)
mbricker-600840 (9/22/2010)
in-freakin'-N-out burgerThere is good reason for that name
what goes IN comes right back OUT
Re-freakin-cycling
Re-freakin-gurgitating
😀
Re-freakin'-considering (my choice of dining spots)
re-freakin-hahahaha
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
September 22, 2010 at 1:39 pm
The index would need to be used from the table that is returning the data. It is also beneficial to have indexes on fks especially for the join operations.
Placing...
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
September 22, 2010 at 1:39 pm
Viewing 15 posts - 12,166 through 12,180 (of 19,560 total)