April 16, 2010 at 3:22 pm
Lynn Pettis (4/16/2010)
Jeff Moden (4/16/2010)
dma-669038 (4/16/2010)
Or perhaps better put would be - where do you find data to work on?? The majority problems i have enjoyed solving and learnt best are those that are created on environmetns with significant data complexity (and huge messy queries that someone wrote!!). How do you get that at home?That's part of the "secret" to becoming a Jedi Knight... you have to build your own Light Saber. 😉 Being able to quickly build large quantities of your own test data is one of those skills that is essential to becoming a Jedi in T-SQL.
I usually test on a million rows (sometimes more). Building a million row table of things to test on isn't much more difficult than building a Tally table. If you take a look back at several of my (and some of the Jedi's on this forum) posts, I'm sure you'll find my "standard" million row test table generator code.
Why don't I post it here? Heh... because participation is also essential. 🙂 Wax on... wax off.
Aren't you mixing movie metaphors here??
It's all martial arts so it's ok.;-)
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 16, 2010 at 3:28 pm
Jack Corbett (4/16/2010)
Grant Fritchey (4/16/2010)
dma-669038 (4/16/2010)
Grant Fritchey (4/16/2010)
dma-669038 (4/16/2010)
Learning how everything is supposed to work as opposed to all the ways you can screw it up will teach you many ways to screw it up. Then, it's just experience and reading and work to identify the common bad practices that you might be able to replicate.Great one, thank you. The NYC SQL Saturday sounds like fun, although the thought of finding a place to stay in the city even for a weekend is hard 🙂 Grant, would you be at Indy Techfest in May?
No, I'm not one of these travelling consultant guys. I tend to stay close to home. Although I did Connections in Vegas last year and I'm going down to NYC for this SQL Saturday, so I'm starting to move around a bit.
Still waiting to see you in Orlando. I'll be in touch as we are planning our next SQLSaturday now. Early October is a nice time to be here.
I'd love to. I really like travelling. If I could do it and do presentations... I'd be in heaven. All I can say is, we'll see.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 16, 2010 at 6:09 pm
Jack Corbett (4/16/2010)
I'll be in touch as we are planning our next SQLSaturday now. Early October is a nice time to be here.
Hey Jack, how about keeping me in the loop on this too. My mother-in-law is in Tampa; this would make a nice trip for me and my wife (the only hard part would be getting up early enough on a Sat to be in Orlando @ 7:30...)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 16, 2010 at 7:14 pm
WayneS (4/16/2010)
Jack Corbett (4/16/2010)
I'll be in touch as we are planning our next SQLSaturday now. Early October is a nice time to be here.Hey Jack, how about keeping me in the loop on this too. My mother-in-law is in Tampa; this would make a nice trip for me and my wife (the only hard part would be getting up early enough on a Sat to be in Orlando @ 7:30...)
Not to be a pain, but follow my blog and if you are on Twitter, my twitter account. It looks like we are shooting for October 9th, possibly September 18th. Andy Warren is in charge of location and that will drive the date a bit. We are usually mid to late October, but want to move it up to get some separation from the Summit. With Andy being on the PASS board and myself planning on going to the Summit it gets a bit hectic if we have it later in October.
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
April 16, 2010 at 11:48 pm
Jack Corbett (4/16/2010)
WayneS (4/16/2010)
Jack Corbett (4/16/2010)
I'll be in touch as we are planning our next SQLSaturday now. Early October is a nice time to be here.Hey Jack, how about keeping me in the loop on this too. My mother-in-law is in Tampa; this would make a nice trip for me and my wife (the only hard part would be getting up early enough on a Sat to be in Orlando @ 7:30...)
Not to be a pain, but follow my blog and if you are on Twitter, my twitter account. It looks like we are shooting for October 9th, possibly September 18th. Andy Warren is in charge of location and that will drive the date a bit. We are usually mid to late October, but want to move it up to get some separation from the Summit. With Andy being on the PASS board and myself planning on going to the Summit it gets a bit hectic if we have it later in October.
What, you don't want to pack up from SQL Saturday and then jump the plane for Seattle?
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 17, 2010 at 6:04 am
Grant Fritchey (4/14/2010)
Personally, I'm trying very hard to not be one of those people. I've got twenty+ years in IT and I hope that they are 20 distinct years as opposed to one year repeated 20 times.
I've been in IT over 40 years, and I still learn new things all the time. I'd probably go mad with boredom if I didn't.
But I still use things that I learnt more than 40 years ago, some of which date from more than a decade before I encountered them, so I don't deprecate older knowledge.
Sometimes I think though that our field is too much into following fashion and throwing away the big lessons, perhaps because even people who do continue to learn become overspecialised and don't notice the lessons learnt in other parts of the field. The "Intro to Entity Framework with SQL Server" article that was featured in the newletter along with the continued education editorial) and its companion article "How to Use SQL Server DML Stored Procedures with the Entity Framework" seem to me to illustrate that very clearly.
Tom
April 17, 2010 at 4:31 pm
Speaking of PASS, Grant... any idea when they're going to start a "Call for Speakers"?
--Jeff Moden
April 17, 2010 at 4:36 pm
Lynn Pettis (4/16/2010)
Jeff Moden (4/16/2010)
dma-669038 (4/16/2010)
Or perhaps better put would be - where do you find data to work on?? The majority problems i have enjoyed solving and learnt best are those that are created on environmetns with significant data complexity (and huge messy queries that someone wrote!!). How do you get that at home?That's part of the "secret" to becoming a Jedi Knight... you have to build your own Light Saber. 😉 Being able to quickly build large quantities of your own test data is one of those skills that is essential to becoming a Jedi in T-SQL.
I usually test on a million rows (sometimes more). Building a million row table of things to test on isn't much more difficult than building a Tally table. If you take a look back at several of my (and some of the Jedi's on this forum) posts, I'm sure you'll find my "standard" million row test table generator code.
Why don't I post it here? Heh... because participation is also essential. 🙂 Wax on... wax off.
Aren't you mixing movie metaphors here??
I was going to throw in the thing about carrying a hot Hibachi with your bare forearms while resisting the aroma of perfectly done pork chops but thought it might be a little over the top. 😛
--Jeff Moden
April 17, 2010 at 5:36 pm
Grant Fritchey (4/16/2010)
Jack Corbett (4/16/2010)
WayneS (4/16/2010)
Jack Corbett (4/16/2010)
I'll be in touch as we are planning our next SQLSaturday now. Early October is a nice time to be here.Hey Jack, how about keeping me in the loop on this too. My mother-in-law is in Tampa; this would make a nice trip for me and my wife (the only hard part would be getting up early enough on a Sat to be in Orlando @ 7:30...)
Not to be a pain, but follow my blog and if you are on Twitter, my twitter account. It looks like we are shooting for October 9th, possibly September 18th. Andy Warren is in charge of location and that will drive the date a bit. We are usually mid to late October, but want to move it up to get some separation from the Summit. With Andy being on the PASS board and myself planning on going to the Summit it gets a bit hectic if we have it later in October.
What, you don't want to pack up from SQL Saturday and then jump the plane for Seattle?
I'd do it, but my wife certainly wouldn't like it. If I was just attending SQLSaturday I could do it no problem, but as an event organizer the week before is lost to my family and then a week at PASS would be tough. I'd definitely have to take a vacation afterwards to spend time with the family.
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
April 17, 2010 at 5:38 pm
Jeff Moden (4/17/2010)
Speaking of PASS, Grant... any idea when they're going to start a "Call for Speakers"?
Should be very soon. There are some changes being made to the submission process & web site that pushed it back later than usual.
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
April 17, 2010 at 8:11 pm
Jeff Moden (4/17/2010)
Speaking of PASS, Grant... any idea when they're going to start a "Call for Speakers"?
My understanding is it was supposed to be in April. Last year I got an invite to do a Spotlight the week before the open call. I haven't received an invite for a spotlight this year, but since I didn't get invited to the 24 hours of PASS I'm assuming I'm not on the short list.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 11 posts - 46 through 55 (of 55 total)
You must be logged in to reply to this topic. Login to reply