GDI Lord (12/11/2007)

---

Here is an example where a PK might be detrimental to performance: a compound PK consisting of two GUIDs with the next three columns being ints and the...

A table with a single row needs a primary key to insure that there can only be one row. The normal way to accomplish this is to define a...

Take a look at the output from these scripts.

Get Server Database File Information

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

Script to analyze table space usage

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

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...