Regarding dimension renaming in AS2005 while migrtion

Hi,

My datamart has used dots in the dimension name. i.e. I have following dimensions

Users.Sales1 and Users.Sales2.

Currently my application has 2 cubes: Sales1 and Sales2.

Cube Sales1 is assocated with
"Parent Child" dimension Users.Sales1
which is based on view vw_Users_Sales1

Cube Sales2 is assocated with
"Parent Child" dimension Users.Sales2
which is based on view vw_Users_Sales2

Now when I am trying migration wizard, I am getting following dimensions

Users.Sales1 and Users1.Sales2.

Is there some way I can retain the existing naming convension?

And If not them what is the best convension or what will

will be the best possible to handle this scenario.

There are other dimensions as well which are getting renamed like this.

So I will like to know how others are handling this.

Thanks In Advance,

Rahul

The dimension model was changed in 2005. In 2000, you could have dimensions based off different tables that shared a common dimension name. The intention behind this was to support multiple hierarchies for the same dimension, but each one was still implemented as a seperate dimension, they just shared a common root name (Users, in your case).

2005 can now support multiple hierachies in the same dimension. However, they need to come from the same table or view. Since, in your case, they are comming from two different views, the wizard is creating two seperate dimensions. And you since you can't have two dimensions with the same name, the wizard is renaming one of them.

|||John is right, you might find that you are able to create a view or a named query as a quick way to join these tables together.

Regarding dblib

hi..I am running DBLIB (sample application of SQL Server)
between 2k and 2k3. Well seems working perfect..but want
to know whats going on in the Database..I think some
DB configuration (like DB connection or Table creation)
is required to see the effect of executed/commited
transactions..need some guidence.
Thanks in advance
Umer

Try some SQL Engine specific forum, e.g. http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1

This forum is for Integration Services component, not sure if there are appropriate people to respond to this question here.

sql

Regarding dblib

hi..I am running DBLIB (sample application of SQL Server)
between 2k and 2k3. Well seems working perfect..but want
to know whats going on in the Database..I think some
DB configuration (like DB connection or Table creation)
is required to see the effect of executed/commited
transactions..need some guidence.
Thanks in advance
Umer
You shouldn't really invest any more time in DBLib, and move to some other
data access APIs (ADO.NET, OLEDB, ODBC, etc). You might be talking about
SQL2000, but consider what SQL2005 BOL says about Db-Library:
"Although the SQL Server 2005 Database Engine still supports connections
from existing applications using the DB-Library and Embedded SQL APIs, it
does not include the files or documentation needed to do programming work on
applications that use these APIs." on page
http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
Linchi
<umer.zafar@.gmail.com> wrote in message
news:1131628582.386464.75780@.g47g2000cwa.googlegro ups.com...
> hi..I am running DBLIB (sample application of SQL Server)
> between 2k and 2k3. Well seems working perfect..but want
> to know whats going on in the Database..I think some
> DB configuration (like DB connection or Table creation)
> is required to see the effect of executed/commited
> transactions..need some guidence.
> Thanks in advance
> Umer
>

Regarding dblib

hi..I am running DBLIB (sample application of SQL Server)
between 2k and 2k3. Well seems working perfect..but want
to know whats going on in the Database..I think some
DB configuration (like DB connection or Table creation)
is required to see the effect of executed/commited
transactions..need some guidence.
Thanks in advance
UmerTry running the SQL Profiler to trace the database activity.|||(umer.zafar@.gmail.com) writes:
> hi..I am running DBLIB (sample application of SQL Server)
> between 2k and 2k3. Well seems working perfect..but want
> to know whats going on in the Database..I think some
> DB configuration (like DB connection or Table creation)
> is required to see the effect of executed/commited
> transactions..need some guidence.
Difficult to understand what you mean. One very nice feature of DB-Library
is that it does not do things behind your back like those modern API are
fond of doing.
But, alas, Microsoft has put DB-Library on the deprecation list, and
DB-Library does not have support for features added to SQL 7 and later.
While you still connect to SQL 2005 with DB-Library, SQL 2005 does not
come with any files to support DB-Library. A future version of SQL Server
will not support DB-Library at all.
Thus, unless you have some legacy application to maintain, you are best
off staying away from DB-Library.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks..helping to get me my answer

Regarding dblib

hi..I am running DBLIB (sample application of SQL Server)
between 2k and 2k3. Well seems working perfect..but want
to know whats going on in the Database..I think some
DB configuration (like DB connection or Table creation)
is required to see the effect of executed/commited
transactions..need some guidence.
Thanks in advance
Umer
Hi
Run SQL Server Profiler to see what is being sent to SQL Server.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<umer.zafar@.gmail.com> wrote in message
news:1131628639.794052.79080@.g47g2000cwa.googlegro ups.com...
> hi..I am running DBLIB (sample application of SQL Server)
> between 2k and 2k3. Well seems working perfect..but want
> to know whats going on in the Database..I think some
> DB configuration (like DB connection or Table creation)
> is required to see the effect of executed/commited
> transactions..need some guidence.
> Thanks in advance
> Umer
>
|||Hi..Thanks a lot ..answer was very helping.
Regards
Umer

Reg:Tables data changes auditing

Hi,

I have more than 1100 tables in my databse. From existing application data will insert into Database tables. I need to track the tables module wise when data inserting/Updating into these tables.

One way is, I have to write the triggers for each table[1100 tables with auditing]. In my case this is not possible to write like that.

Is thesre any other solution to find the updated,inserted tables when data is changing from application without doing bulk changes.

Regards

Hanu

unfortunately SQL Server can not do this until unless we have our own mechanism.

Madhu

Reg: Table data changes auditing

Hi,

I have more than 1100 tables in my databse. From existing application data will insert into Database tables. I need to track the tables module wise when data inserting/Updating into these tables.

One way is i have to write the triggers for each table[1100 tables with auditing]. In my case this is not possible to write.

Is thesre any other way to find the updated,inserted tables when data is changing from application.

Regards

Hanu

hi,

You may get more help posting it in

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1

SQL Server Database Engine forum

Although i maybe wrong

Good luck

Matt

Refreshing Links in Access doesn't allow me to Add Records!

Hi
I have an application in Access2003 with linked tables. When I create the
links manually (picking DNS etc) I have no problems. When I then try to
recreate the links programatically (different users) I am not able to add an
y
records to any of the tables! If I erase all the linked tables and reconnect
manually with the other user I have no problems!
I am using the relink code from
http://support.microsoft.com/defaul...kb;en-us;159691
Any and all suggestions Welcome!!!
Regards
Meir
Suggestions?There is a seperate newgroup for acceess/adp/sql server integration.
Post there
--
Regards
R.D
--Knowledge gets doubled when shared
"mrrcomp" wrote:

> Hi
> I have an application in Access2003 with linked tables. When I create the
> links manually (picking DNS etc) I have no problems. When I then try to
> recreate the links programatically (different users) I am not able to add
any
> records to any of the tables! If I erase all the linked tables and reconne
ct
> manually with the other user I have no problems!
> I am using the relink code from
> http://support.microsoft.com/defaul...kb;en-us;159691
>
> Any and all suggestions Welcome!!!
> Regards
> Meir
>
> Suggestions?
>|||As long as the user has permissions in the database and you have a
primary key defined on the table, inserts an dupdates shouldn't be a
problem. However, instead of using a DSN, you can supply connection
information in your code. This should get you started:
Public Sub LinkODBConnectionString()
Dim strConnection As String
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = CurrentDb
' Specify the driver, the server, and the connection
strConnection = "ODBC;Driver={SQL Server};" & _
" Server=(local);Database=SqlDbName;Truste
d_Connection=Yes"
' Specifying a SQLS user/password instead of integrated security
' strConnection = "ODBC;Driver={SQL Server};" & _
' " Server=(Local);Database=SqlDbName;UID=Us
erName;PWD=password"
' Create Linked Table. The LinkedTableName and the
' ServerTableName can be the same.
Set tdf = db.CreateTableDef("LinkedTableName")
tdf.Connect = strConnection
tdf.SourceTableName = "ServerTableName"
db.TableDefs.Append tdf
Set tdf = Nothing
End Sub
On Fri, 7 Oct 2005 05:17:03 -0700, "mrrcomp"
<mrrcomp@.discussions.microsoft.com> wrote:

>Hi
>I have an application in Access2003 with linked tables. When I create the
>links manually (picking DNS etc) I have no problems. When I then try to
>recreate the links programatically (different users) I am not able to add a
ny
>records to any of the tables! If I erase all the linked tables and reconnec
t
>manually with the other user I have no problems!
>I am using the relink code from
>http://support.microsoft.com/defaul...kb;en-us;159691
>
>Any and all suggestions Welcome!!!
>Regards
>Meir
>
>Suggestions?sql

Refresh problem in Crystal Viewer control

Dear Guru's
I am using Crystal viewer control in my VC++ application project. Here i am facing report refresh problem. If i call viewer control Refresh method directly the application is crashing. I am calling that inside OnPaint( ) .

The problem is the report data is not displaying first time the user has to click refresh button.

Please help me how to use "Refresh " method.

Thanks
arunNot sure if this will help, but make sure 'Save Data with Report' is NOT checked. Otherwise, have you tried calling Refresh as soon as the report is displayed (instead of waiting for the user to do it)?|||I am trying to refresh the report through code only using Viewer control 'Refresh' method.
If report displayed with blank then how user came to know that he has to refresh the report by clicking refresh button.

Referential integrity during replication

Hello forum

I like to build a custom replication application for a databasee.
To questions concering this. The idea is to use a mechanim, which updates table by table (in sequence).

During the replication proccess I update a table (table1), which has 1 to 1 refenceto a second table(table2). This new record is unsing a reference which hasn't been entered by this time into table 2. This is hurts the referencial integrity, right?

Would it help to use a transaction for the update in table 1 and table 2, when is the integrity checked? At the end of the transaction, by the command commit transaction?

Is it possible to switch on/off the referential integrity check while a database is running? If yes, are there any side effects beside that the integrity is not propre controlles anymore?

Thanks for your help in advance!

DominikWhat about this:

drop table test1
drop table test2
go
create table test2(id int primary key)
create table test1(id int, rid int)
ALTER TABLE test1 WITH NOCHECK ADD CONSTRAINT
FK1 FOREIGN KEY(rid) REFERENCES dbo.test2(id)
go
insert test2 values(1)
insert test1 values(1,1)
go
ALTER TABLE dbo.test1 NOCHECK CONSTRAINT FK1
go
insert test1 values(1,11) -- works

Reference to Data.System.SqlServerCe in VS2005 does not install CE 2.0 to Emulator/PDA

We have a Compact Framework 1.1 application that uses Sql Server CE 2.0. In VS2003, a reference to System.Data.SqlServerCe causes the Sql Server CE dlls and Query Analyzer to install to the Emulator or PDA.

I am currently converting the application to Compact Framework 2.0, but we are not upgrading to Sql Server Mobile (yet). However, the reference to System.Data.SqlServerCe, in VS 2005, no longer causes Sql Server CE to install to the PDA/Emulator.

There is a difference in the build outputs between VS2003 & VS2005. In 2003, System_SR_enu.cab, sqlce.wce4.x86.cab & sqlce.dev.wce4.x86.cab are copied & lanuched. In 2005, only System_SR_enu.cab is copied... no launch.

Any ideas? Reinstall VS2005?

Reinstalling VS2005 resolved this issue.|||

Glad that things are working from your end. Thanks for using SQL Mobile.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

Reference not found using SQL Compact Edition

I'm currently programming a small application for Windows Mobile 5.0 and .NET Compact Frameword 2.0 including SQL Server Compact Edition.

The following code unfortunately does not for compiling.

C#-Code:

38 SqlCeEngine engine = new SqlCeEngine("Data Source = 'test.sdf'");
39 engine.CreateDatabase();
40
41 System.Data.SqlServerCe.SqlCeConnection ssceconn = new SqlCeConnection("Data Source = 'test.sdf'");
42 ssceconn.Open();

There's no more code inside the project except the standard code für a blank Form. I'm getting the following error when i try to compile:

Zeile 41: Der Typ System.Data.Common.DbConnection ist in einer Assembly, auf die nicht verwiesen wird, definiert. Fügen Sie einen Verweis zur Assembly System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 hinzu. (CS0012)

For all those who don't understand german: The Type System.Data.Common.DBConnection is in an assembly for which there isn't a reference defined. Please add a reference for System.Data, Version 2.0.0.0, Culture=....

I already have a reference on System.Data inside my project, and the version, culture and the publickeytoken are the same as required by the compiler... I'm getting really hopeless, does anybody have an idea? Thanks a lot in advance!!

By the way: My system: .NET Framework 1.1, 2.0 and 3.0 as well as .NET Compact Framework 2.0 and .NET Framework SDK v2.0. Also there is MS SQL Server Compact Edition 3.1 and SQL Server CE 3.1 SDK installed (all in german). My OS is Windows XP SP2, all updates are done and I'm using SharpDevelop 2.1.0.

You need to add a reference to the SQLCe engine (system.data.SqlServerCe) in your project. If you create a new Data Connection in the Server Explorer in Visual Studio, and use it to build a Data Source, the path of the needed DLL will be added to your project. On my system it's located at C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll.

I discuss the details of this in my EBook.

hth

|||

Thanks a lot for your answer!

I found the "error" myself, or at least a solution for this problem. It was not because of the missing reference to the system.data.SqlServerCe, because I already added this reference before and compiling didn't work. I just removed all the references from my project and added them manually, referencing not the files in the GAC but selecting them from the .net framework sdk-folder/compact framework (As I can rememember it is something like: C:\Programme\Microsoft .NET\.Net Framework SDK\Compact Framework\....). Don't ask me why it works this way, but i'm able to compile now and everything works fine. Is it possible that the versions of the referenced assemblies in the GAC are not for the compact framework?

Reduction of Query Execution Time of Larger Database in SQL

I am having a database in SQL which is of size 6GB. My application will be
logging the data into database, which makes increases the size of
database.(currently it is growing by 10%).
I am running a query againest the database, which refers many tables, which
is taking around 5 Minutes. I am having many such queries which i use to
generate the reports. Now i want to reduce the Query Execution time, without
deleting the data. I am thinking of the below 4 possibilities:
1) Indexing has to be introduced/modified.
2.) We may restrict the database growth by specifying the size (currently it
is growing by 10%).
3.) Moving the inline sql to the database level as stored procedures
4. )Breaking the large and complex queries into fragments (Needs some
database expert
Which of the above options is better. Is there is any other way to reduce
the Query Execution time?> 1) Indexing has to be introduced/modified.
You can never have efficient queries on tables of that size without
proper indexing. This is a must.

> 2.) We may restrict the database growth by specifying the size (currently
> it
> is growing by 10%).
What are you going to do about new rows? You can't simply stop growth by
setting a limit on the size. Well you can but you will get errors when you
attempt to insert new rows after you reached that size limit.

> 3.) Moving the inline sql to the database level as stored procedures
That is always a good idea.

> 4. )Breaking the large and complex queries into fragments (Needs some
> database expert
Hard to say. I would tackle the others first.
Andrew J. Kelly SQL MVP
"uday" <uday@.discussions.microsoft.com> wrote in message
news:90B8A1F9-07A5-45E0-BB63-605BB4F86634@.microsoft.com...
>I am having a database in SQL which is of size 6GB. My application will be
> logging the data into database, which makes increases the size of
> database.(currently it is growing by 10%).
> I am running a query againest the database, which refers many tables,
> which
> is taking around 5 Minutes. I am having many such queries which i use to
> generate the reports. Now i want to reduce the Query Execution time,
> without
> deleting the data. I am thinking of the below 4 possibilities:
> 1) Indexing has to be introduced/modified.
> 2.) We may restrict the database growth by specifying the size (currently
> it
> is growing by 10%).
> 3.) Moving the inline sql to the database level as stored procedures
> 4. )Breaking the large and complex queries into fragments (Needs some
> database expert
> Which of the above options is better. Is there is any other way to reduce
> the Query Execution time?|||> 1) Indexing has to be introduced/modified.
Definitely a good idea. Use SQL Profiler and the Index Tuning Wizard on a
typical DML load.

> 2.) We may restrict the database growth by specifying the size (currently
it
> is growing by 10%).
Why? Just make sure to backup your data regularly, including frequent
Transaction Log backups.

> 3.) Moving the inline sql to the database level as stored procedures
That might seriously improve performance.

