Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Good SQL Server article Expand / Collapse
Author
Message
Posted Friday, June 26, 2009 2:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, June 26, 2009 2:53 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 35,609, Visits: 32,197
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 "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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #742982
Posted Friday, June 26, 2009 3:07 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, 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
Posted Friday, June 26, 2009 3:19 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 35,609, Visits: 32,197
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 "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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #742993
Posted Friday, June 26, 2009 3:23 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, 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
Posted Friday, June 26, 2009 3:25 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 35,609, Visits: 32,197
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #742996
Posted Monday, June 29, 2009 6:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 14,034, Visits: 28,406
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 Query Performance Tuning
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
Posted Monday, June 29, 2009 8:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 40,438, Visits: 36,895
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
Posted Monday, June 29, 2009 10:22 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, November 3, 2014 2:42 PM
Points: 1,683, Visits: 1,798
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
Posted Monday, June 29, 2009 11:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:30 AM
Points: 7,154, Visits: 15,647
(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 »

Add to briefcase 12»»

Permissions Expand / Collapse