August 17, 2011 at 8:59 pm
Some people need to get a clue.
Anybody want to chime in on this cheater?
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
August 18, 2011 at 12:01 am
SQLRNNR (8/17/2011)
Jim Murphy (8/16/2011)
Also, one of my larger DBA clients is doing a massive conversion from a dreaded SQL7 install (325GB DB) to a totally new vendor app, SQL2008, all new Crystal Reports, etc. A 2 year effort and the conversion finally began late in July. Wall-To-Wall meetings and activities to ensure everything is converted successfully. Man, what a huge amount of time this is. It'll be great to kick SQL7 to the curb after all these years though. Buh-bye!
That sounds like a lot of fun. I have done plenty of 2000 to 2008 upgrades. Even did 7 to 2005 and a 6.5 to 2000 back in the day.
Cases like this, I think it would make sense to get the DBs to at least 2000 compat and then go from there.
Ya, that's what we did. Got it to 2000, then up from there. Large effort to extract out the old legacy data from the old vendor db, massage it and cram it into the new version of their ODS system. Plus, keep the old system online while they 'phase' out 1/7th of the database each week. Complicated. It was originally going to be a clean cut-over while shutting down the business for 1.5 weeks. Then, in the last 3 months, they decided to keep both systems online and do 1/7th partials each week running both as production. Oh, and begin importing the new data from the new system (incrementals) each night too.
And the new ODS system only has PK's defined. No indexes since it was dev and we'd tune it with some testing 'later' - oop! Now it's production partially and will be fully production next week. Way too many queries to tune before hundreds of users cry, so we are dividing the load (I've got a staff of 4 plus me and a few 1099 contractors), plus the company's DBA dept. as well). Oh, and with a clean cut over, we'd reuse the same hardware. Oh wait, now they both need to be production (for the past 5 weeks). Where's the other server? They didn't think they needed it. After I educated them as such, there was no reaction time and no one wants to invest in temporary infrustructure. Now there is a scramble to get small amounts of hardware to scale up the existing box. Upgraded SAN with another 3TB of space, fighting with SAN folks to ensure they use RAID 10 and not 5 like they want (because they acquired an odd number of drives and want to use them all). FedEx'd over some RAM - QUICK. Surprise. Need to reboot to mount the new HBA. uh. When? System is wall-to-wall production. And on and on and on..... <drifting into the sunset>.
So what do I do at the end of this? Decide to fly to Dallas for the end of this week to help out a new <large> health care company as a brand new client. Staff is doing a great job in my absence. I'm writing this from a hotel with wifi as slow as Gail's entire country's pipe. What is it again? .25Mb down and up? Ya, that's what I'm getting.
Anyway, if I wrote an article about it, it'd be a book and about 0 people would be interested in reading it. Approximately.
I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the board of sqlposse.com, planning #sqlsat97 on Oct 1st, leading a new user group meeting time...... Drowning.... <gurgle>
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
August 18, 2011 at 5:21 am
Jim Murphy (8/18/2011)
I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the board of sqlposse.com, planning #sqlsat97 on Oct 1st, leading a new user group meeting time...... Drowning.... <gurgle>
You made my morning with this. I've been expecting things to simmer down for a few months now. I think I need to change my expectations! At least the busy is the good kind of busy!
-Ki
August 18, 2011 at 5:41 am
Jim Murphy (8/18/2011)
I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the board of sqlposse.com, planning #sqlsat97 on Oct 1st, leading a new user group meeting time...... Drowning.... <gurgle>
One pre-con presentation, one spotlight (needs to just be extended), one book to tech-edit, 2 articles to write, maybe a lightning talk to plan and a thesis to write.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2011 at 5:46 am
GilaMonster (8/18/2011)
Jim Murphy (8/18/2011)
I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the board of sqlposse.com, planning #sqlsat97 on Oct 1st, leading a new user group meeting time...... Drowning.... <gurgle>One pre-con presentation, one spotlight (needs to just be extended), one book to tech-edit, 2 articles to write, maybe a lightning talk to plan and a thesis to write.
One precon presentation, one spotlight (polish, just polish), two other presentations, 1/6 through one book, 3 chapters to do in a 2nd, complete rewrite of 3rd, maybe a lightning talk and doggone it, I need to write a few blog posts. Been letting that slide.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 18, 2011 at 5:56 am
Grant Fritchey (8/18/2011)
GilaMonster (8/18/2011)
Jim Murphy (8/18/2011)
I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the board of sqlposse.com, planning #sqlsat97 on Oct 1st, leading a new user group meeting time...... Drowning.... <gurgle>One pre-con presentation, one spotlight (needs to just be extended), one book to tech-edit, 2 articles to write, maybe a lightning talk to plan and a thesis to write.
One precon presentation, one spotlight (polish, just polish), two other presentations, 1/6 through one book, 3 chapters to do in a 2nd, complete rewrite of 3rd, maybe a lightning talk and doggone it, I need to write a few blog posts. Been letting that slide.
One precon to attend on Monday, one precon to attend on Tuesday, 3 days con .... to be expected oct 10-14 :w00t::w00t::w00t:
T-52
The rest I'm trying to not get to worried about 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 18, 2011 at 6:16 am
GilaMonster (8/18/2011)
Jim Murphy (8/18/2011)
I expect things to simmer down more in a few more weeks. I think I bit off a little too much. .... sitting on the board of sqlposse.com, planning #sqlsat97 on Oct 1st, leading a new user group meeting time...... Drowning.... <gurgle>One pre-con presentation, one spotlight (needs to just be extended), one book to tech-edit, 2 articles to write, maybe a lightning talk to plan and a thesis to write.
HA! Right. I sympathize with Grant about (maybe) not wanting to add a lightning talk. I'd still go see it though!
Well, just finished 6h of being totally unproductive (sleeping). Back to work!
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
August 18, 2011 at 6:20 am
ALZDBA (8/18/2011)
One precon to attend on Monday, one precon to attend on Tuesday, 3 days con .... to be expected oct 10-14 :w00t::w00t::w00t:
Hahahaha. Great chuckle. Thanks.
Say, I know which precon you'll be in on Monday - the best one ever! Which one will you be in on Tue? The largest of them all from a dude who fixes stuff. Is he active?
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
August 18, 2011 at 7:57 am
Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal with PASS, but we'll likely sell tickets and have fun.
Look for some details soon.
August 18, 2011 at 8:12 am
Steve Jones - SSC Editor (8/18/2011)
Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal with PASS, but we'll likely sell tickets and have fun.Look for some details soon.
Yay!!!!!!!!!
Wouldn't be PASS without a SSC party.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 18, 2011 at 8:27 am
Steve Jones - SSC Editor (8/18/2011)
Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal with PASS, but we'll likely sell tickets and have fun.Look for some details soon.
Count me in... I will be there. 🙂
-Roy
August 18, 2011 at 8:32 am
Steve Jones - SSC Editor (8/18/2011)
Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal with PASS, but we'll likely sell tickets and have fun.Look for some details soon.
Deal !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 18, 2011 at 8:37 am
Jim Murphy (8/18/2011)
ALZDBA (8/18/2011)
One precon to attend on Monday, one precon to attend on Tuesday, 3 days con .... to be expected oct 10-14 :w00t::w00t::w00t:Hahahaha. Great chuckle. Thanks.
Say, I know which precon you'll be in on Monday - the best one ever! Which one will you be in on Tue? The largest of them all from a dude who fixes stuff. Is he active?
I think I'll spend Monday somewhere way in the back, sitting quiet in a corner, keeping my head down :hehe: ..... Hell No. I wouldn't want to miss all the fun with the subject and I'll try to be gentle with the tutors. :hehe:
Tuesday I'll be in the powershell class ( euhm object , since a class is an object 😉 ).
I've played a bit with powershell, but there is way more to explore ... to get to a comfortable level.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 18, 2011 at 9:17 am
Steve Jones - SSC Editor (8/18/2011)
Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal with PASS, but we'll likely sell tickets and have fun.Look for some details soon.
Woohoo
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
August 18, 2011 at 9:20 am
Steve, you'll like this one: http://www.sqlservercentral.com/Forums/Topic1161841-391-1.aspx
We just answered a MySQL question, because the forums for that product were too hostile and unhelpful. Good PR for this site!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 15 posts - 29,101 through 29,115 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply