how create a installation for a database

how i can create a installation for my server database like the installation of examples northwind

I ask for how i can deploy my database

thanks

Your question is not very clear.

If you are asking how to install and setup SQL Server, then which version do you have in mind? See this link for version differences:

SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

If you need specifc assistance in installing SQL Server, this might help:

SQL Server 2005 Express –Installation Details
http://msdn2.microsoft.com/en-us/library/ms143441.aspx

SQL Server 2005 Express Overview
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
http://www.pcw.co.uk/personal-computer-world/software/2155087/review-microsoft-sql-server

If you need other information, please try to be more specific in your question so that we can best help you.

Thanks

|||

hi,

you can go with different techniques... you can just "copy" you database's files (data file(s) and transaction log file(s)) into the end-user machine and attach those databases as explained in many articles, and the very same is valid for restoring a prepared database backup onto the end-user machine...

personally I do prefer another approach, similar to the one presented in a great article, where you only deploy DDL schema scripts, DML INSERT/UPDATE scripts.. personally I add plain tex file to be bulk inserted as well for pre-populated table, but the concept is the same..
this method grants you the possibility to maintain your database scripts under source code control, so that your entire production/deployment phase can be verified... better, it grants you the metadata management/upgrade path you will incur with (and it will soon or later ) so that you'll not have to warry abour how to deploy these changes... it also grants you that end-users created databases inherit instance's properties form your customer's specs and not your own, as those db will use the end-user's model database.

all these are "free" ways to do it.. but you can even rely on third party tools, this one is able to produce a self-installing exe, that's to say, once running, it will install new database(s) and even update existing one(s) to the desired metadata schema..

again, personally I go for the "scripts" solution..

regards

How can we determine status of defined aggregates

We have a large Analysis Services 2005 installation with many partitions.

Is there an XMLA command or MDX query that will list all of the defined aggregations and their current status? We would like to run this command after an incremental update to make sure that we have not had an inadvertant dropping of aggregates.

Thanks,

Marty

I think you want the DISCOVER_PARTITION_STAT command. It should return a list of the aggs that are processed. If the list it returns is missing any, then you know

Code Snippet

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

<RequestType>DISCOVER_PARTITION_STAT</RequestType>

<Restrictions>

<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">

<DATABASE_NAME>Adventure Works DW</DATABASE_NAME>

<CUBE_NAME>Adventure Works</CUBE_NAME>

<MEASURE_GROUP_NAME>Internet Sales</MEASURE_GROUP_NAME>

<PARTITION_NAME>Internet_Sales_2003</PARTITION_NAME>

</RestrictionList>

</Restrictions>

<Properties>

</Properties>

</Discover>

That's a bit difficult to read because it returns XML, so I'd suggest you check out a stored proc Darren Gosbell wrote at http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=XmlaDiscover

It returns a nice table which is easier to read. The equivalent command would be:

Code Snippet

CALL ASSP.Discover("DISCOVER_PARTITION_STAT","<DATABASE_NAME>Adventure Works DW</DATABASE_NAME><CUBE_NAME>Adventure Works</CUBE_NAME><MEASURE_GROUP_NAME>Internet Sales</MEASURE_GROUP_NAME><PARTITION_NAME>Internet_Sales_2003</PARTITION_NAME>")

If anyone else has other suggestions for better ways to quickly identify which aggs aren't processed, I'd like to hear it.

|||This worked great. Thanks.|||

We have a large number of aggregates that are showing a size of 0. What exactly does that mean? I've been unable to find any reference to aggregation_size.

<row>

<DATABASE_NAME>Phase 1</DATABASE_NAME>

<CUBE_NAME>Sales</CUBE_NAME>

<MEASURE_GROUP_NAME>Sales</MEASURE_GROUP_NAME>

<PARTITION_NAME>S200511</PARTITION_NAME>

<AGGREGATION_NAME>Aggregation 54</AGGREGATION_NAME>

<AGGREGATION_SIZE>0</AGGREGATION_SIZE>

</row>

Thanks,

Marty

|||

AGGREGATION_SIZE means the number of rows in that agg. For instance, if you have a partition for 2006 that has 1000 rows in the fact table then the XMLA query I mentioned above will give show you one <row> tag with no AGGREGATION_NAME showing AGGREGATION_SIZE of 1000. Then if you have a simple agg built on calendar month and nothing else, you should see another <row> showing an AGGREGATION_SIZE of 12 (meaning there are 12 rows in that agg, one for each month). Make sense?

Because you're seeing sizes of 0, I assume that means that there are no rows in your fact table for that partition. Can you confirm this?

How can we determine status of defined aggregates

We have a large Analysis Services 2005 installation with many partitions.

Is there an XMLA command or MDX query that will list all of the defined aggregations and their current status? We would like to run this command after an incremental update to make sure that we have not had an inadvertant dropping of aggregates.

Thanks,

Marty

I think you want the DISCOVER_PARTITION_STAT command. It should return a list of the aggs that are processed. If the list it returns is missing any, then you know

