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»»

Optimizing a cursor based routine – Part 2 Expand / Collapse
Author
Message
Posted Monday, June 27, 2011 9:20 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, March 8, 2015 12:52 PM
Points: 1,778, Visits: 8,352
Comments posted to this topic are about the item Optimizing a cursor based routine – Part 2



Clear Sky SQL
My Blog
Post #1132599
Posted Tuesday, June 28, 2011 9:55 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 5:02 PM
Points: 18,669, Visits: 16,930
Just to nitpick something. The adventureworks sales were understated by ~ $22M, not $28M.


Nice article Dave.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1133016
Posted Tuesday, June 28, 2011 11:03 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 11, 2014 8:08 AM
Points: 73, Visits: 765
Thank you.

I understand the topic of optimizing a cursor based routine pretty well and yet again another day comes where I learn how much more I have to learn. I can't wait to try out some of these techniques on some more complex reports!
Post #1133090
Posted Tuesday, June 28, 2011 11:56 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 22, 2015 8:32 AM
Points: 3,592, Visits: 2,098
Very nice article. We have very few cursors but I have learned other performance improving tips from this article regardless.
Post #1133135
Posted Tuesday, June 28, 2011 4:18 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:49 PM
Points: 5,405, Visits: 9,260
Good job Dave - very well written.

Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1133318
Posted Tuesday, June 28, 2011 5:02 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:03 AM
Points: 5,042, Visits: 12,006
Top-notch contributions from you Dave, as usual!
Keep up the great job.


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1133335
Posted Wednesday, June 29, 2011 2:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, March 8, 2015 12:52 PM
Points: 1,778, Visits: 8,352
Thanks all,

Enjoyed doing it, now to find the next set of bad code to write about :)




Clear Sky SQL
My Blog
Post #1133501
Posted Wednesday, June 29, 2011 1:17 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, March 8, 2015 12:52 PM
Points: 1,778, Visits: 8,352
Something tells me you are not a fan of AdventureWorks Joe ;)



Clear Sky SQL
My Blog
Post #1134030
Posted Thursday, June 30, 2011 3:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 13, 2015 6:48 PM
Points: 13, Visits: 76
Dave, excellent job with the post! Very informative and good example to demo the technology.

Big Question: Where can I find the AdventureWorks2008R2 database?

I was running it against the AdventureWorks database but some of the columns/tables are missing....

I have downloaded almost everything off codeplex, and I have found these databases:

1) adventureworks
2) adventureworksDW
3) adventureworksDW2008
4) adventureworksDW2008R2
5) adventureworksLT
6) adventureworksLT2008R2

But no database named "AdventureWorks2008R2"?
Post #1134752
Posted Monday, July 4, 2011 2:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 26, 2011 9:41 AM
Points: 3, Visits: 7
If you don't see the DB called AdventureWorks2008R2 then it is because you don't have FILESTREAM installed/running. Go here and follow the instructions.

http://msftdbprodsamples.codeplex.com/releases/view/59211

(can you tell I did this already too )
Post #1136148
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse