<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Good SQL Server article
13 posts, Page 1 of 2
1
2
»»
Good SQL Server article
Rate Topic
Display Mode
Topic Options
Author
Message
jaclynmcatanzaro
jaclynmcatanzaro
Posted Friday, June 26, 2009 2:49 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, June 26, 2009 2:48 PM
Points: 1,
Visits: 0
Good SQL Server article
http://www.informationflash.com/
Post #742979
Jeff Moden
Jeff Moden
Posted Friday, June 26, 2009 2:53 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:36 PM
Points: 32,931,
Visits: 26,820
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/
Which one?
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #742982
Florian Reischl
Florian Reischl
Posted Friday, June 26, 2009 3:07 PM
SSCrazy
Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087,
Visits: 3,932
Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/
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
The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL
How to Post Data/Code to get the best Help
How to Post Performance Problems
Post #742988
Jeff Moden
Jeff Moden
Posted Friday, June 26, 2009 3:19 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:36 PM
Points: 32,931,
Visits: 26,820
Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #742993
Florian Reischl
Florian Reischl
Posted Friday, June 26, 2009 3:23 PM
SSCrazy
Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087,
Visits: 3,932
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/
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.
The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL
How to Post Data/Code to get the best Help
How to Post Performance Problems
Post #742995
Jeff Moden
Jeff Moden
Posted Friday, June 26, 2009 3:25 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:36 PM
Points: 32,931,
Visits: 26,820
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #742996
Grant Fritchey
Grant Fritchey
Posted Monday, June 29, 2009 6:38 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383,
Visits: 25,189
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
The Scary DBA
Author of:
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans
Product Evangelist for
Red Gate Software
Post #743572
GilaMonster
GilaMonster
Posted Monday, June 29, 2009 8:11 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744,
Visits: 30,025
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/
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 2008, MVP
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
Post #743646
Jonathan Kehayias
Jonathan Kehayias
Posted Monday, June 29, 2009 10:22 AM
SSCommitted
Group: General Forum Members
Last Login: Sunday, May 12, 2013 4:26 PM
Points: 1,696,
Visits: 1,742
GilaMonster (6/29/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/
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.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog
|
Twitter
|
MVP Profile
Training
|
Consulting
|
Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #743780
Matt Miller (#4)
Matt Miller (#4)
Posted Monday, June 29, 2009 11:59 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:43 PM
Points: 6,998,
Visits: 13,952
(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?
Post #743864
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