Code Snippet

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

<RequestType>DISCOVER_PARTITION_STAT</RequestType>

<Restrictions>

<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis">

<DATABASE_NAME>Adventure Works DW</DATABASE_NAME>

<CUBE_NAME>Adventure Works</CUBE_NAME>

<MEASURE_GROUP_NAME>Internet Sales</MEASURE_GROUP_NAME>

<PARTITION_NAME>Internet_Sales_2003</PARTITION_NAME>

</RestrictionList>

</Restrictions>

<Properties>

</Properties>

</Discover>

That's a bit difficult to read because it returns XML, so I'd suggest you check out a stored proc Darren Gosbell wrote at http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=XmlaDiscover

It returns a nice table which is easier to read. The equivalent command would be:

Code Snippet

CALL ASSP.Discover("DISCOVER_PARTITION_STAT","<DATABASE_NAME>Adventure Works DW</DATABASE_NAME><CUBE_NAME>Adventure Works</CUBE_NAME><MEASURE_GROUP_NAME>Internet Sales</MEASURE_GROUP_NAME><PARTITION_NAME>Internet_Sales_2003</PARTITION_NAME>")

If anyone else has other suggestions for better ways to quickly identify which aggs aren't processed, I'd like to hear it.

|||This worked great. Thanks.|||

We have a large number of aggregates that are showing a size of 0. What exactly does that mean? I've been unable to find any reference to aggregation_size.

<row>

<DATABASE_NAME>Phase 1</DATABASE_NAME>

<CUBE_NAME>Sales</CUBE_NAME>

<MEASURE_GROUP_NAME>Sales</MEASURE_GROUP_NAME>

<PARTITION_NAME>S200511</PARTITION_NAME>

<AGGREGATION_NAME>Aggregation 54</AGGREGATION_NAME>

<AGGREGATION_SIZE>0</AGGREGATION_SIZE>

</row>

Thanks,

Marty

|||

AGGREGATION_SIZE means the number of rows in that agg. For instance, if you have a partition for 2006 that has 1000 rows in the fact table then the XMLA query I mentioned above will give show you one <row> tag with no AGGREGATION_NAME showing AGGREGATION_SIZE of 1000. Then if you have a simple agg built on calendar month and nothing else, you should see another <row> showing an AGGREGATION_SIZE of 12 (meaning there are 12 rows in that agg, one for each month). Make sense?

Because you're seeing sizes of 0, I assume that means that there are no rows in your fact table for that partition. Can you confirm this?

How can I use DTS with Sql Server Express 2005?

I downloaded the tookit and it put the DTS tools in the installation,
but I still can't use them from within the CTP management studio.
There is still not export database.
Can DTS be used with Sql Server Express 2005? If not why did it
install? Thank you for any help.
jm wrote:
> I downloaded the tookit and it put the DTS tools in the installation,
> but I still can't use them from within the CTP management studio.
> There is still not export database.
> Can DTS be used with Sql Server Express 2005? If not why did it
> install? Thank you for any help.
I found that after installing the toolkit you have to go to External
Tools in the Management Studio and add it from the 90 binn directory.
I believe it was the dtsexec file.

How can I use DTS with Sql Server Express 2005?

I downloaded the tookit and it put the DTS tools in the installation,
but I still can't use them from within the CTP management studio.
There is still not export database.
Can DTS be used with Sql Server Express 2005? If not why did it
install? Thank you for any help.jm wrote:
> I downloaded the tookit and it put the DTS tools in the installation,
> but I still can't use them from within the CTP management studio.
> There is still not export database.
> Can DTS be used with Sql Server Express 2005? If not why did it
> install? Thank you for any help.
I found that after installing the toolkit you have to go to External
Tools in the Management Studio and add it from the 90 binn directory.
I believe it was the dtsexec file.

How can I use DTS with Sql Server Express 2005?

I downloaded the tookit and it put the DTS tools in the installation,
but I still can't use them from within the CTP management studio.
There is still not export database.
Can DTS be used with Sql Server Express 2005? If not why did it
install? Thank you for any help.jm wrote:
> I downloaded the tookit and it put the DTS tools in the installation,
> but I still can't use them from within the CTP management studio.
> There is still not export database.
> Can DTS be used with Sql Server Express 2005? If not why did it
> install? Thank you for any help.
I found that after installing the toolkit you have to go to External
Tools in the Management Studio and add it from the 90 binn directory.
I believe it was the dtsexec file.

How can I tune-up my SQL installation

Hi,

I have SQL desktop version installed and for the last few days it has really slowed down. I have ran many anti-virus etc. and all is okay on that front.

Any tips regarding how I can tune things up? What should I look for and how do I go about it. Deleting LOG etc. etc?

Please guide.

Thanks.There are many good tips here:

www.sql-server-performance.com|||Thanks for the URL. Will try it out.|||And also keep reference of the books online in most cases.
But as referred that website is an ocean of goodies for SQL performance.