Viewing 15 posts - 11,281 through 11,295 (of 19,560 total)
A subset of that data or all of that data?
If you are moving all of it, have you considered a Select * into tablename
or maybe rename the old table?
How about...
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
December 27, 2010 at 10:13 am
Total guess on this question. The question asks for opinions and the answer is an opinion. Based on that, I see more than one possible answer.
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
December 27, 2010 at 10:10 am
Will you be moving all data from the source table?
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
December 27, 2010 at 9:59 am
Fajita
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
December 27, 2010 at 9:57 am
You should know the limits of your knowledge
I think that is a great place to start. Knowing what you don't know and being copacetic with calling somebody who may...
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
December 24, 2010 at 4:24 pm
If the advice is really bad, and I know the person - I will first try to contact them personally.
Other times, I will ask the opinion of other people who...
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
December 24, 2010 at 4:19 pm
I agree with the others. Knowing structure and queries in use for this will go miles in helping to resolve 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
December 24, 2010 at 4:11 pm
I think I would prefer to do the insert first and then delete from the source table.
Is the target table empty?
800 fields? Is this a warehouse table?
Have you considered...
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
December 24, 2010 at 9:25 am
Happy Holidays to all!!
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
December 24, 2010 at 9:21 am
Thanks for the article. This resource could prove useful.
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
December 24, 2010 at 9:20 am
Happy Holidays all.
I need one of those SSC Hawaiian shirts Steve.
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
December 24, 2010 at 9:11 am
RBarryYoung (12/23/2010)
CirquedeSQLeil (12/23/2010)
RBarryYoung (12/22/2010)
CirquedeSQLeil (12/22/2010)
WOTD - SpoonSPOooooon!!!
:w00t:
Welcome back Barry - you were missed
Not the first time, that's why I keep moving!
Did I get you that time? 😀
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
December 23, 2010 at 8:35 pm
Roy Ernest (12/23/2010)
Happy Holidays to everyone....!!! I wont log on to SSC or anything. So, Have fun everyone... See you all after Christmas.
Same to you - for whenever you log...
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
December 23, 2010 at 8:22 pm
K - thanks for the response. I think you a rebuild of that index will make a substantial improvement.
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
December 23, 2010 at 10:56 am
Stefan Krzywicki (12/23/2010)
CirquedeSQLeil (12/23/2010)
Stefan Krzywicki (12/23/2010)
CirquedeSQLeil (12/23/2010)
Anybody else read the article from today?Do you mean the Queries for SSC Community Participation article?
Yes
Yes, I read it. Interesting, but I wonder what...
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
December 23, 2010 at 10:54 am
Viewing 15 posts - 11,281 through 11,295 (of 19,560 total)