SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Writing SQL Faster


Writing SQL Faster

Author
Message
Tom Fischer
Tom Fischer
SSC-Enthusiastic
SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)

Group: General Forum Members
Points: 119 Visits: 65
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/tFischer/3050.asp
MVDBA
MVDBA
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5513 Visits: 860
I hate the way articles on this site have started to become "adverts"

if it's a balanced article about the merits of refactoring and intellisense then mention the competition.

what could have been a good article just irritated the hell out of me - perhapsthere should be a seperate section for product reviews. then articles such as "writing sql faster" can be about reducing the amount of code you actually use, or using re-usable code. - articles about DR can be about best practices and unforseen circumstances rather than redgate sql backup.

maybe i just got out of bed on the wrong side this morning , but after i opened the link to what looked like a promising article and found a redgate advert i just started to go GRRRRRRRRR

MVDBA
Ben-425648
Ben-425648
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 51
One reason never to use this product, just how is

SELECT
@error = @@ERROR
IF
0 = @error
AND
0 < @@trancount

COMMIT
ELSE

ROLLBACK
END

easier to read than

if 0 = @error AND 0 < @@trancount
Commit
else
Rollback
END

???

Also whats with the shocking tabbing?? For readability both examples aren't great, but the 'refactored' version is definitely worse!
hr_sn
hr_sn
Old Hand
Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)

Group: General Forum Members
Points: 392 Visits: 384
I don't know if it's true or not but I've read somewhere on Internet in some article that intellisense will be there in SQL 2008. Does anyone know if its true?
Andy Warren
Andy Warren
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: Moderators
Points: 25407 Visits: 2746

I think maybe a better title would have helped, it really does feel like a review. Nothing wrong with a review and in the course of that I'd expect someone to show me how I'd benefit (or not) from buying the product. I would definitely like to see an article that looks at the state of Intellisense type implementations across vendors, including MS.



Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Jody-278871
Jody-278871
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 21
Product literature belongs at www.red-gate.com. Not even a mention of other techniques, or products. Bush league guys.
John Bradford-346000
John Bradford-346000
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 81

I participated in a technical SQL forum at Tech-ED in Orlando this year that focused on Intellisense that Microsoft is developing for SQL. We saw the current stage of their development and strongly encouraged them to get what they currently have stabilized and to include it in the release of SQL 2008.

We provided feedback on the features we would like to see and how it is to operate. Primarily we said that it should operate much like the Intellisense does in Visual Studio.


Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146424 Visits: 19430
Apologies if any of you felt decieved, but I mentioned this was a short tutorial on Red Gate's products in the description. It was definitely sent to me as a product review type piece and I ran it as such. We have run product reviews and "white papers" before, so I'm a little surprised by the comments.

The word at TechEd from the PM for tools is that Intellisense WILL be in SS2K8. I didn't see the current state and have no idea how it compares with SQLPrompt, but MS is apparently committed to getting it in SSMS.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jack Straw-249867
Jack Straw-249867
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 29
Steve,
I think the # of "product reviews" has gone way up.
Also, in the past it was easier to recognize real articles of value from product hype.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146424 Visits: 19430
I have tried to run a few more reviews since the advertising has gone down to get exposure to products. This year we've run 11, 82 in 6 years, so slightly up to date. We've run one of OfficeWriter (included in SS2K8), SQLCentric, Typhoon III, NGSQuirrrel, APEX Log, Log Explorer, Refactor, MS's DPM, MS's Web Data Administrator, and now this one.

I'll try to make it clearer it's a review of a product rather than an article in the future. I know that some of you don't want to see reviews, but they do serve a purpose and when you need a product, it's nice that they're out there.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search