Save Query Designer Layout

I launch the Query Designer from the Microsoft SQL Server 2005 Management
Studio to design some queries. Can anyone tell me if there is a way to save
the graphical layout of the tables, joins, etc.? Am I missing something
really basic?
Rob (Rob@.discussions.microsoft.com) writes:
> I launch the Query Designer from the Microsoft SQL Server 2005
> Management Studio to design some queries. Can anyone tell me if there
> is a way to save the graphical layout of the tables, joins, etc.? Am I
> missing something really basic?
I don't think there any such option. If you feel this is important, you
can suggest it on http://connect.microsoft.com/sql
Personally, my enthusiasm for the Query Designer is low. There are
very many queries that it is not able to manage, and if you want to
evolve as an SQL programmer, using QD too much may hold you back.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Thanks for the feedback Erland. I often use Query Designer just to get
started on the basics of a query. Is there another tool you recommend or is
your preference just to code the whole thing from scratch?
"Rob" wrote:

> I launch the Query Designer from the Microsoft SQL Server 2005 Management
> Studio to design some queries. Can anyone tell me if there is a way to save
> the graphical layout of the tables, joins, etc.? Am I missing something
> really basic?

SAN And Drive Config

Hi
I have been reading recently that the most important area of design in a SQL
system is the drive subsystem. With this I would appreciate some feedback on
the type of issues relating to this, drive spindles, speed of drives, LUN
configs on the SAN and so on.
ThanksIn an ideal world, you would have these all on different spindles:
O/S, SQL Server program files
TempDB
Data files
Log files
Backup files
Make sure the SAN admin(s) gets actual different spindles, not just
different LUNs in the same disk group. My terminology is probably off, but
I think the point is clear
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"News Microsoft" <thestig@.nobody.com> wrote in message
news:O98pYd$dFHA.2960@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have been reading recently that the most important area of design in a
> SQL system is the drive subsystem. With this I would appreciate some
> feedback on the type of issues relating to this, drive spindles, speed of
> drives, LUN configs on the SAN and so on.
> Thanks
>
>|||Well, actually the MOST important area where the most performance can be
gained is in the database design. Assuming the database design is
optimal, then you are correct, look at the disk subsystem.
Disk subsystem design could be summarised in a white paper, not in a
single usenet message. Have a search in google - there' plenty of topics
online that discusses this. Sorry I don't have any links for you at the mo.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
News Microsoft wrote:
> Hi
> I have been reading recently that the most important area of design in a SQL
> system is the drive subsystem. With this I would appreciate some feedback on
> the type of issues relating to this, drive spindles, speed of drives, LUN
> configs on the SAN and so on.
> Thanks
>
>|||awesome article on this topic on SQLServerCentral.com
check it out
Greg Jackson
PDX, Oregon

SAN And Drive Config

Hi
I have been reading recently that the most important area of design in a SQL
system is the drive subsystem. With this I would appreciate some feedback on
the type of issues relating to this, drive spindles, speed of drives, LUN
configs on the SAN and so on.
ThanksIn an ideal world, you would have these all on different spindles:
O/S, SQL Server program files
TempDB
Data files
Log files
Backup files
Make sure the SAN admin(s) gets actual different spindles, not just
different LUNs in the same disk group. My terminology is probably off, but
I think the point is clear
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"News Microsoft" <thestig@.nobody.com> wrote in message
news:O98pYd$dFHA.2960@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have been reading recently that the most important area of design in a
> SQL system is the drive subsystem. With this I would appreciate some
> feedback on the type of issues relating to this, drive spindles, speed of
> drives, LUN configs on the SAN and so on.
> Thanks
>
>|||Well, actually the MOST important area where the most performance can be
gained is in the database design. Assuming the database design is
optimal, then you are correct, look at the disk subsystem.
Disk subsystem design could be summarised in a white paper, not in a
single usenet message. Have a search in google - there' plenty of topics
online that discusses this. Sorry I don't have any links for you at the mo.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
News Microsoft wrote:
> Hi
> I have been reading recently that the most important area of design in a S
QL
> system is the drive subsystem. With this I would appreciate some feedback
on
> the type of issues relating to this, drive spindles, speed of drives, LUN
> configs on the SAN and so on.
> Thanks
>
>|||awesome article on this topic on SQLServerCentral.com
check it out
Greg Jackson
PDX, Oregon

