October 27, 2011 at 2:47 pm
Evil Kraig F
Awesome piece of code used, abused, re-abused, then rebuilt from the ground up with beer popsicles and dust bunnies
Now there is an idea .. have those beer popsicles and dust bunnies with you during the review.
Actually doing a peer review entails a great deal of work on the part of the person(s) doing the review. Those I have had where the reviewer(s) were not prepared where the most disappointing, for I knew I was not that brilliant and hence did not learn anything.
October 27, 2011 at 2:51 pm
Yes Jeff's articles are always interesting, even if you didn't realise there was a problem and can't find an excuse to use his solution.
Now excuse me I've just lost track of my inchworm.
October 27, 2011 at 4:02 pm
Tom Brown (10/27/2011)
Does anyone know of a code analysis tool for T-SQL?Perhaps there is something similar to ReSharper - the visual studio add-in.
Somebody did one. I can't remember who or what they called it.
I think I found it, but it isn't exactly what you are looking for. It is called SQLCop and it is a free download so you could try it out.
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
October 27, 2011 at 7:22 pm
Because a lot of Developers just want to get stuff off their plate, don't do peer reviews unless there's been some training as to what is expected in a peer review and why the reviews are necessary. I do such training in one form or another for evey company I work for. Eventually, I get it to the point where 100% of the code is peer reviewed and it's the Developers reviewing each other's code for format, function, performance, and best practices... and I usually don't have to publish standards/guidlines to get it done, either.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 27, 2011 at 7:26 pm
Evil Kraig F (10/27/2011)
Seeking fresh Beer Popsicle suppliers. The Dust Bunnies have gone on strike until I stock up...
😀
--Jeff Moden
Change is inevitable... Change for the better is not.
October 28, 2011 at 5:55 am
WayneS (10/27/2011)
Kiara (10/27/2011)
Stefan Krzywicki (10/26/2011)
Kiara (10/26/2011)
Droid Bionic here. I have an iPad2 - and I just don't like it all that much.
What dont you like about it? Everyone I know that has one loves it, so I'd be interested in hearing a different opinion.
Sending you a PM, rather than clutter up the Thread...
Kiara, please reconsider. While I have and and really do like my iPad2, I am interested in seeing why those that don't like it don't. Plus, anything (except code and deep technical questions) are fair game on The Thread.
*sigh* Ok, but no product wars, please.
Here's what I sent Stefan:
Let's start by saying that I *want* to love the iPad. I really do. I work in an office full of Apple fanatics, and it would be great to fit in.
However.
I used to have a Tablet PC. (I still have that machine, actually.) I could *write* on it. With a pencil-sized stylus. It was brilliant. I used it constantly - I can't tell you how many trees I saved with it.
Capacitive screens *can't* create that same experience. I've tried every handwriting app on the planet, and many of the styli. When I just want text, I'll type. When I need free-form, I want a stylus and a really responsive surface.
Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can be charged from the laptop's USB port - why does Apple not allow this for my iPad?
I also type extremely quickly. So I find the process of typing on the screen really, really slows me down.
I find it useful for certain types of activities - a quick check on server status, checking in on dashboards, that type of thing. But, for me, it's a device where I consume information, not a device where I input information. And that's where I think it's really useful for a lot of folks, but just doesn't work for me.
I can actually reply to email faster on my Droid Bionic than I can on the iPad...
I honestly think it all depends on how you interact with your computers. Folks I know who play a lot of games, watch a lot of TV or movies on them? They love 'em. The games I play require much better hardware than any tablet, I don't watch much TV (and then not on my computers), and I adore eInk for reading (you'll pry both of my Kindles from my cold, dead hands).
So there you have it, in a nutshell.
Now I'm off to find a way to deliver SSRS reports to the iPad... 🙂
-Ki
October 28, 2011 at 6:33 am
Kiara (10/28/2011)
Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can be charged from the laptop's USB port - why does Apple not allow this for my iPad?
The iPad does charge from a computer's USB port. I know, my plug failed a day after I bought mine, so for the first week that was the only way I could charge it.
Due to the limited power available from a USB port and the relatively high power consumption (higher than an iPod), the iPad has to be off (sleeping) to charge. If it's on and in use, it draws power from the computer for usage, not to charge.
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
October 28, 2011 at 6:42 am
Tom Brown (10/27/2011)
Hi All.Its been a while since I've been active in "the thread".
Sorry to barge in throwing you off the important subjects of phone choice and how best to hide your appointments from your wife, however I have a little dilemma and would appreciate throwing this open for the group to kick around in any way you feel may be of use.
I have to peer review a colleagues T-SQL code. Now I know how touchy people can be over having their code criticised. I mean someone peer reviewed some of my C++ recently - and, while all they said was true, it still sucks to be told!
I'd appreciate any suggestions, experiences, guidelines, or links. (And ways to prevent it ending in fisticuffs)
Most importantly, don't ever use the word "you" in a negative sentence when peer reviewing.
Never: "You need to change this part".
Instead: "Here are some references on alternate means of accomplishing what this part is intended for, and some pros and cons on the differing methodologies".
Never: "Your code needs to be fixed here".
Instead: "There may be unintended consequences from this implementation. Please clarify why it was chosen over method X".
In other words, try not to sound like Joe Celko when reviewing their code. Before you speak/write, think "would I want someone to say that to me?", and if you have to even hestitate on that, work out a different wording.
- 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
October 28, 2011 at 6:47 am
GilaMonster (10/28/2011)
Kiara (10/28/2011)
Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can be charged from the laptop's USB port - why does Apple not allow this for my iPad?The iPad does charge from a computer's USB port. I know, my plug failed a day after I bought mine, so for the first week that was the only way I could charge it.
Due to the limited power available from a USB port and the relatively high power consumption (higher than an iPod), the iPad has to be off (sleeping) to charge. If it's on and in use, it draws power from the computer for usage, not to charge.
Hm. That's good to hear - because I've had several of our iPad crowd tell me otherwise when I asked them to help me figure out why the thing wasn't charging that way.
Experimentation will happen this evening - I've got a full charge now, but I can easily run it down during the day. And this is one of those things I've thought was very, very strange - so I'm certainly happy to have that misunderstanding corrected.
Many thanks!
-Ki
October 28, 2011 at 6:49 am
Kiara (10/28/2011)
WayneS (10/27/2011)
Kiara (10/27/2011)
Stefan Krzywicki (10/26/2011)
Kiara (10/26/2011)
Droid Bionic here. I have an iPad2 - and I just don't like it all that much.
What dont you like about it? Everyone I know that has one loves it, so I'd be interested in hearing a different opinion.
Sending you a PM, rather than clutter up the Thread...
Kiara, please reconsider. While I have and and really do like my iPad2, I am interested in seeing why those that don't like it don't. Plus, anything (except code and deep technical questions) are fair game on The Thread.
*sigh* Ok, but no product wars, please.
Here's what I sent Stefan:
Let's start by saying that I *want* to love the iPad. I really do. I work in an office full of Apple fanatics, and it would be great to fit in.
However.
I used to have a Tablet PC. (I still have that machine, actually.) I could *write* on it. With a pencil-sized stylus. It was brilliant. I used it constantly - I can't tell you how many trees I saved with it.
Capacitive screens *can't* create that same experience. I've tried every handwriting app on the planet, and many of the styli. When I just want text, I'll type. When I need free-form, I want a stylus and a really responsive surface.
Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can be charged from the laptop's USB port - why does Apple not allow this for my iPad?
I also type extremely quickly. So I find the process of typing on the screen really, really slows me down.
I find it useful for certain types of activities - a quick check on server status, checking in on dashboards, that type of thing. But, for me, it's a device where I consume information, not a device where I input information. And that's where I think it's really useful for a lot of folks, but just doesn't work for me.
I can actually reply to email faster on my Droid Bionic than I can on the iPad...
I honestly think it all depends on how you interact with your computers. Folks I know who play a lot of games, watch a lot of TV or movies on them? They love 'em. The games I play require much better hardware than any tablet, I don't watch much TV (and then not on my computers), and I adore eInk for reading (you'll pry both of my Kindles from my cold, dead hands).
So there you have it, in a nutshell.
Now I'm off to find a way to deliver SSRS reports to the iPad... 🙂
I'd say every one of the drawbacks you listed applies equally to my Galaxy tablet.
I improved the typing input by getting a better (more predictive) "keyboard" for it. But input is still very, very slow and cumbersome compared to a real keyboard.
Touch is faster than mousing, but since I use a trackball with four buttons and a scroll-wheel that can act as a fifth button, touch doesn't anywhere near that flexibility.
So, yeah, as a media consumption device, it rocks. Not much of a "computer" though, in terms of interaction and input.
That's why I think the Kindle Fire will rock the market. It doesn't even try to be anything but a media interface. Optimized and designed for that.
- 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
October 28, 2011 at 6:50 am
GilaMonster (10/28/2011)
Kiara (10/28/2011)
Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can be charged from the laptop's USB port - why does Apple not allow this for my iPad?The iPad does charge from a computer's USB port. I know, my plug failed a day after I bought mine, so for the first week that was the only way I could charge it.
Due to the limited power available from a USB port and the relatively high power consumption (higher than an iPod), the iPad has to be off (sleeping) to charge. If it's on and in use, it draws power from the computer for usage, not to charge.
Ditto for Galaxy tab. No recharge from USB unless it's off.
- 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
October 28, 2011 at 6:55 am
Kiara (10/28/2011)
Hm. That's good to hear - because I've had several of our iPad crowd tell me otherwise when I asked them to help me figure out why the thing wasn't charging that way.
I could make several comments about the fanbois, but I'll pass for now. :hehe:
It definitely, absolutely does charge that way (well, my iPad 1 does)
Experimentation will happen this evening - I've got a full charge now, but I can easily run it down during the day. And this is one of those things I've thought was very, very strange - so I'm certainly happy to have that misunderstanding corrected.
It's very slow to charge through a PC, so don't leave it for 5 min and check. Leave for an hour or 2.
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
October 28, 2011 at 6:57 am
GSquared (10/28/2011)
I improved the typing input by getting a better (more predictive) "keyboard" for it. But input is still very, very slow and cumbersome compared to a real keyboard.
I can type quite fast on my iPad, close to normal keyboard, but I know I'm in the minority on that point. I'll often take iPad over laptop if I'm going to be just writing articles/blog posts at a local coffee shop.
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
October 28, 2011 at 7:14 am
GilaMonster (10/28/2011)
GSquared (10/28/2011)
I improved the typing input by getting a better (more predictive) "keyboard" for it. But input is still very, very slow and cumbersome compared to a real keyboard.I can type quite fast on my iPad, close to normal keyboard, but I know I'm in the minority on that point. I'll often take iPad over laptop if I'm going to be just writing articles/blog posts at a local coffee shop.
I type 120 wpm on my "ergo keyboard". Or did the last time I was speed-tested, anyway. My grandmother started teaching me how to type when I was 6 or 7 years old, so I've been touch-typing for about 35 years.
I've been using the tablet for about 2 months.
It's slow for me on the tablet, but it may be an unfair comparison until I've been using it for a while longer. Slightly, maybe, a tiny bit unfair to compare. Maybe. Sort of.
- 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
October 28, 2011 at 8:31 am
Kiara (10/28/2011)
GilaMonster (10/28/2011)
Kiara (10/28/2011)
Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can be charged from the laptop's USB port - why does Apple not allow this for my iPad?The iPad does charge from a computer's USB port. I know, my plug failed a day after I bought mine, so for the first week that was the only way I could charge it.
Due to the limited power available from a USB port and the relatively high power consumption (higher than an iPod), the iPad has to be off (sleeping) to charge. If it's on and in use, it draws power from the computer for usage, not to charge.
Hm. That's good to hear - because I've had several of our iPad crowd tell me otherwise when I asked them to help me figure out why the thing wasn't charging that way.
Experimentation will happen this evening - I've got a full charge now, but I can easily run it down during the day. And this is one of those things I've thought was very, very strange - so I'm certainly happy to have that misunderstanding corrected.
Many thanks!
Years ago my roommate had one of the original iPods. When we plugged it into her mac, it charged no problem. If we plugged it into my pc through USB or Firewire, it simply wouldn't charge. I was able to power other things through the USB on my PC, just not the iPod.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 15 posts - 31,261 through 31,275 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply