SQL tools - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

SQL tools

Author

Topic

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-06-19 : 00:49:07

Hi guys,
for one of our forthcoming sql project.
I need your inputs/recommedations on the tools and techniques widely used in SQL SERVER based on the following parameters

Design efficient schemas
optimizing queries, stored procedures
fine - tuning indexes
Performing efficient transactions
analyze and understand execution plans
Scalability pitfalls
Test and monitor data access performance
Generate historical and reporting data
Processor,memory and performance related bottlenecks
DISK I/O related bottlenecks.

SQL IN Minds

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-06-19 : 01:48:51

Apart from the tools that come with the SQL Server installation , I would recommend the Inside SQL Server 2005 series - particuarly the Query Tuning version

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-06-19 : 03:19:33

quote:
Originally posted by jackv

Apart from the tools that come with the SQL Server installation , I would recommend the Inside SQL Server 2005 series - particuarly the Query Tuning version

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

hi Jack thanks for reply can you specify in details the features and benefits

SQL IN Minds

pootle_flump

1064 Posts

Posted - 2008-06-19 : 07:53:26

They are books. The features are fantastic coverage of key SQL Server topics by top class authors, the benefits are you will be able to do much of what you said in your first post without much recourse to tools.

In terms of designing efficient schemas - learn database modelling.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 09:07:40

All of these answers , you can find in:

www.sql-server-performance.com

and MSDN : WeBcasts for them

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources