You should run UPDATE STATISTICS on all tables after restoring a database from 2000 to a 2005 server.

This whole debate is absurd.

Removing DRI for performance reasons is a very bad idea. Relational databases are not used for performance reasons; they are used to store the data...

Dave (11/29/2007)

If you didn't take into account wage differences, and you really...

If you really think about it, it is the US that is growing fast in IT.

The IT growth in India, China, and the Philippines is to satisfy the demand for...

You can start the second job using a stored procedure call in the first job.

execute msdb.dbo.sp_start_job @JobName

The function on this link should give you what you want.

Start of Week Function:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

select

Date,

[Week stating Monday] =

dateadd(dd,(datediff(dd,-53690,a.DATE)/7)*7,-53690)

from

MyTable a

There is nothing wrong with page lookups per second being high. All that counter really means is that SQL Server is accessing pages that are already in memory. ...

If you are going back to school to get another degree, get an advanced degree, not another Bachelor’s degree.

I don’t think a degree in CS is necessary to be a...

The script in the link below will give you the information you want.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

For it to do what you want, InvoiceDate must be part of the primary key on each table that is part of the view.

Since you do not have a primary...

Would it be possible for you to post the DDL statements for the tables and the view?

The size of the backup is about equal to the amount of space used in the database. The link below will give you the size of all databases on...

Bhavani Taninki (11/21/2007)

Select

Income,

Expense,

(

(Cast(Income as Float) - Cast(Expense as Float)) / Cast( ISNULL(NULLIF(Income,0),1) as Float)

) * 100 As percentageexpense

FROM

(

select income =4, expense =3

union all...

Worst advice ever! That's a real rookie...

I think this may be simpler:

while 1=1

begin

fetch ...

if @@fetch_status <> 0 break

if dbname in ('northwind','pubs')

begin

.. send email or whatever ...

continue

end

... rest of stuff in cursor loop ...

end