August 17, 2011 at 12:31 am
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspx
Seems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 17, 2011 at 12:34 am
Roy Ernest (8/16/2011)
Just finished an article on Change tracking. I would love to have it reviewed by some of you. Anyone would like to take a peek at it?PS : Just 99 posts to hit the big mile stone of 3000 posts. I never though I would come anywhere close to it. 🙂
If you want me to, I'll be happy to read it over.
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 17, 2011 at 12:38 am
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
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 17, 2011 at 6:29 am
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
He's always been Evil Kraig, it's just been an internal struggle. His true nature finally won out. :-P:hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
August 17, 2011 at 6:44 am
Jim Murphy (8/16/2011)
Phew. Man, life is passing me by.Just had our first Austin UG meeting at a new time yesterday. This is the city's 2nd meeting night each month to service the other half of the city (traffic is bad here). Slow startup. There were 9 there total; including me. T'was fun though. It'll take a few months for the word to get out. http://sqlwatchmen.com/blogs/jim/index.php/2011/08/user-group-meeting-location-picked/
Nothing wrong with a small group especially if it is a second location in the metro area. The key is are you reaching new people or the same people coming to a new location. We started a second group on Orlando (south side) in January and we went from 15-20 at one group to 35-40 combined. Neither group is large, but we are reaching more people now, which is the goal.
Flying to Dallas in the morning for the rest of the week to be on-site with a new client (yey). Now, if I could only get some sleep.....
As my friend K. Brian Kelley would say, "Sleep is for mortals"
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!
Always good to move forward. That's a big change though, especially since you can't do a direct 7 to 2008 upgrade. I'd be interested in hearing how you managed this conversion.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 17, 2011 at 6:45 am
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
I'm thinking right around birth ...
- 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
August 17, 2011 at 7:07 am
If anyone here thinks they're dealing with big data, go listen to this: http://dotnetrocks.com/default.aspx?showNum=664
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 17, 2011 at 8:01 am
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!
Jack Corbett (8/17/2011)
Always good to move forward. That's a big change though, especially since you can't do a direct 7 to 2008 upgrade. I'd be interested in hearing how you managed this conversion.
Jim, this upgrade might make for a good article. I know that there are still lots of SQL 7 / 2000 instances running out there.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 17, 2011 at 11:17 am
jcrawf02 (8/17/2011)
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
He's always been Evil Kraig, it's just been an internal struggle. His true nature finally won out. :-P:hehe:
Yes, my twin finally took over. Muahahahahaha!
Nah, it's kind of a gag from someone mis-spelling my name pretty obviously. I figured I'd take it and run with it. 😀 (Though I have to laugh, you did it too! :w00t: I probably should put the proper spelling into my sig.)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 17, 2011 at 11:49 am
GSquared (8/17/2011)
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
I'm thinking right around birth ...
I think around conception might be closer.
Tom
August 17, 2011 at 11:58 am
Evil Kraig F (8/17/2011)
jcrawf02 (8/17/2011)
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
He's always been Evil Kraig, it's just been an internal struggle. His true nature finally won out. :-P:hehe:
Yes, my twin finally took over. Muahahahahaha!
Nah, it's kind of a gag from someone mis-spelling my name pretty obviously. I figured I'd take it and run with it. 😀 (Though I have to laugh, you did it too! :w00t: I probably should put the proper spelling into my sig.)
At least I noticed something was twisted =-s
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 17, 2011 at 12:54 pm
GilaMonster (8/17/2011)
If anyone here thinks they're dealing with big data, go listen to this: http://dotnetrocks.com/default.aspx?showNum=664
Thanks Gail.
That is a staggering amount of data...
-Dan
August 17, 2011 at 1:31 pm
Evil Kraig F (8/17/2011)
jcrawf02 (8/17/2011)
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
He's always been Evil Kraig, it's just been an internal struggle. His true nature finally won out. :-P:hehe:
Yes, my twin finally took over. Muahahahahaha!
Nah, it's kind of a gag from someone mis-spelling my name pretty obviously. I figured I'd take it and run with it. 😀 (Though I have to laugh, you did it too! :w00t: I probably should put the proper spelling into my sig.)
Careful, that person might take credit for your personna;-)
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 17, 2011 at 1:48 pm
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.
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 17, 2011 at 3:33 pm
SQLRNNR (8/17/2011)
Evil Kraig F (8/17/2011)
jcrawf02 (8/17/2011)
ALZDBA (8/17/2011)
Evil Kraig F (8/17/2011)
Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspxSeems like a nice enough fellow, but what he's looking to do I fear is WAY over his head. I tried to get him in the right direction but I haven't used Access in an age so there's no way I'm going to be able to walk him through it.
I lost track on The Thread because of summer holidays but ...
when did Kraig become Evil Kraig ?
He's always been Evil Kraig, it's just been an internal struggle. His true nature finally won out. :-P:hehe:
Yes, my twin finally took over. Muahahahahaha!
Nah, it's kind of a gag from someone mis-spelling my name pretty obviously. I figured I'd take it and run with it. 😀 (Though I have to laugh, you did it too! :w00t: I probably should put the proper spelling into my sig.)
Careful, that person might take credit for your personna;-)
Anyone willing to take credit for me is not going to be helping themselves. 😎
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 15 posts - 29,086 through 29,100 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply