Are you really sure about the size of this database? Maybe it is really 400 GB?

400 TB would make it one of the world’s largest databases and I seriously...

Take a look at these threads:

Truncate All Tables

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

Find Table Reference Levels

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

Since Charlton Heston didn't say that, I'm not...

The command line utility from Intel that I posted the link to seems to give all the info that is required.

I have used it with many servers, old and new,...

jcrawf02 (7/30/2008)

---

If you aren’t the lead dog, the view never changes.

Populate a temp table with the results of your dynamic SQL select statement, and then open the cursor on a select from the temp table.

MrBaseball34 (7/30/2008)

---

*MOST* good...

What Windows edition are you running: Standard, Enterprise, etc.

select

EMPID,

SALARY,

MODDATE

from

MyTable a

join

(

select

bb.EMPID,

MODDATE = max(bb.MODDATE)

from

MyTable bb

group by

bb.EMPID

) b

on a.EMPID = b.EMPID and a.MODDATE = b.MODDATE

order by

a.EMPID

I just ran it, and the info seems pretty clear to me: No Hyper-Threading, 8 cores, 4 cores per package, 2 physical processors, all cores in use.

Capabilities:

...

Intel provides a command line utility for this:

http://softwarecommunity.intel.com/articles/eng/1957.htm?target=http%3A%2F%2Fwww.intel.com%2Fcd%2Fids%2Fdeveloper%2Fasmo-na%2Feng%2F276610.htm

Here are three free online tutorials:

http://www.sql-tutorial.net/

http://www.firstsql.com/tutor.htm

http://www.w3schools.com/sql/default.asp

These are the primary Microsoft SQL Server References:

SQL Server 2000 Books Online

http://msdn2.microsoft.com/en-us/library/aa257103(SQL.80).aspx

SQL Server 2005 Books Online

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

This check constraint should work also:

alter table dbo.MyTable

add constraint CHK__MyTable__MyDate_time_is_midnight

check ( MyDate = dateadd(dd,datediff(dd,0,MyDate),0) )

I don’t think there is much use for Application roles except for client server applications.

Most of our applications are web based and end-users do not have logins in the database....

Danster (7/24/2008)

---

There's nothing "at play".

I just like editing data directly in a multi-table view. It is fast, easy, safe (if you're careful) and convenient.

Usually it is to quickly make...