> 4. )Breaking the large and complex queries into fragments (Needs some
> database expert
Be careful not to break the ACID properties of any transaction. Read more
here:
http://msdn.microsoft.com/library/d...r />
_2it2.asp
ML|||Hi actually my database has the indexes andprimary keys. Only 1 0r 2 tables
are not having indexes , but they are having proper primary keys and foreign
keys. I only meant to modify them also. After proper indexing also it is
taking too long. For Ex one query took 25 minutes to execute today. I want t
o
reduce that execution time. So can u please say what are the other measures
which i can use.
"ML" wrote:

> Definitely a good idea. Use SQL Profiler and the Index Tuning Wizard on a
> typical DML load.
>
> Why? Just make sure to backup your data regularly, including frequent
> Transaction Log backups.
>
> That might seriously improve performance.
>
> Be careful not to break the ACID properties of any transaction. Read more
> here:
> http://msdn.microsoft.com/library/d.../>
06_2it2.asp
>
> ML|||For this we'd have to see the DDL and some sample data.
ML

Reduce Disk I/O when writing to MS-SQL Server database

Hi All,
An application is writing to the SQL Server database for every few
millisec. The disk I/O LED is continuously glowing when writing to the
database. Is there a problem with the configuration of the database ?.
How do i reduce the disk i/o when writing to the database. the
application is writing to the database using the 'insert' sql statement.Hi
Just a guess.
Check out that dusring the inserting you don't have page splits.
I think you have RAID5 disk configuration which is probably not the best
choice for SQL server because it imposes
a significant IO hit on write performance (both data and parity info must be
written)
<vanisathish@.gmail.com> wrote in message
news:1125888842.735920.102570@.z14g2000cwz.googlegroups.com...
> Hi All,
> An application is writing to the SQL Server database for every few
> millisec. The disk I/O LED is continuously glowing when writing to the
> database. Is there a problem with the configuration of the database ?.
> How do i reduce the disk i/o when writing to the database. the
> application is writing to the database using the 'insert' sql statement.
>|||I am running sql-server on a desktop PC with 1GB of RAM and 60 GB
Harddisk. There are so many other threads running on the system. And
the application that writes to the sql database use the 'insert' sql
statement. do i need to use SQL stored procedure for this ?
Normally what is the approach that will be used to write to the sql
database from a VC++ application using ODBC|||Hi
SQL Server's perfomance will benefit from using stored procedures instead of
'insert' statements from the client
http://www.sql-server-performance.c..._procedures.asp
<vanisathish@.gmail.com> wrote in message
news:1125898974.662403.62110@.g47g2000cwa.googlegroups.com...
>I am running sql-server on a desktop PC with 1GB of RAM and 60 GB
> Harddisk. There are so many other threads running on the system. And
> the application that writes to the sql database use the 'insert' sql
> statement. do i need to use SQL stored procedure for this ?
> Normally what is the approach that will be used to write to the sql
> database from a VC++ application using ODBC
>|||Every transaction need to do physical I/O, otherwise, you couldn't trust the
data to be persisted
when you do commit. You can reduce the amount of I/O by combining several mo
difications in one
transaction, but you also need to consider transaction semantics as well as
blocking.
Make sure you don't have ODBC tracing turned on, btw...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<vanisathish@.gmail.com> wrote in message
news:1125898974.662403.62110@.g47g2000cwa.googlegroups.com...
>I am running sql-server on a desktop PC with 1GB of RAM and 60 GB
> Harddisk. There are so many other threads running on the system. And
> the application that writes to the sql database use the 'insert' sql
> statement. do i need to use SQL stored procedure for this ?
> Normally what is the approach that will be used to write to the sql
> database from a VC++ application using ODBC
>|||How much data are you writing? And how long does it take? Adding another
drive might help if you put the log on it, but running heavy operations on a
single processor, single disk, low memory system with lots of other stuff
running is not likely to run better. This can be made even worse if you
happen to have a very fragmented disk or (and this is the killer) you need
more than a GB of RAM and you have to do virtual memory paging.
As far as stored procedures, if you are doing many insert statements, a
stored procedure might help, but if it is just a single statement taking a
long time, then it is not likely.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
<vanisathish@.gmail.com> wrote in message
news:1125898974.662403.62110@.g47g2000cwa.googlegroups.com...
>I am running sql-server on a desktop PC with 1GB of RAM and 60 GB
> Harddisk. There are so many other threads running on the system. And
> the application that writes to the sql database use the 'insert' sql
> statement. do i need to use SQL stored procedure for this ?
> Normally what is the approach that will be used to write to the sql
> database from a VC++ application using ODBC
>|||Actually i am not writing to much of data to the database. I will be
writing around 50 - 100 bytes of data to 9 tables. This writing happens
very often to some of the tables of the order of few millisec.
Currently i'm running a IIS web-server and some other application
servers which continuously polls some devices for every 250 msec
I see the harddisk LED glowing continuously, when the data logging is
ON ie. when writing to database happens.
As i said earlier the desktop PC is having 1GB of RAM and 60 GB
harddisk and is running win XP
I'm thinking of running the database server on a separate PC. Will that
solve my problem ?|||On 5 Sep 2005 00:59:38 -0700, vanisathish@.gmail.com wrote:
>Actually i am not writing to much of data to the database. I will be
>writing around 50 - 100 bytes of data to 9 tables. This writing happens
>very often to some of the tables of the order of few millisec.
SQLServer will insist on doing at least TWO physical writes to the
disk for every transaction, one for the log, the other for the real
database.

>Currently i'm running a IIS web-server and some other application
>servers which continuously polls some devices for every 250 msec
>I see the harddisk LED glowing continuously, when the data logging is
>ON ie. when writing to database happens.
Try using perfmon to get more accurate data, the LED stays on long
enough for you to see, even if the disk is busy only for a fraction of
that time.

>As i said earlier the desktop PC is having 1GB of RAM and 60 GB
>harddisk and is running win XP
Best SQLServer performance requires putting the log on a separate
physical disk, perhaps you begin to see why!

>I'm thinking of running the database server on a separate PC. Will that
>solve my problem ?
It may, but you should also consider getting a big, fat server-class
machine and not a desktop.
You might also consider writing some middleware that accumulates your
data for a couple of seconds at a time before writing it.
You haven't said anything about the schema of the tables you're
writing to, do you mean you always write to 9 tables? Do they have
PKs? What kind of PKs? Any other indexes? Any other DRI?
All that said, what the heck, let the little light stay on, that's
what it's there for!
But again, get some better numbers with perfmon and profiler.
J.|||On 5 Sep 2005 00:59:38 -0700, vanisathish@.gmail.com wrote:
(snip)
>I'm thinking of running the database server on a separate PC. Will that
>solve my problem ?
Hi vanisathish,
What exactly IS your problem? The only thing I've seen so far is that
your Disk I/O LED is glowing continuously - frankly, I'd be much more
worried if it did not glow! Why do you think that this is a problem?
SQL Server writes modifications to disk in two ways. The actual data in
the tables is cached - changes are written to the internal memory
structures only; the changes are flushed to disk at regular intervals or
when the server is shut down. But in order to prevent data loss on power
outage and other disasters, all changes are also written (in a compact
format) to the transsaction log - and these writes are NOT cached (and
they should not be, because you'd otherwise still lost this data on a
power failure).
If your database processes changing data at millisecond intervals,
you'll be writing to the log file in millisecond intervals.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Can you please help me to find out what information should i collect
using the perform and profiler.
I collected the Avg Disk Queue length and the % processor time. the
Avg.Disk Queue length is always on top of the graph(100%). The %
processor time is also high around 95 in the graph. most of the time it
stays at 30 - 35.
I'm trying to figure out why this is happening. please bear with me.
i'm quite new to database
About my schema, actually the 9 tables are independent tables. and each
of them have a primary key. And the server application will keep
writing to these tables

Re-do replication for new release

We alter the database schema that our production application uses with almost every release. Is there a way to basically remove the replication and re-do it for all tables / views at one time? Then we could just "rebuild" the replication with every release. We have about 200 tables and 200 views that have many dependencies. I'm sure it could be done with scripting and the stored procedures, but I'm new at this and not sure where to start. Any ideas? Thanks!

Yes, you could script out all the replication settings (publication, articles, jobs, subscriptions, etc) using the UI, then remove replication completely from the publisher as well as subscriber and after you do the schema changes to the databases, then use the scripts to setup replication again on the new release.

But however note that there are always differences between releases. There could be slight differences in the way they are scripted out and the way they are handled in the new release. With that in mind, you may have to slightly edit the scripts before running them on the newest version.

Also, I would first test it out on a test systems before trying it on the production servers.

Also note that With SQL Server 2005, schema changes to the tables are replicated to the subscriber. So for example, if you add a new column to one of the replicated tables, that new column will be replicated to the Subscriber when configured appropriately.|||Thank you Sir, for your suggestions. I will give them a try.