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

Execution Plans Expand / Collapse
Author
Message
Posted Thursday, August 31, 2006 9:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 27, 2014 8:05 AM
Points: 77, Visits: 112
A nice topic but it needs to explain what does the statistics is all about so that the execution plan can say the sql statement is optimized.
Post #305406
Posted Monday, October 9, 2006 5:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 15, 2011 7:20 AM
Points: 21, Visits: 24

Good article.  Used the exact names of the index methods many times(so it should be easy to find in the future).

However, who really needs help in tuning a simple (select somecolumn1, somecolumn2, somecolumn3 from sometable) query?  Don't get me wrong, the article had value, but I never have perfomance troubles with the simple queries.  The ones with 4 or more joins involved cause troubles for us to tune.

It's not just this article...  I'd love to see more exaples that are closer to real world usage of a SQL server using realtional data...

I'd love to see a follow up article on this that would give us a deeper understanding of SQL tuning.

Post #314061
Posted Monday, October 9, 2006 10:41 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 4, 2013 2:38 PM
Points: 53, Visits: 37
Excellent article. It is really well explained.



Pankaj Khanna
Database Administrator - SQL Server 2000

Keep hope to keep you intact...
Post #314239
Posted Tuesday, October 10, 2006 4:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 6, 2006 10:22 PM
Points: 1, Visits: 1

Goodone.Even Beginner can Understand from his explanation.Thanks Vijay!!!

 

Post #314295
Posted Thursday, October 26, 2006 3:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 27, 2013 2:06 AM
Points: 9, Visits: 53
Good Thumbs UP. Must read for beginner.
Post #318221
Posted Wednesday, November 15, 2006 7:07 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 26, 2008 12:37 AM
Points: 35, Visits: 21
As long as one understand what author is trying to explain, what language or for that matter grammer do not matter. One needs to understand, he is not teaching English. Great work VijayKumar.
Post #323311
Posted Thursday, April 12, 2007 9:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 27, 2007 5:46 AM
Points: 152, Visits: 1

Vijay,

Good Explain and i like the way of explaining.

 

 




Post #357915
Posted Saturday, April 21, 2007 2:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, February 10, 2014 2:37 AM
Points: 237, Visits: 98
Nice article.


Regards,

Ganesh

Post #360124
Posted Wednesday, November 14, 2007 4:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 1, 2011 3:10 AM
Points: 1, Visits: 23
Date: 14th November 2007
Hi Vijay!
I am Chandrajit Samanta, working in a product based s/w org (Metrica Systems Pvt. Ltd.) in Bangalore. We are using SQL Server 2000, C#, ASP.NET for our product. My work is mainly database intensive. Frequently I have to deal with heterogeneous database environment like Informix, Oracle, Sql Server simultaniously.

I have to fetch records from Informix, oracle database to our SQL Server Database. For which I have to create several DTS.

But the problem is, original tables (Informix,Oracle) has billions of records. For that to run one simple query like (Select * from Table_name where dtDate > '2007-11-01 17:00:00.000') in DTS it tooks 25min - 35min time.

We have only "Read Only " access i.e. select priviledge to all those (Informix,Oracle) database.

Please tell me how to improve such query so that this query running time is minimized.

I am waiting for your response.
Regards,
Chandrajit Samanta
chandrajit.samanta@gmail.com
MBM(Systems),B.E.(Electrical)
9986044300, Bangalore
Post #422030
Posted Thursday, May 15, 2008 8:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 8, 2008 9:41 PM
Points: 29, Visits: 113
Good Job Vijay & appreciate your sharing attitude.
Please continue posting such in future too.


Post #501362
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse