Viewing 15 posts - 14,986 through 15,000 (of 19,560 total)
Bhuvnesh (4/10/2010)
tony.turner (4/9/2010)
On the other hand a large heap (no clustered index) would INSERT very slowly (I have come across some prize examples of same).
This is a bit...
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
April 11, 2010 at 10:53 am
xanthorrhoeaceae
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
April 11, 2010 at 10:47 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
April 11, 2010 at 10:04 am
It make sense that MS would want to push the MCM. That is a lot of revenue lost / money invested in the MCM when you look at 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
April 11, 2010 at 10:02 am
In addition to what Robert said, keep in mind that Mirroring or Clustering are really only a piece of the big picture for DR.
Others have suggested a cluster that is...
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
April 10, 2010 at 11:16 pm
Jeff Moden (4/10/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
April 10, 2010 at 11:10 pm
RBarryYoung (4/10/2010)
CirquedeSQLeil (4/10/2010)
RBarryYoung (4/10/2010)
Steve Jones - Editor (4/10/2010)
Chores.Ignored.
Good idea - but I am almost done now. You should have suggested that sooner.
Reporting. Not suggesting.
LOL
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
April 10, 2010 at 1:19 pm
RBarryYoung (4/10/2010)
Steve Jones - Editor (4/10/2010)
Chores.Ignored.
Good idea - but I am almost done now. You should have suggested that sooner.
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
April 10, 2010 at 1:11 pm
vidya_pande (4/10/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
April 10, 2010 at 1:09 pm
Steve Jones - Editor (4/10/2010)
Chores.
Bothersome
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
April 10, 2010 at 11:33 am
Cliff Jones (4/10/2010)
CirquedeSQLeil (4/9/2010)
Kiran gajendragadkar (4/9/2010)
jason .. There is no pain in your name 🙂Can you name the movie from whence the quote originates?
...one of the Batman movies. Don'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
April 10, 2010 at 10:08 am
bitbucket-25253 (4/10/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
April 10, 2010 at 10:04 am
Anybody who helps in solving there own problem should also be included. And those who take the time to give thanks for the help - they're awesome 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
April 10, 2010 at 9:59 am
Paul White NZ (4/10/2010)
RBarryYoung (4/10/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
April 10, 2010 at 9:55 am
After re-reading the OP, it seems that the best plan of attack to me would be to migrate to SQL 2008 first and then add the new indexes. In...
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
April 10, 2010 at 9:53 am
Viewing 15 posts - 14,986 through 15,000 (of 19,560 total)