I ignore all private messages. Not that I get many.

It might be good to have a setting to allow you to turn off private messages, so that people don't...

Jeff Moden (8/5/2008)

---

Michael Valentine Jones (8/5/2008)

---

I believe there is still a limit of 256 tables in a query (haven't verified that, so I could be wrong), so if you have...

Jeff Moden (8/1/2008)

---

With the advent of VARCHAR(MAX), there's just no need for cursors anymore... for example...

DECLARE @sql VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL+CHAR(10)+' UNION ALL --------------------'+CHAR(10),'')

+REPLACE(

' SELECT ''...

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