Viewing 15 posts - 17,686 through 17,700 (of 19,560 total)
Ray K (2/1/2010)
http://www.sqlservercentral.com/Forums/Topic854826-23-1.aspx#bm857301Have you folks seen the latest response to this?!?
I resisted the urge to reply. If you can't say anything nice . . .
hmmmph
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 1, 2010 at 11:23 am
Alvin Ramard (2/1/2010)
Alvin Ramard (2/1/2010)
GilaMonster (2/1/2010)
Alvin Ramard (2/1/2010)
... this month? I hope not. It's only the 1st!!! 😀I think we'll all assume you meant January.
It's february...
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 1, 2010 at 11:19 am
Alvin Ramard (2/1/2010)
GilaMonster (2/1/2010)
Alvin Ramard (2/1/2010)
... this month? I hope not. It's only the 1st!!! 😀I think we'll all assume you meant January.
It's february already? Oh.
Fixed.
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
February 1, 2010 at 11:13 am
Do you have your initial insert script 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
February 1, 2010 at 10:55 am
Thanks. I, too, learned something new today.
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 1, 2010 at 10:43 am
pain
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 1, 2010 at 10:25 am
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 31, 2010 at 9:31 pm
This is where contracts come into play. You bird-dog the contractor and get them to document everything. In the meantime you are learning what they are doing.
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 31, 2010 at 9:30 pm
I would consider losing the subqueries in favor of an alternative method. The alternative method would depend on the performance gain from testing a few different methods.
Please provide the...
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 31, 2010 at 6:27 pm
I too would recommend the 64 bit upgrade. IN addition, I recommend moving the additional applications off the server onto a dedicated application server. You are likely running...
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 31, 2010 at 6:24 pm
I think it is an intriguing idea. I was just speaking with some EMC people about this sort of thing. In benchmarking their SSD / Flash drives they...
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 31, 2010 at 6:16 pm
That would also be a good cause.
Thanks for posting back.
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 31, 2010 at 12:05 pm
Mani-584606 (1/31/2010)
thanks Jefferey,Here I considered the page_count>1000. Is that right criteria to consider for finding Index fragmentation that are only having page count>1000?
thanks again
1000 pages is a common recommendation. ...
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 31, 2010 at 12:04 pm
meatballs
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 31, 2010 at 11:09 am
vstitte (1/31/2010)
In SMSS when you...
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 31, 2010 at 11:08 am
Viewing 15 posts - 17,686 through 17,700 (of 19,560 total)