"Ten",

The link you gave me pointed me to this one:

http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407

That pages contains all types of variations of AdventureWorks (x86, x64, DW, OLTP, etc). I downloaded "SQL2008.AdventureWorks_All_Databases.zip" and when I...

Good replies but let me change the scenario a bit: suppose I am now upgrading a database from say sql 2005 to sql 2008. Other than using the upgrade wizard...

HTH,

Your response hit on my confusion. If I restore a prod DB in a Dev environent and don't rebuild indexes or update staisticis in Dev shouldn't the DB's offer similiar...

I have read that "lock pages in memory" only applies to 64-bit Enterprise editions of sql. Ours is Sql Standard so it does not apply to us.

Barkingdog

>>> Do you mean the transaction log back-up?

Yes, somehow I couldn't think of the words yesterday!

Barkingdog

I verified it. One does need VS.NET 2008 SP1 installed before the sql 2008 client tools can be installed on the same box.

Barkingdog.

"GrumpyOLDDBA" wrote

>>> I'd suggest you get the sql performance dashboard from connect,

What is connect? Can you provide a URL?

Barkingdog

Thanks to everyone for some great replies.

Barkingdog

I am now trying to link the servers from Management Sutdio,

In the Linked Server box I type "ServerB', Server type: SQL Server. On the Security tab I select "Be...

I'm trying to understand what you meant. Here's my understanding:

The account on ServerA, of course, does not have direct access to the databases on remote server B. (I am using...

After increasing the RAM available to sql server ( to 12 GB) today I have not seen the CPU percentage rise to over 50% for sql server. Much better.

The problem...

The box is a ProLiant DL 380 G5 with 16GB of RAM. The OS is Windows 2003, Std x64, R2. Sql is sql 2005, x64 with SP2. It has...

All interesting ideas. Regarding the last one

>>>

update TableA

set myflag = 1

from TableA join TableB

on

(TableA.key = TableB.key)

and

(

...

Thank You,

I like that idea.

Barkingdog

Great answers from everyone. Thanks,

barkingdog