Good SQL Server article

Question

Post reply

Good SQL Server article

jaclynmcatanzaro

Valued Member

Points: 71
More actions
June 26, 2009 at 2:49 pm

#155881

Good SQL Server article
http://www.informationflash.com/[/url]

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 1

jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/[/url]

Which one?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 2

Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/[/url]
Which one?

Can't answer your question but the new article by Adam Machanic is really good in my opinion:

The Hidden Costs of INSERT EXEC

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 3

Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/[/url]
Which one?
Can't answer your question but the new article by Adam Machanic is really good in my opinion:
The Hidden Costs of INSERT EXEC

Thanks Flo... I took a quick look. It's a pretty good article except that I have no trust in cost values listed in the execution plan. Just like his conclusion states, I've got some testing to do, I guess.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 4

Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/[/url]
Which one?
Can't answer your question but the new article by Adam Machanic is really good in my opinion:
The Hidden Costs of INSERT EXEC
Thanks Flo... I took a quick look. It's a pretty good article except that I have no trust in cost values listed in the execution plan. Just like his conclusion states, I've got some testing to do, I guess.

Sure, it's a task on my list, too. 😉 But it's really neat that he provides a complete test setup.

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 5

Florian Reischl (6/26/2009)
Sure, it's a task on my list, too. 😉 But it's really neat that he provides a complete test setup.

I agree... it just like some of the good folks on this forum do and it's always a pleasure when the article contains such code.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 6

They should be good articles. They're taking the RSS feeds from all the best blogs and posting them up without attribution and frequently without links. It looks like this place is posting a lot of great content, but they're just aggregating others. Last I heard, they were taken offline pending some adjustment to their methodology.

"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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/[/url]

You mean 'good collection of stolen content' seeing as most of that was copyrighted material reposted without permission and frequently without attribution or links

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 8

GilaMonster (6/29/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/[/url]
You mean 'good collection of stolen content' seeing as most of that was copyrighted material reposted without permission and frequently without attribution or links

Exactly what Gail said, that site is nothing but stolen content from the community, mostly MVP blogs like Gails and the main feed from SQL Blog. It should be the best content online, with the exception that it was reproduced without permission and the site has been taken down by the web hosting company for violations of the Digital Media Copyright Act.

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 9

(cynicism alert)

....seems awfully interesting that was the very first post from the OP....

(/cynicism alert)

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Rajesh kasturi SSCarpal Tunnel Points: 4007 More actions · Answer 10

When I try to access the URL (http://www.informationflash.com/) I am getting the error

Site Temporarily Unavailable

We apologize for the inconvenience. Please contact the webmaster/ tech support immediately to have them rectify this.

error id: "bad_httpd_conf"

ha ha :-), may be some one removed since it is a copyright info..

Rajesh Kasturi

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 11

Matt Miller (6/29/2009)
(cynicism alert)
....seems awfully interesting that was the very first post from the OP....
(/cynicism alert)

Page is down now 😉

Edit: Didn't see Rajesh's post.

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 12

Yes, it was taken down pending an investigation of violation of the DMCA. Here's more detail [/url]for those that are interested.

"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