Thanks for the fast answer,...

I have examined the "Always re-create database" flag and I must determine that the resulting sql scripts are the same, activated and deactivated?!?! 🙁

Why?

I have only one project in my...

Hi Grant,

thanks for the answer. Have you checked it? I have deactivate the "Always re-create database" option in sqldeployment settings, but the resulting script is already with code part of...

For example if you have to create a trigger for a table with 100 columns and in your trigger you should only execute a statement if one special column would...

For example if you have to create a trigger for a table with 100 columns and in your trigger you should only execute a statement if one special column would...

Yes, it is.

In relation to your question about the if update statement:

You don't have to take the if update statement, the update of the column is enough without check, because...

Thanks Grant.

I will try it, but it makes sense ;-).

Perhaps you can help me with my other topic:

http://qa.sqlservercentral.com/Forums/Topic1098607-23-1.aspx

Thanks in advance.

The update function returns true if the written column was inserted or updated. In this way you can prevent execution of the update statement...

And the disk drive is RAID X??? Or is that a default consumer hard disk?

Have you checked the performance monitor to track "Avg read/sec", "Avg write/sec", "Avg sec/read", "Avg sec/write"?...

Ian Scarlett (4/27/2011)

Well...

What storage your sql server is connected with? SAN?

Have you distributed the OS, the data and log files over separate disks?

What are the results of the script?

Hi,

please post details of the server. What server is it? Is it virtualized? What about the memory and storage?

What other databases are running on this server?

But you can check whether...

Hi,

you can reduce this with at least reorganizing these indexes.

You can write a sql script with a cursor over all indexes to update and reorganize these indexes.

Unfortunably I have currently...

Hi,

first thing is: to make it more readable for me and the other viewers you should use the IFCode-Parts to identify sql code ... and in most cases it would...

Hi,

we are testing our procedures with Visual Studio 2010. It has the Capability to write Unit tests for SQL procedures without programming C#.

First you need to create a database project...