SAN And Drive Config

Hi
I have been reading recently that the most important area of design in a SQL
system is the drive subsystem. With this I would appreciate some feedback on
the type of issues relating to this, drive spindles, speed of drives, LUN
configs on the SAN and so on.
Thanks
In an ideal world, you would have these all on different spindles:
O/S, SQL Server program files
TempDB
Data files
Log files
Backup files
Make sure the SAN admin(s) gets actual different spindles, not just
different LUNs in the same disk group. My terminology is probably off, but
I think the point is clear
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"News Microsoft" <thestig@.nobody.com> wrote in message
news:O98pYd$dFHA.2960@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have been reading recently that the most important area of design in a
> SQL system is the drive subsystem. With this I would appreciate some
> feedback on the type of issues relating to this, drive spindles, speed of
> drives, LUN configs on the SAN and so on.
> Thanks
>
>
|||Well, actually the MOST important area where the most performance can be
gained is in the database design. Assuming the database design is
optimal, then you are correct, look at the disk subsystem.
Disk subsystem design could be summarised in a white paper, not in a
single usenet message. Have a search in google - there' plenty of topics
online that discusses this. Sorry I don't have any links for you at the mo.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
News Microsoft wrote:
> Hi
> I have been reading recently that the most important area of design in a SQL
> system is the drive subsystem. With this I would appreciate some feedback on
> the type of issues relating to this, drive spindles, speed of drives, LUN
> configs on the SAN and so on.
> Thanks
>
>
|||awesome article on this topic on SQLServerCentral.com
check it out
Greg Jackson
PDX, Oregon

Sample Word docs and workbooks for DW Design

At my old job, I found a set of Word templates and Excel workbooks that helped in data warehouse specification, design and build.

Unfortunately I lost the link in my move to a new job & wondered if anyone else had it off the top of their head... ?

I believe they were all linked to a MSFT white paper but can't seem to find it

Microsoft Office templates are here:

http://office.microsoft.com/en-us/templates/FX100595491033.aspx

More here:

http://www.microsoft.com/canada/smallbiz/managingbizfundamentals/resources.mspx

More info on DW process here:

http://msdn2.microsoft.com/en-us/library/ms345127.aspx

And this one is an oldie but a goodie:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

The latest BI info is here:

http://www.microsoft.com/sql/solutions/bi/default.mspx

Sample Database Designs ?

I would like to learn more about DataBase Design and Data Modelling. Are
there any Sample OLTP/OLAP Data Models that I can find
on the web for my edification?
Thanks,
rgnSee if this helps:
http://www.databaseanswers.org/data_models/index.htm
AMB
"rgn" wrote:

> I would like to learn more about DataBase Design and Data Modelling. Are
> there any Sample OLTP/OLAP Data Models that I can find
> on the web for my edification?
> Thanks,
> rgn
>
>|||They are called "database meta models" or "meta data models" or some
variation, and you can find some good books on the subject from Wiley.
http://search.barnesandnoble.com/bo...Ajl&cds2Pid=946
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:eWSLA1DEFHA.1396@.tk2msftngp13.phx.gbl...
> I would like to learn more about DataBase Design and Data Modelling. Are
> there any Sample OLTP/OLAP Data Models that I can find
> on the web for my edification?
> Thanks,
> rgn
>|||here's one place i found.
http://www.databaseanswers.org/data_models/index.htm
"rgn" wrote:

> I would like to learn more about DataBase Design and Data Modelling. Are
> there any Sample OLTP/OLAP Data Models that I can find
> on the web for my edification?
> Thanks,
> rgn
>
>